I need to work on SSIS in converting date format to string literals.
2)First day of the following month
I need to satisfy both conditions in a single query
I need to work on both the coniditions but i am unbale to solve it.
Please help me on both.
Thanks in advance.
From what I understand, formatting dates in SSIS requires the concatenation of date parts. I suspect doing the date math in SSIS is a bit more difficult.
With that in mind, I'd do this in T-SQL query. Let us know if that'll fill your need.
My concern is, why do you want to do #1 at all? If it's to store formatted dates in a table, be advised that's one of the worst practices of all.
is pronounced ree-bar and is a Modenism for R
First step towards the paradigm shift of writing Set Based code: Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Helpful Links:
How to post code problemsHow to post performance problemsForum FAQs