Post reply

Custom DTS package and Server

  • August 8, 2005 at 9:31 pm

    #88600

    Hi:

    I have generated vb script for  a custom dts package (to import data from a text file to a sql server table) and it  works with a vb program with UI.  The dts package works on my pc where I have sql server installed and when I create instance of the server operations on my local pc.  The server also has the sql server installed (data and program exist on the same server).  The dts package on server executes but does not import data data to the table.  How can I make the dts package to work on server side as well?

    Thanks

    su

  • August 10, 2005 at 1:59 pm

    #581178

    Does the server have access to the text file / directory?

  • August 12, 2005 at 6:56 am

    #581733

    Thank you. The server was not accessing the file.  I resolved it.

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

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