That is what I don't want to do as it would take so long. Under sql2000 it picked up that information from the table being appended to. Under sql2005 it...

There is no package involved. I am simply using the wizard to run the import and run it "immediately", I am not saving it.

The input file has the first...

A related question - We have a 4 Gb server with the 3Gb switch not enabled and SQL Server memory dynamically configured with a max of 2GB. SQL Server memory stays at...