SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Integration Services (SSIS), Execute SQL Task Rss

   Items 1 to 3 of 3   

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,992 reads

SSIS Basics: Using the Execute SQL Task to Generate Result Sets

The Execute SQL Task of SSIS is extraordinarily useful, but it can cause a lot of difficulty for developers learning SSIS, or only using it occasionally. What it needed, we felt, was a clear step-by-step guide that showed the basics of how to use it effectively. Annette Allen has once again cleared the fog of confusion.   Read more...
By Additional Articles 2012/11/05 | Source: SimpleTalk | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 2,133 reads

Execute SQL and Bulk Insert Tasks in SSIS

Learn how the Execute SQL and Bulk Insert tasks can be combined to create a database and insert data into the database.  Read more...
Rating:  Rate this |   Briefcase | 2,995 reads
   Items 1 to 3 of 3   
adventureworks2012 (1)    
bulk insert task (1)    
expressions (1)    
foreach loop container (1)    
ftp (1)    
ftp connection (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 (ssdt) (1)    
stored procedures (1)    
variables (1)