SSIS package - Error Handling

• gready20

  SSC Journeyman

  Points: 80

  More actions

  June 23, 2008 at 12:00 am

  #187394

  I am new to SSIS. Can somebody please help

  1. I need to pass the file name to my SSIS pacakage as a parameter

  2. In the destination Table have the following couluns

• hmaharaj

  SSC Eights!

  Points: 811

  More actions

  June 25, 2008 at 12:15 pm

  #834196

  are you trying to import data from a flat file and put it into a database?

  are you trying to import data from a flat file and create a table in ur database and put data into it?

  please be more specific

• siluctc

  Mr or Mrs. 500

  Points: 539

  More actions

  June 26, 2008 at 6:16 am

  #834559

  take one string variable and assgin the file name to it. and give the expression to it. the file name will be added in your dataflow.

• Alan. T.

  Hall of Fame

  Points: 3221

  More actions

  June 26, 2008 at 1:24 pm

  #834951

  You could also turn on package configurations and set the value to a variable. This way you can change the path without changing the package.