Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rahul_koduru
Starting Member
3 Posts |
 Posted - 2009-08-27 : 12:26:15
|
| Hi,My source table names are something like mytable_199001,mytable_199002 etc. With some logic I'm able calculate the '199001' part dynamically. But, I need to pass it to the SSIS package to change the name of the source table dynamically. In DTS, I was using Dynamic Properties Task to accomplish this. I can't find the same task in SSIS. So, How do I dynamically change source table name in SSIS. Any help would be appreciated.Thanks |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-08-27 : 12:37:16
|
| In the OLEDB Source Editor, set the Data access mode to "Table name or view name variable".Then select the variable name in the box below. |
 |
|
|
|
|
|
Change Source Table Name Dynamically