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?
LVL 1
moosetrackerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Reza RadConsultant, TrainerCommented:
Hi,
There is no need to use expressions,
OLEDB source and destinations has another method for dynamic table names,
double click on oledb destination,
set Data Access Mode as Table Name or View Name from Variable,
this is obvious that you should set the value of variable with a script before,

Regards,

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
moosetrackerAuthor Commented:
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...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.