Clever Geek Handbook

Question about how to use the integrated sql server service

I have a table called book with, attrbutes - booked, yearmon and day_01 .... day_31. Now I need to disable the table and convert day_01 ... day_31 to strings, I managed to do that, but the problem is that my yearmon is 200805 format and I need to add the day to it based on day_01 or day_02, etc. so that I can create a new column with date information, for example if it is day_01 it looks like 20080501. Instead of writing a huge query, anyone how to use ssis convert it

+1


source to share


1 answer


You must be able to use the Unpivot component and the Derived Column component to perform the required actions. Take a look at them and send them back if they don't seem to do what you need.



+1


source






More articles:


All Articles