Post reply

braunch that launch if a text file is not empty in DTS

  • March 30, 2005 at 4:37 am

    #87881

    Hello,

    Does someone know how to execute a braunch in "data transformation service" only if a text file, wich is used to fill a table, is not empty ?

    I also would like to have a mail send to me if the text file is empty.

    Please help it drive me crazy

     

  • March 30, 2005 at 4:48 am

    #549505

    oups sorry , I think I have posted in a bad forum, I should have post it in "administration" because I have seen another question on DTS. I will repost it now.

  • March 30, 2005 at 4:23 pm

    #549694

    Actually it should probably go in the DTS forum

    http://www.sqlservercentral.com/forums/messages.aspx?forumid=19

     

    --------------------
    Colt 45 - the original point and click interface

  • April 1, 2005 at 7:17 am

    #550082

    Try the code at http://www.sqldts.com/default.aspx?218. This shows you how to have conditional processing with multiple paths in a DTS workflow. It will take a little pondering to understand (at least it did for me). If you don't fully understand the structure of workflow, constraints and precendence it will be an interesting exercise.

     

     

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

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