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 2008 Forums
 SSIS and Import/Export (2008)
 SSIS debug

Author  Topic 

Oliver wang
Yak Posting Veteran

50 Posts

Posted - 2012-02-07 : 06:44:44
Hello everyone,

I'm wondering whether there is a way to do a detailed debug in a SSIS package. For example, I want to transfer the data in an excel to a database table. When I get an error during the transferring(I mean when the transferring is in its half way), I really want to know which exact row and column causes the problem rather than a general message saying for example, "conflicting with a constraint". Is there anyone who can share some experiences on how to position to the specific row when an error is occuring? Thank you very much in advance.

regards,

Oliver
   

- Advertisement -