SSIS Populate Variable with Table name of OLEDB source

1
votes

I need to populate variable with table name of OLEDB Source

Hi , i need buld dynamic variable for simple SSIS package that contains an OLE DB source and an OLE DB Destination.

Variable which i look for like 

MyVAR='OLEDB SOURCE TABLENAME'

For future development, I have above 250 packeges so i prefer not to do this manualy in each package.

Expectation: I set Variable and it recieve table name automaticaly in each package .

Thank You in advance .

1
variablesssis

1 Answers

0
votes

This can be done in 2 steps:

  1. Add a variable in SSIS package
  2. In the OLE DB Source, change the access mode to Table name or View name variable and select the variable you created from the drop down list