Link to home
Start Free TrialLog in
Avatar of moosetracker
moosetracker

asked on

Ssis: connecting to a Ole Db with a dynamic table name..

My SSIS is createing a table in a SQL database monthly with the yearmonth as part of it's name, I want to load data into it.. So I in data flow I created my source, and then my oleDb destination.. But the Connection Manager for the Ole DB is just to get to the database.. Fine..
the destination want you to point & click on the table.. then I see no expression area to change that table into a variable name...
I need the "name of table or view" in the Ole Db destination editor to be
filename_201003  this month
filename_201004 next month

the filename has been formatted into a variable and is ready to use! Now it's just getting this component to use it..
How can I do that?
ASKER CERTIFIED SOLUTION
Avatar of Reza Rad
Reza Rad
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of moosetracker
moosetracker

ASKER

Thank you so much..
Yes, this was a "duh" moment on my part.. Geesh.. Now I got all this code that was creating shell generic name table, then renameing it to what I want, and recreateing a shell generic file so the destination table wouldn't abort on the next run...