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...

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...

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) ...

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...