Post reply

Need assistance setting up workflows in DTS

  • September 30, 2005 at 9:18 pm

    #166104

    I have set up a DTS package that will export data to a text file.  I created an ActiveX task to add the current date stamp to the end of the text file so that the existing file would not be overridden each day.  The ActiveX Task runs successfully when executed on it's own, however, the file name still exports without the date stamp at the end.  I think it has something to do with the workflow/precedence settings.  My DTS package includes the following:

    Connection to DB

    Execute SQL Task

    ActiveX Task

    Text file destination

    The Connection to DB is linked by a transform data task to the text file destination.  What other workflow settings should be defined in order to have the file name include the current date stamp and not override the existing file upon completion of the DTS package? 

    Thanks.

  • October 3, 2005 at 8:39 am

    #594591

    Tonya,

    If your ActiveX task sets up file name in the destination connection, it must complete before the data transformation task. The workflow shall be:

    (on success of) ActiveX task --> Data Transformation task

    It is not clear from your post what is the role of Execute SQL task - please clarify.

    Also, do you actually create a new file in ActiveX task? How do you then assign its name to the Text File Destination connection? If I were to implement this functionality, my ActiveX task would generate a new file name and assign it to a global variable. Then I would have a dynamic properties task, which would set the destinatin file name to the variable's value.

    Hope this would help.

     

  • October 4, 2005 at 6:53 pm

    #595041

    Are you calling this pump multiple times? It may be nessissary to call the Connection.ReleaseConnection() method; Modify the file name; then call the Connection.AcquireConnection(TaskName) method.

    I have never had to use this method, but depending on when your connection to the date source or destination is aquired, this may be needed.

    I'm pretty certain Phill Carter has posted on this topic.

    -Mike Gercevich

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

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