SSIS package

hi,

i ve ssis package.

there table in database following columns:

excel used          table      no.of records          status
abc.xls                  xyz            1234                    successfull

i want after package debugged completely,the above table automatically gets filled corresponding values used in package.


description of table colums:
excel used: excel used transfer data in database.
table: destination table
no.of records transferd excel to the table
status : whether package debugged or not.

please let me how implement this.

you need gather bits of information ssis variables.  example, should have filename in variable already, , destination table name should assigned variable (if isn't already).  use row count transformation in data flow count rows , place result in variable.  don't know how collect "status" information - depends lot on package.

once have information in variables, need create string variable hold insert statement.  you'll set variable's evalasexpression property true, , construct dynamic sql statement in expression property.  use execute sql task run the insert command variable.

---

SQL Server  >  SQL Server Integration Services