SSIS 2008 "Split Datetime column into year, month, day, hr, sec etc and store each of it inoto seprate columns"
-
Create a new data flow and use a derived column transformation to split the date into its constituent parts.
John
-
John
according to u I am using derived column transformation now
from columns i have derived datetime column but what to write in expression can u tell be that
-
The name of the date time column from source file is "dates"
in expression it is [dates] but how to splitt it which function of date/time to use and how to use etc
plz I need to solve this problem ASAP
-
In the Derived Column Transformation Editor, there's a list of date/time functions. Pick one of those. If you're unsure of the syntax, use a search engine - there's plenty of material out there on the web.
John
-
tahirayoub (8/23/2011)
The name of the date time column from source file is "dates"in expression it is [dates] but how to splitt it which function of date/time to use and how to use etc
plz I need to solve this problem ASAP
As John says, SSIS is reasonably helpful in that it lists functions for you.
Which you can use to build up the derived data that you require.
Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 5 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply