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

Content with tags Integration Services (SSIS), Foreach Loop container Rss

   Items 1 to 3 of 3   

Continue a Foreach loop after an error in a SQL Server Integration Services package

Say you have a SQL Server Integration Services (SSIS) package with a Foreach Loop container. Inside that container you have a task that sometimes can fail. Koen Verbeeck provides a tip on how to implement SSIS so that, if it fails, the loop will just continue, skip the current step and go to the next iteration.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 6,408 reads

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: | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 5,691 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: | Category: ftp
Rating: |  Discuss |   Briefcase | 7,944 reads
   Items 1 to 3 of 3   
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)    
stored procedures (1)    
variables (1)