conditional split
hi, my package is putting data into final table, which has 1 date, i need to check wheathere this date is less than current date ,then i need to pu that date into text file. the problem is, everytime my package run , it will check for all the rows in table. now my table will have 1 or more row will added every time it runs,but conditional split will check for all the rows. how do i make confition split, to check for the rows that is new one
November 19th, 2012 2:28pm

Hi tsql_new, I suggest you poll the table using the Execute SQL Task with a SQL like SELECT TOP 1 MyDateColumn FROM MyTable ORDER By MyDateColumn DESC Then you simply assign the return value to variable that you can use in a Precedence Constraint that directs the execution flow. Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2012 4:11pm

Hi tsql_new, I suggest you poll the table using the Execute SQL Task with a SQL like SELECT TOP 1 MyDateColumn FROM MyTable ORDER By MyDateColumn DESC Then you simply assign the return value to variable that you can use in a Precedence Constraint that directs the execution flow. Arthur My Blog
November 19th, 2012 4:18pm

Hi, Also u can do assign that specific date to a variable and use that variable. Thanks, Vipin
Free Windows Admin Tool Kit Click here and download it now
November 19th, 2012 8:51pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics