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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 SSIS

Author  Topic 

surpreeti
Starting Member

1 Post

Posted - 2011-04-08 : 04:32:20
I want to create a SSIS package which will be basically watch the folder for the back up file and then will copy it onto the FTP site
Requirements:
1. Check a designated folder (specified in a global variable) for files changed since last run date.
2. When a new file is available FTP the file to a designated server, overwriting the file if it already exists on the remote server.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2011-04-08 : 07:37:10
Look here for an idea:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=101943


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -