Accessing DTS in SQL Server 2005 from VB6

  • We upgraded from SQL Server 2000 to 2005 and although I can use the DTSs created in the 2000 version, (DTSP), how can I have the same access to a DTS created in the 2005 version (.dtsx)???

    I created the DTS and debugged it with the SQL Server Business Intelligence Development Studio, but now I need to automate the process.

  • I'm not sure what your question is. I think you're saying you've created a package (SSIS, not DTS) and you want to know how to deploy it to a SQL Server so it can be scheduled in a job. Is that correct? Have you read about package deployment in Books OnLine?

    Greg

  • I know how to deploy it via SQL Server Business Intelligence Development Studio.

    The problem is that this application is to run unattended and I need to execute (invoke) it from a VB6 application.

    When I had the DTS created in version 2000, I used the dtsp method to invoke it. But it doesn't work when attempting to invoke a DTS/SSIS package created in version 2005.

  • Ask this on the SSIS forum.

    http://www.sqlservercentral.com/Forums/Forum148-1.aspx

    Bet you will get a better shot.

  • Thank you.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply