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

Content with tag OLE-DB Connection Rss

   Items 1 to 4 of 4   
 

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

Force installation of 64-bit ACE OLE DB provider

Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...  Read more...
By Koen Verbeeck 2013/04/25 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 4,997 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,102 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,717 reads
   Items 1 to 4 of 4   
 
Tags
integration services (ssis) (3)    
blogs (1)    
flat file connection (1)    
merge join (1)    
raw file connection (1)