SSIS package to update a column based on the last day of the daterangevalue
Posted on 2009-02-19
I have 2 columns in my database table one is DateRangeValue having values in form like Jan 1-15 and other column is the status.
I want to create a package which calculates if Jan15th is passed , and of the status is still 'I' it will change the status to 'C' automatically. And sends an email to user whose Lanid is also stored in the same table under one column.
Dont know much about SSIS package, please if somebody can specify the tools to be used and
step by step instructions on how to do it , I will really appreciate that. Thanks a lot, really need it for one of my program.