Ssis: connecting to a Ole Db with a dynamic table name..
Posted on 2010-03-23
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?