Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Foreach Loop container Rss

   Items 1 to 2 of 2   
 

Batch ETL of Multiple Data Files Using an SSIS Foreach Loop Container

An SSIS ETL package created with the Import/Export Wizard uses a Data Flow Task to process one data file at a time. If the need arises, however, the Data Flow Task generated by the wizard can be embedded inside a Foreach Loop Container to batch-process a continuous stream of data files.  Read more...
By Stan Kulp 2013/06/13 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 5,342 reads

Dynamically Download FTP Files Using SSDT

Dynamically initialise FTP connection using expressions and retrieve files stored in multiple FTP directories using SQL Server Data Tools  Read more...
By Sifiso W. Ndlovu 2013/03/11 | Source: SQLServerCentral.com | Category: ftp
Rating: |  Discuss |   Briefcase | 7,851 reads
   Items 1 to 2 of 2   
 
Tags
integration services (ssis) (2)    
adventureworks2012 (1)    
data flow task (1)    
execute sql task (1)    
expressions (1)    
ftp (1)    
ftp connection (1)    
import/export wizard (1)    
local path (1)    
remote path (1)    
server name (1)    
server password (1)    
server user name (1)    
sql server 2012 (1)    
sql server data tools (1)    
ssdt (1)    
store procedure (1)    
variables (1)