Welcome to MSDN Blogs Sign in | Join | Help

January 2009 - Posts

Wednesday, January 07, 2009 5:32 PM

Writing to a MySQL database from SSIS

A couple of users reported being unable to use the ADO.NET destination to insert data into their mysql databases. When I originally tried this out , it worked, but it seems like changes made since the early 2008 CTPs have made us incompatible with MySQL.
Posted by mmasson | 9 Comments
Filed under:
Tuesday, January 06, 2009 2:38 PM

SSIS portal pages get an overhaul

Be sure to swing by the newly redesigned Integration Services 2008 portal page on MSDN (and TechNet ). The portal is a great place to go for SSIS resources, and will be continually updated with “what’s new” and “what’s best” for SSIS. Also make sure to
Posted by mmasson | 0 Comments
Filed under:
Friday, January 02, 2009 4:41 PM

API Sample – Data Conversion

This sample creates a data flow package with an OLEDB Source and a Data Convert transform. The transform converts the CustomerKey column (int) to a WSTR(50), and stores the result in the CustomerKeyAsString column. static void Main( string [] args) {
Posted by mmasson | 3 Comments
Friday, January 02, 2009 10:34 AM

API Sample – Lookup Transform

This sample creates a data flow package with an OLEDB Source component feeding into a Lookup Transform. The Lookup transform is set to Full Cache mode, and uses [DimCustomer] as its reference table. Items of interest: CustomerKey and GeographyKey are
Posted by mmasson | 3 Comments
Filed under: , ,
 
Page view tracker