A risk of delaying validation is a package may have many tasks and one of the final tasks may fail due to a missing dependency. Instead of the package failing...

http://support.microsoft.com/kb/940232

You can create a subquery to pair the lowest number CustID to all CustID values from 2 to N where there is more than one row for any PhoneID. I...

I don't know if you can use pivot without an aggregation function. You can self join the table.

I'm just guessing on the design of your schema, looks like some type...

Your package might have an environmental variable configuration and that variable might not exist on the machine you migrated to.

Right click on the control flow canvas and select Package Configurations....

In the date column (column 4) what is SSIS detecting for a data type? If it is DT_Date the first and second rows (empty row and row with date header)...

This might get you closer.

select

substring(textdata,

charindex('insert into',textdata), -- find the INSERT INTO

100) -- 100 characters should be more than enough to get the insert into plus the...