Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
infodemers
Posting Yak Master
183 Posts |
 Posted - 2010-03-10 : 13:50:55
|
I need to connect to a FTP server and get .DAT files with certain created date. Then, I wish to import the data into a SQL table.How would you suggest me to do it using SSIS?Thanks for any help! |
|
|
sportrx
Starting Member
4 Posts |
Posted - 2010-05-20 : 17:29:35
|
| two folds to yoru questions.1. FTP2. extract data and load into a table.FTP-- there is an ftp task, it is simple and easy to follow there are many example out there look it up.Extraction.1. can you open the file in text file?If it does, change the ext to txt. then use data flow task reading one from flat file to OLe DB.you can do the transformation in ssis or once the data are in SQL SERVER, you can extract using t-sql |
 |
|
|
|
|
|
Import raw data from FTP server