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), vb.net Rss

   Items 1 to 6 of 6   
 

Basics of XML and SQL Server, Part 5: Generate/Transmit XML with SSIS

This SSIS package generates XML invoice documents from data stored in SQL Server, then FTPs and/or Emails them to clients.  Read more...
By Stan Kulp 2012/04/04 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 6,256 reads

Basics of XML and SQL Server, Part 4: Create an XML invoice with SSIS

This article demonstrates how to build an SSIS package that generates an XML invoice document from data stored in SQL Server and saves it to an XML file.  Read more...
By Stan Kulp 2012/03/28 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,722 reads

Basics of XML and SQL Server, Part 3: Transform and Shred XML in SSIS

This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.  Read more...
By Stan Kulp 2012/03/21 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 2,952 reads

A VB.NET toolkit for writing SSIS Script Tasks

This article demonstrates basic VB.NET code that will enable SSIS package developers to write useful custom SSIS script tasks.  Read more...
By Stan Kulp 2011/11/25 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 9,153 reads

No SFTP Task Component in SSIS 2005/2008? No Problem!

SSIS 2005 and 2008 have an FTP Task component, but no SFTP (SSH/TLS-encrypted FTP) Task component. This tutorial explains how to overcome this omission.  Read more...
By Stan Kulp 2010/05/11 | Source: SQLServerCentral.com | Category: integration services (ssis)
Rating: |  Discuss |   Briefcase | 12,261 reads

Custom VB.Net scripting in SQL Server Integration Services

Add a Script component and custom Visual Basic.Net (VB.Net) scripting to SQL Server Integration Services (SSIS) packages to get the full power of .Net.  Read more...
Rating:  Rate this |   Briefcase | 2,423 reads
   Items 1 to 6 of 6   
 
Tags
xml (3)    
c# (2)    
smtp (2)    
xslt (2)    
dynamic sql (1)    
ftp (1)    
openrowset (1)    
sftp (1)    
ssh/tls (1)    
t-sql (1)