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

  • I still don't know the structure of the dimglobalkeys Table, so I still can't help much. You should always post as much information as you can in the body of your post. We need to know:

    1. The structure of your SQL Server table

    2. Is this a one to one import of the CSV rows into an equal number of rows in the matching table?

    If 1-to-1, SQL Server can import it for you. In SSMS, right-click on the database name, select Tasks... and on the Tasks popup menu select Import... A wizard will appear.

    Your data source is Flat File Source. Enter the file name and path of the XL file. After enter the instance and database name and you'll see a list of destination tables in your database. Check the box of the one you want to load the CSV to. From then on, you can just keep accepting the defaults and let it run. If you don't get the results you want at first, you can just truncate the SQL table and run the import again.

    Sigerson

    "No pressure, no diamonds." - Thomas Carlyle