SSIS to Load selected CSV File columns into SQL Server 2008 database table

• vijayakumarkj-602216

  SSC Journeyman

  Points: 98

  More actions

  May 15, 2013 at 8:08 am

  #293963

  Hi,

  The source file format in CSV, lets assume it has following data

  id name marks

  1 a 100

  2 b 90

  I have created flat file connection manager to read the source file and I have created a table with ID and Marks column and mapped in OLE DB mapping, though when I run the package, it loads id and name values instead of id and marks data.

  please help?

  Thanks

  KJ

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  May 15, 2013 at 10:34 am

  #1615527

  Sounds like either your mapping is incorrect or the CSV isn't right. Without seeing the package and the CSV file hard to say for sure.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question