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 |
|
sql_newbie121
Yak Posting Veteran
52 Posts |
 Posted - 2010-02-25 : 10:50:25
|
| There is an FTP Server from which file needs to be picked up in CSV format. I have to load data from this file into a SQL table 3 times a day. My question is: how can I pickup this file from an FTP server and load this data into SQL table and this job should be automated.Let me know if the question is not clear. |
|
|
sql_newbie121
Yak Posting Veteran
52 Posts |
Posted - 2010-02-25 : 11:13:34
|
| Also, i have to move this CSV file to a different location after the job is completed. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-25 : 14:13:25
|
| FTP Task in SSIS package |
|
|
|
sql_newbie121
Yak Posting Veteran
52 Posts |
Posted - 2010-02-25 : 16:29:34
|
| Russell:Thanks but i do not know how to configure it. I have been looing on several sites but am not being able to do it. I think i can download the file from FTP and load into SQL server table but i am not being able to think to copy a file from a local machine to another machine after the data load is completed. How would i do this task? Thanks |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-25 : 16:41:08
|
| what version of SQL Server are you working with?Basically, I'd create a SQL Agent Job:1. Execute SSIS- a. FTP File- b. Bulk Insert the data to SQL table2. OS Command to move/copy file to new location |
|
|
|
sql_newbie121
Yak Posting Veteran
52 Posts |
Posted - 2010-02-25 : 16:49:17
|
| I am working on SQL Server 2005. |
|
|
|
|
|
|
Automating Job on data load