SSIS package to move data to a table

• cherie-817709

  Right there with Babe

  Points: 749

  More actions

  September 17, 2008 at 3:33 pm

  #154736

  I am trying to create a very simple SSIS package to move data from a file (.csv) on one server to a table in another server. I have used flat file connection and OLEDB destination dataflow task. I have to move multiple files. WhenI move one file , its ok but when I just change the file name in the same flat file connection, it doesn't work. The error is:

  [OLE DB Destination [9]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (22)" failed because error code 0xC020907D occurred, and the error row disposition on "input "OLE DB Destination Input" (22)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.

  Any thoughts appreciated

• VG-619426

  Hall of Fame

  Points: 3914

  More actions

  September 17, 2008 at 3:45 pm

  #873291

  Hi,

  The error u r getting may be brcause it may not able to map between source and destination. R u sure all the files have same columns?

  I don't know why r u using falt file connection manager. There is Excel Source connection available.

  You can also use for each loop container to loop through all fiels in a folder and load them to destination.

  VG