Mister Ken (8/1/2012)
I'm working with a DataFlow Task and have the souce and destinations set.
The destination has Field1, Field2, Field3 and a last column called dtEndDate.
The source has Field1, Field2 and Field3.
I want destination's dtEndDate column to be filled in from my package level variable called dtMonthEndDate.
How do I do this? I know I can use a derived column, but I want to avoid this.
I was thinking of specifying a SQL statement instead of the table name in the source. And doing something like:
SELECT @dtMonthEndDate AS dtEndDate, Field1, Field2, Field3 FROM MyTable1.
But it doesn't look like it wants to support something like that. I tried to replace the @dtMonthEndDate with a ? but it gave me an error message.
Can you change your Select statement so that it is self-contained? Eg:
select EndOfMonth = DATEADD(s, - 1, DATEADD(mm, DATEDIFF(m, 0, GETDATE()) + 1, 0)), F1, F2 etc
Edit--not that I think you will gain much. Derived columns usually perform well, in my experience.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.