April 10, 2013 at 1:43 am
Hi,
I have a csv flat file with data from 2009 until date. I wanna restrict 2009 - 2011 data from flat file entering my package. I know I could use filter condtion to filter the years and by pass the required ones. But , I am not sure how the expression should look like in conditional split.
year(Date)>='2012' --- is this d expression?
ANy help on this?
Thanks!
April 10, 2013 at 8:44 am
Year Function will return an Integer, so
Year([Date]) >= 2009 should work.
Are you getting any errors?
April 11, 2013 at 12:38 pm
YEAR( [Date Column] ) >= 2009 && YEAR( [Date Column] ) <= 2011
April 11, 2013 at 12:42 pm
For more on SSIS Expression Language, which is a goofy combination of T-SQL (mostly with the functions) and C (mostly with operators and the like), go here (for SQL Server 2008):
http://msdn.microsoft.com/en-us/library/ms141232(v=sql.100).aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply