Thanks John, this will work.

If I used date logic I would have to bring in the time dimension table from the source. This is not recommended because of the size of the database....

Thank you I will try that.

I read the article and followed your instructions and Execute SQL task works just fine but the Data flow task doesn't. I get the following error message.

[Connection Manager "CreateFlatFile"]...

I certainly will get back to you. I use SSIS all the time and I have used simple variables but not expressions. I will post back when I'm...

Thank you so much for taking the time to help me. I think the article is just what I need.

Thank you, this is almost exactly what I've done but I'll try again.

Thanks again, it does work now. I must have had another syntax error. I appreciate all your help with this.

Have a wonderful evening. Perhaps someday...

Thank you for the code and please disregard my previous reply. I get 010 when I use your example as a variable. What I need is 009 and...

Thank you again for your reply. It works and gives me 012 but I really need the expression to give me the current month -1 formatted with a preceeding...

Thanks for your reply but isn't (IIf) a Microsoft Access function. I am trying to create a variable as an expression in an SSIS package. I tried what...

Thanks again for the code. this is great, it works like a charm.

Thanks again.

My mistake, yes I'm sorry I was referring to the column headings. I am having a crazy day at work and read your posting quickly. I think I...

One thing I did not is the hardcoded names and of course I will not be able to do that in the procedure. How would I replace that.