I've created a DTS package which creates a SQL server 2000 database
table and then imports data from a .TXT file on the FTP server. My
problem is this: I am allowed to select the source file using Network
Neighborhood but the File Name that shows up in the Properties of my
Connection (for the stored DTS package) is a reference to a C drive
file under the Temporary Internet File directory. I thought I would
be able to directly copy it from the FTP site to the SQL server. Does
anyone know why I am unable to do so? I'm assuming that it is
creating a temporary file in the place of the direct import but I'm
not sure if it must be this way or if its operator error. Do I need
to run a Task to FTP the file to a network directory first and then
import it from there? Your clarification and assistance is greatly
appreciated. Thanks.
table and then imports data from a .TXT file on the FTP server. My
problem is this: I am allowed to select the source file using Network
Neighborhood but the File Name that shows up in the Properties of my
Connection (for the stored DTS package) is a reference to a C drive
file under the Temporary Internet File directory. I thought I would
be able to directly copy it from the FTP site to the SQL server. Does
anyone know why I am unable to do so? I'm assuming that it is
creating a temporary file in the place of the direct import but I'm
not sure if it must be this way or if its operator error. Do I need
to run a Task to FTP the file to a network directory first and then
import it from there? Your clarification and assistance is greatly
appreciated. Thanks.