Home Forums SQL Server 2005 Business Intelligence how to generate records automatically from csv to sqlserver table using ssis etl RE: how to generate records automatically from csv to sqlserver table using ssis etl

  • April 18, 2013 at 5:41 am

    #1607651

    I'am having one csv file (dimglobalkeys.csv) contains only one column (unitofmeasure) having 68 records. my destination is table called dimglobalkeys having no data. i have insert scripts to insert the data in destination.but this script has to read from csv file having unitofmeasure column and insert into the target table.

    am attaching the source csv file.

    Target table name also contains the column unitofmeasure. This column has to read the data coming from csv file and load it into destination. CSV file having only one column unitofmeasure.