Is there a way to get SSIS (<cough>hateit</cough>) to suggest the types on a flat file connection mgr from a destination table?
So the problem is I have a largish table with lots of text fields and even when using suggest types, it will sometimes set the length of those fields smaller than the target column. That, of course, would be fine for the current set of data, but if I expect to use this package again on a different file in the future that may have more data in this particular field, then I have myself a problem.
Yes, I can go through and set them all manually (<cough>sucks</cough>), but I'm hoping I'm missing a feature somewhere where I can say, "Define this here file in terms of that there table".
Ideas? Thoughts? Rants about SSIS?