February 19, 2009 at 8:53 am
Hello, I am new to SSIS and SQL Server 2005. Finally, I have an opportunity to touch and feel sql and BI stuff. I apologize in advance if my question is very generic or a repeat in this forum. My question is below:
Need help with the following:
SSIS package to do the following:
(1) Go to FTP server and authenticate using credentials
(2) Grab 4 .csv files from a folder and dump them into a
shared folder in database server.
(3) SSIS package to import these 4 files and processed them
into database tables.
(4) Once these files are processed by SSIS package, time stamp these files and
dump them into another subfolder in database server for
archiving.
(5) Create a schedule to run SSIS package every morning at
5:30 AM
Thank you.
February 19, 2009 at 11:20 am
Sanjeev Jha (2/19/2009)
Hello, I am new to SSIS and SQL Server 2005. Finally, I have an opportunity to touch and feel sql and BI stuff. I apologize in advance if my question is very generic or a repeat in this forum. My question is below:Need help with the following:
SSIS package to do the following:
(1) Go to FTP server and authenticate using credentials
(2) Grab 4 .csv files from a folder and dump them into a
shared folder in database server.
(3) SSIS package to import these 4 files and processed them
into database tables.
(4) Once these files are processed by SSIS package, time stamp these files and
dump them into another subfolder in database server for
archiving.
(5) Create a schedule to run SSIS package every morning at
5:30 AM
Thank you.
Hi,
Not trying to be rude but, have you tried any of these tasks yet?
Everything you describe should be fairly easy to do.
For FTP, there is a task already made for this, Just configure it.
Importing files is very east. Very similar to 2000 DTS, Create Source and destination connections.
Timestamping files can be easily done using the file system task and a small vb script task to create the name for the timestamp stamp.
Here is a good site with lots of tutorials
Give it a try, and if you have problems or questions, post the specific items you need help with.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply