• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 767
  • Last Modified:

SSIS package to update a column based on the last day of the daterangevalue

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.
Thanks :)
1 Solution
I suggest you to buy a book, or get a free book about SQL 2005 or 2008 (I have a link in my blog to a free book, take a look)
passion420Author Commented:
I found there is one more column in my table called DateR which stored the last date of Jan1-15 as 01/15/2008 in the table. I used the derived columns to convert this data to a common format 2008-01-15 and today's date when the package will run and compared them using the derived column and updated the column and performed other tasks accordingly.

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now