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.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
How to post code problemsHow to post performance problemsForum FAQs