Post reply

Data Check and Notification within SSIS

  • October 24, 2008 at 3:12 am

    #154849

    Hello

    I am a complete newbie to the whole SSIS and I am currently working on importing some data from a Flat File Souce, which is a simple Column Delimitered Txt file into a Table on the Server. I have managed to successfully get this step working and the data is importing fine. What I now want to do, is run some sort of Data Check on the specific table, within a specific column to see if there are any Null data entries within this column and then for the SSIS package to send me some sort of notifcation via e-mail or something to inform me there are null values within this column. I will then know I have to take action. Can this be done?

    Any help or guidance would be much appreciated.

    Regards....

  • October 24, 2008 at 3:46 am

    #889097

    Do you need to know just of the existence of null entries in rows, or do you need to see the specific rows themselves?

    If the first, you could use an Execute SQL Task to run a quick query (something like: [font="Courier New"]select top 1 1 from [yourtable] where [yourcolumn] is null[/font]) that you can use to populate a variable. You can then use this variable in the constraint from the Execute SQL task and your email task to decide whether an email needs to be sent.

    If the second, you could use a data flow to populate a flat file, or separate table or something like that, and send this via an email.

    Or, you could check for nulls in the original data flow. You could send them to a different data destination for further checking using a Conditional Split transformation and save sending them to the main table altogether.

    Tom

    Life: it twists and turns like a twisty turny thing

  • October 24, 2008 at 4:38 am

    #889118

    Thank you for your help...That's great

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply