|
Subject:
|
Automatically run some codes in SQL server 2005
|
|
Posted By:
|
Andraw
|
Post Date:
|
6/2/2008 10:48:09 AM
|
Hi, all,
My problem is that our client will ftp some daily data file to us, and we will create a program to get the ftp file, read it and store the data to our database. I know this work will be done in SQL server, can anybody give me some detail step about how to do this in SQL server 2005? what security issue we need to solve to make it work?
I am a newbie in SQL server 2005.
A lots of thanks!
Andraw
|
|
Reply By:
|
jemacc
|
Reply Date:
|
6/4/2008 9:40:23 PM
|
You can use the FTP Task in SQL Server Integration Services (SSIS) Make sure you have service pack 2 as some issues were fixed related to the ftp task.
Jaime E. Maccou
|
|
