Start->Microsoft->SQL Server 2008->Import Export Data (32 bit) Data Source->Flat file source Browse->csv file If each text field in the csv file is delimited by quotes, set Format->Text Qualifier->" If the first row of data in the csv has column names->Column names in first data row->checked Data Source->Advanced->Data Type->DT_WSTR Data Source->Advanced->Output Column Width->the largest value possible for that column. Do this for every column in the table. Next Destination->SQL Server Native Client 10.0 Server name->xxxx\MSSMLBIZ Database->xxxxxxx Next Destination-> change to table name Next Save->SSIS package->Checked File System->Checked Filename->name for this import utility Next Run the utility |