Our developers are wanting to use SSIS as the tool to convert data from a
company we acquired. They are reporting several problems including the
following with the IDE. Any suggestions on these would be much appreciated!


" IDE startup

By default, the IDE validates every single open object on startup. So if you
have a package which contains 10 sub packages the IDE will validate each and
every connection, table, data type, etc. This leads to long wait times just
to get into the IDE.



IDE oddities

Some of the screens are just very difficult to use and/or counter-intuitive.
For example, when redirecting errors to a log file or table you have to tell
SSIS what to do with errors or truncations for every single source column. In
Joe’s case that’s several hundred columns. There’s no way to apply the
settings to every column---you have to click “Redirect” twice for every
column. And to top it off there’s no scroll bar so you have to page up/page
down to navigate the list of fields. This screen is the worst example but
there are others."

- steve in portland