Hi,apologies if this is a common question...
upgrading a db from 7.0 to 2005, half the tables were dts imports from another system - so have rewritten them in ssis to a new 2005 v90 db - now I need to import the rest of the 7.0 tables to the new db (which also uses the new 'codepage' language format - Latin1 General)
Is there an easy way to import the old tables into 2005 so they're in latest formats for 2005? (preferably in batch as there's a few hundred of them, I'm sure ssis would do it one and a time!)
Thanks,
Martin