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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Data Transformation Task in SSIS

Author  Topic 

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2007-08-29 : 07:47:07
Hi,

How I set the Transform Data Task Property in SSIS package

As I designed SSIS where I mapped my text file columns to database table columns but if I selected wrong input text file having less columns than database table then how I will get error that it will not found remaining columns

suppose my DB table contain 3 columns and my (wrong) text file contain 2 columns then i should get error message that column003 is not found????

T.I.A
   

- Advertisement -