April 28, 2010 at 5:45 am
There are some parts of SSIS that are very tedious and I hate having to say to my devs "Yep thats the way it is sadly".
One example - You have a table of 50 fields and are outputting to an external source. The table is non unicode and the source wants as unicode. So you have to stick a convert step to make each text field unicode. So you then have 50 fields with name "DataConversion.<fieldname>" and you need to remap them to the output.
Oh look! You can't multiple select. You have to click each old mapping and delete, and then click and drag each of the new 50 fields manually. So so bad.
Any ideas on that one?
April 28, 2010 at 6:58 am
Use a query as your source and do the CASTs in the query?
April 28, 2010 at 7:31 am
Good idea, but still - Inability to "select all" or "map multiples"? Poor show! :hehe:
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply