Expected error in wrong column mapping
-
Wednesday, January 30, 2013 7:39 AMHi: I ran a task to transfer data from source SQL to destination SQLCE. Job succeeded. But when I checked the destination table,I found the 1s column was empty. I checked the mapping and found that there were wrong in source-destination mapping. The 1st source column was not selected. So nothing was mapped to the 1st dest column. Other 2 columns were mapped properly and had data in dest table. My question is why it did not generate an error. So that I could fix the mapping and could run the job again. Thanks.
All Replies
-
Wednesday, January 30, 2013 7:44 AMModerator it's not mandatory to map all columns... only your destination table can throw an error if it's NOT NULL.
Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter
- Marked As Answer by syedripon Wednesday, January 30, 2013 3:14 PM
-
Wednesday, January 30, 2013 3:15 PMHow can I grab this as an error when mapping is not right. Thanks.
.png)
