Solved

RE : WIndow Service

Posted on 2011-03-21
4
295 Views
Last Modified: 2013-11-10
Hi,

How to write code and create window service for executing DTS package.
Any tutorial or sample code for the same will be more helpful

Thanks
0
Comment
Question by:rajneesh1978
4 Comments
 
LVL 10

Assisted Solution

by:khan_webguru
khan_webguru earned 250 total points
ID: 35179970
I think this is what you want
Have a look into the below link, it has the sample windows service code that executes a DTS package,


Creating a Windows Service Application that invokes the DTS

http://15seconds.com/issue/030909.htm

Regards,

Asif Ahmed Khan
0
 
LVL 16

Accepted Solution

by:
carsRST earned 250 total points
ID: 35183454
Here is c# code to invoke a remote SSIS job.
http://www.codeproject.com/KB/database/CallSSISFromCSharp.aspx

You probably have your reasons, but I would highly recommend using SQL Server agent to invoke your job.
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 35414325
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
Performance in games development is paramount: every microsecond counts to be able to do everything in less than 33ms (aiming at 16ms). C# foreach statement is one of the worst performance killers, and here I explain why.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question