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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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...