Hi there,
I'm trying to create a DTS package that will automatically import a txt delimited file as a table into SQL. I have no problem doing this manually using the import/export. Now here's the catch. I need the file to be grabbed automatically from an FTP location. I know that there is functionality in DTS design that will grab a file from an FTP location BUT then it asks for the destination as a local computer destination. I can't have it this way. I need for it to be able to be executed from the server without a local computer being necessary to temporarily save. In other words... so in other words i dont want it to be FTP->Local Computer->SQL Server->Output Data to Website. I want it to be FTP->SQL Server->Output Data to Website. I can change the FTP path so that it is in a http location if that makes it any better. Thanks in advance!