Post reply

DTS Package running on Server A and Source file running on Server B

  • January 25, 2007 at 3:13 pm

    #92192

    I have SQL Server 2000 running on a dedicated database Server A and a text file which resides on Server B.  My constraints are: I am not allowed to save the text file (which is the source file used by my DTS package) on Server A nor am I allowed to map Server B on Server A and vice-versa in Windows Explorer.  When I log on to Server A to set up my DTS package in Enterprise Manager, how can I make the source file located on Server B visible to Server A during the DTS package setup?

  • January 25, 2007 at 3:44 pm

    #685719

    Use the UNC path in the filename property of the TextFile Source Connection object in your DTS package.  You will have to make sure that you (and the SQL Agent if you will be scheduleing the job) have permissions to the directory on Server B.

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • January 25, 2007 at 3:44 pm

    #685718

    Use a UNC filepath in the source connection e.g. \\server\folder\file rather than a mapped drive.

    Greg

    Greg

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

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