Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
freesoul
Starting Member
35 Posts |
 Posted - 2007-09-04 : 06:32:12
|
| While Running a SSIS package after migrating it from DTS to SSIS , in MS SQL Server 2005 , it gives error while execution :DTS_DTSTASK_DATAPUMPTASK_2The number of columns is incorrect.verify the column metadata is valid."OLEDB Destination "(22) Failed the pre execution phase and returned error code 0xC0202025Thanks for the response ..... |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-09-04 : 06:46:51
|
1) The number of columns has changed2) One or more of the column datatypes has changed.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
freesoul
Starting Member
35 Posts |
Posted - 2007-09-13 : 05:42:53
|
| i found that the 2 fields of Source Table has type as charand the corresponding fields in Destination Table has field as Varchar.Is this the reason for the error in SQL Server 2005 ????????as this works fine in SQl Server 7.0.Thanks for the guidance |
|
|
|
|
|
|
The number of columns is incorrect