SQL DTS
-
Hi All, I am trying to get a file from an Ftp and Copy data (*csv file) on to one of my tables in SQL 2005 database. I am not sure but SQL server 2005 integration service has a way to create a package that allows me to do this task. Can any one tell me how to go about it? your ideas are much appreciated. Thank you
-
Hi All, I am trying to get a file from an Ftp and Copy data (*csv file) on to one of my tables in SQL 2005 database. I am not sure but SQL server 2005 integration service has a way to create a package that allows me to do this task. Can any one tell me how to go about it? your ideas are much appreciated. Thank you
Use the FTP task to copy the file to an accessable directory, then you can create a data flow task which uses a flat file source, processes the file and then puts the data in the appropriate data flow destination. Your package designer should resemble this:
FTP Task --> Data Flow TaskOpen the Data flow task (double-click) and it should resemble this:Flat File Source --> [intermediate transformations you may need (if any)] --> Sql Server DestinationJust drag the items mentioned to the designer surface, open each item and set the properties needed.Mark's blog: developMENTALmadness.blogspot.com