Dear all,
I am looking for any snippet of code where you can launch a SSIS package by DMO or VB 6.0. I read that it was posible to call dts.runtime assembly from VB 6.0 but at first it might be converted or something like that.
Issue comes from the moment that we’ve got an ASP 3.0 scheduler for hundreds of dts and now we have to migrate them to sql25k.
Thanks in advance for any info regarding this,
Hey there Enric,
I'm no expert in SSIS.. but I AM reading the Wrox book "Professional SQL Server 2005 Integration Services" which has a chapter on using SSIS with external applications.
If you get the book just look at chapter 17 and you'll find the info you need.
OR you could go to Wrox.com and download the sample code for chapter 17. It contains sample VB to call an SSIS package.
Basically you have to use the Microsoft.SqlServer.Dts.DtsClient namespace...
You import that namespace and use it to connect to the package...
Imports Microsoft.SqlServer.Dts.DtsClient
Then use an DtsCommand to execute the the package.
I don't want to post Wrox's sample code here (don't want no trouble) but if you search in books online for DtsCommand you should find stuff....
Its a bit silly calling an SSIS package with a DtsCommand isn't it?
Very confusing..
PJ
|||The reason for the false naming is that the product was well into the development cycle when the decision was made to change the name from DTS to SSIS. That decision was actually made around Q3 2004, almost 4 years after development started.
At that late stage in the game it was considered too much of a job to go through and change all the code from DTS* to SSIS*. Its a shame but can't be helped.
Do as all techies do...blame the marketing department :)
-Jamie
|||On Books online at
http://msdn2.microsoft.com/en-us/library/aa337077.aspx
there's an extensive coverage on how to run SSIS packages remotely.
You may need to be a bit seasoned developer to go through it and run it though, as the documentation is not a step-by-step instruction.
Rgds,
