Post reply

Executing a Package from VB

  • May 17, 2002 at 7:48 am

    #158332

    I've create a DTS package on SQL Server which simply imports a tab delimited text file into a table in SQL Server.

    I've referenced the Microsoft DTS Package Object Library in my VB project and written some code to load the package from SQL Server and execute it. This all works fine.

    The problem is the name of the text file is different each time the package is executed inside my VB project.

    How can I pass into the DTS package the name of the text file I wish to import, at runtime?

    Thanks in advance

  • May 17, 2002 at 8:44 am

    #429368

    You have the option of using a DTS solution like a global variable, or moving all the DTS code into your VB app so you can parameterize it how you wish.

    Andy

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

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