(And before anyone points it out; I know they're not calling it DTS any more!)
My problem is as follows: Whenever I go to import a flat file using the DTS import it's setting the default column sizes to be ludicrously small (50 characters) and it doesn't subsequently matter HOW I define the table I'm pulling the data into, it chokes until I correct it.
One (obvious) way round this would be to save the package and go from there. Unfortunately, because of the nature of the files, this isn't all that practical (because this is going to be an issue across a good 10 or 15 different databases).
Is there a way of getting SQL to up its default settings so that I can go back to controlling column size on the table only? Or am I SOL?