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

Content with tag 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,852 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 | 1,527 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,529 reads
   Items 1 to 3 of 3   
 
Tags
integration services (ssis) (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 (1)    
ssdt (1)    
store procedure (1)    
variables (1)