Showing posts with label dtsx. Show all posts
Showing posts with label dtsx. Show all posts

Thursday, March 22, 2012

DTS Packages (.dtsx) and Automation through C#

I have spent the last couple of weeks going through about 15-20 different examples/tutorials on running DTS packages from inside a C# Windows app (and even asp.net). I must have a mental block, because I can't seem to make it click in my head. I have hundreds of DTS packages saved as .dtsx files. I can double click on them and run them perfectly. What I need to do is be able to run them conditionally from inside a windows app. Could anyone point me to a tutorial or example that could help me with this? I've even looked at some VB source to see if I could work it out, but I keep running up against a wall. I'd appreciate any help anyone can provide.

I just realized, if there is a better forum for me to post this in, please let me know that also.

Friday, February 24, 2012

DTS job

Hi,

If my one .dtsx jobs calls another .dtsx jobs, how this situation should be taken care?Please help me out on this.

Regards

Nitu

You should use the ExecutePackage task. See http://msdn2.microsoft.com/en-us/library/ms137609(SQL.90).aspx

Donald Farmer