SSIS package - Error Handling

  • 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

  • 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

  • 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.

  • 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.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply