Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS FIlter conditions Expand / Collapse
Author
Message
Posted Wednesday, April 10, 2013 1:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 1, 2014 8:41 AM
Points: 101, Visits: 437
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!
Post #1440683
Posted Wednesday, April 10, 2013 8:44 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Today @ 3:52 PM
Points: 1,485, Visits: 1,035
Year Function will return an Integer, so
Year([Date]) >= 2009 should work.
Are you getting any errors?
Post #1440854
Posted Thursday, April 11, 2013 12:38 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
YEAR( [Date Column] ) >= 2009 && YEAR( [Date Column] ) <= 2011

Post #1441430
Posted Thursday, April 11, 2013 12:42 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 28, 2014 7:12 PM
Points: 2,148, Visits: 487
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
Post #1441431
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse