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), Stored Procedures Rss

   Items 1 to 4 of 4   
 

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

Implement a stack in SQL Server using stored procedures

In this article I will show you how to implement a stack.  In programming, stacks are a great way to...  Read more...
By Josef Richberg 2010/01/18 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,039 reads

Run SSIS packages from remote client with stored procedure

By utilizing service broker, xp_cmdshell and dtexec.exe SSIS packages can be run with a stored procedure.  Read more...
By Jason Rowland 2010/01/12 | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 8,040 reads

SSIS and Stored procedures using temp tables

SSIS has a problem with stored procedures that use temporary tables to generate output. This article describes a useful technique for working around this problem.  Read more...
Rating: |  Discuss |   Briefcase | 13,348 reads
   Items 1 to 4 of 4   
 
Tags
adventureworks2012 (1)    
blogs (1)    
execute sql 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)    
service broker (1)    
sql server 2005 (1)    
sql server 2012 (1)    
sql server data tools (1)    
ssdt (1)    
stack (1)    
temp tables (1)    
temporary tables (1)    
variables (1)