Post reply

Accessing DTS in SQL Server 2005 from VB6

  • January 27, 2009 at 9:29 am

    #134084

    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.

  • January 27, 2009 at 10:50 am

    #933381

    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

  • January 27, 2009 at 10:54 am

    #933384

    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.

  • January 27, 2009 at 11:16 am

    #933404

    Ask this on the SSIS forum.

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

    Bet you will get a better shot.

  • January 27, 2009 at 11:18 am

    #933406

    Thank you.

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

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