Hi Ryan, how is the DTS package going to be invoked - via a sql server job? Use a local copy of the text file to setup the import profile, then manually update the file path to the correct path for the sql server.
Elliot "Ryan Sabir" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Hey all, > > I'm trying to set up a DTS task on a remote server to import a text > file on a regular basis for a site. This is in MS SQL 2000 by the > way... > > When I connect to the server and go to specify the source file, its > giving me the directory tree of my local machine, instead of the > server. Once the task gets going, my machine won't exist so why is it > trying to reference a file on my machine? > > How do I get it to reference a local text file? If I type the path to > the file, it doesn't let me OK the dialog box, as it says it can't > find the file. > > Can anyone explain this great mystery? > > Thanks for any help... > > > ----------------------- > Ryan Sabir > Newgency Pty Ltd > 2a Broughton St > Paddington 2021 > Sydney, Australia > Ph (02) 9331 2133 > Fax (02) 9331 5199 > Mobile: 0411 512 454 > http://www.newgency.com/index.cfm?referer=rysig > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
