Monday, February 12, 2007

SSIS IDE bug...?

Recently I am studying SSIS for my project.
I was stuck at some points while importing data from a VFP table.

The Execute Package Utility kept saying that there is a Truncation Error.
After spending for the whole afternoon, I got it...

It is because the IDE (VS2005) didn't always refresh the length of my source columns.

SSIS Home: SQL Server Integration Service
http://msdn2.microsoft.com/en-us/library/ms141026.aspx

well, I will patch my VS2005 up to SP1...soon

No comments: