Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Download and extract files from remote server Expand / Collapse
Author
Message
Posted Thursday, October 17, 2013 5:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 12, 2014 3:03 AM
Points: 28, Visits: 73
All the ftp details are variables that get data from a database table and loop through the resultset.
Post #1505606
Posted Thursday, October 17, 2013 5:12 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:26 AM
Points: 13,622, Visits: 10,514
dorothy.burton (10/17/2013)
All the ftp details are variables that get data from a database table and loop through the resultset.


Your point being?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1505607
Posted Thursday, October 17, 2013 5:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, May 12, 2014 3:03 AM
Points: 28, Visits: 73
how do I set the variables for the FTP task?
How to assign values to the variables at run time?
Post #1505621
Posted Thursday, October 17, 2013 5:29 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 11:26 AM
Points: 13,622, Visits: 10,514
dorothy.burton (10/17/2013)
how do I set the variables for the FTP task?
How to assign values to the variables at run time?


You use expressions on the properties of the FTP task.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1505622
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse