Solved

RE : WIndow Service

Posted on 2011-03-21
4
289 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now