It opens up new way to solve the issue.

At the same time

There are two side-effect with this solution

1. We will end-up creating new table for each key.

2. There will be...

I found this interesting http://blogs.msdn.com/b/helloworld/archive/2008/08/01/how-to-find-out-which-column-caused-ssis-to-fail.aspx and simple

To open SSIS package in VS, you need to install Business Intelligence Development Studio and Integration Services from SQL server setup.

http://guruprasadv.spaces.live.com/blog/cns!6DBE66E3577937C1!347.entry