lundi 27 juillet 2015

Update multiple tables from fixed width file

I need to do a bulk import into SQL Server 2005 using a fixed width file that has data to be written to 3 different tables. I am not sure the best way to go about this. I assume the best way would be to import all of the data into a single table and update each of the 3 from the new staging table. I am not sure though how to import the data into the table from the fixed width file.

Thanks, Scott

Aucun commentaire:

Enregistrer un commentaire