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

Posted on 2009-02-19
Last Modified: 2013-11-10
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 :)
Question by:passion420
    LVL 22

    Expert Comment

    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)

    Accepted Solution

    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

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
    Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now