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), OLE-DB Connection Rss

   Items 1 to 3 of 3   
 

SSIS Basics: Using the Merge Join Transformation

SSIS is able to take sorted data from more than one OLE DB data source and merge them into one table which can then be sent to an OLE DB destination. This 'Merge Join' transformation works in a similar way to a SQL join by specifying a 'join key' relationship. this transformation can save a great deal of processing on the destination. Annette Allen, as usual, gives clear guidance on how to do it.  Read more...
By Additional Articles 2013/10/28 | Source: SimpleTalk | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 3,679 reads

Creating packages in code - OLE-DB Source to Flat File File Destination

This code sample programmatically creates a package with an OLE-DB Source and a Flat File Destination, and the resulting package exports data from SQL Server to a CSV file. The finished package just has the one Data Flow Task shown below.  Read more...
By Additional Articles 2009/02/10 | Source: sqlis.com | Category: integration services (ssis)
Rating: (not yet rated)  Rate this |   Briefcase | 2,088 reads

Creating packages in code - OLE-DB Source to Raw File Destination

This code sample programmatically creates a package with an OLE-DB Source and a Raw File Destination, and the resulting package exports data from SQL Server to a raw file. The finished package just has the one Data Flow Task shown below.  Read more...
By Additional Articles 2009/02/05 | Source: sqlis.com | Category: integration services (ssis)
Rating:  Rate this |   Briefcase | 1,712 reads
   Items 1 to 3 of 3   
 
Tags
flat file connection (1)    
merge join (1)    
raw file connection (1)