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: | Category: ftp
Rating: |  Discuss |   Briefcase | 7,897 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,600 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,619 reads
   Items 1 to 3 of 3   
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)    
stored procedures (1)    
variables (1)