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 |
|
masterdineen
Aged Yak Warrior
550 Posts |
 Posted - 2009-10-05 : 09:57:02
|
| What is the best way of setting up in ssis to import file from ftp into sqlserver table. RegardsRobMCTS certified |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-10-07 : 04:54:45
|
| The best way would depend on your environment and requirements:- do you use a DMZ for ftp?- do you require secure FTP? - where do you store connection details?- multiple files, size of file, etcAnd when uploading:- is the file encrypted?- do you use a staging table?- error handling- data qualityIf your requirement is simple, you can use the FTP task in SSIS.We use batch files for our FTP jobs, that get called from SSIS. Now looking to move the FTP part into a Scheduling Tool (more secure). |
 |
|
|
|
|
|
Import file from ftp into S'Server Table