Post reply

Writing Reusable functions in DTS

  • July 13, 2005 at 8:48 am

    #61998

     Hi

          I am using DTS for importing a data between two SQLSERVERS. Here import means which includes (insert and update).

       if a source record is already in destination , i make updation, otherwise insertion into destination. I am applying this login in all packages.

    so I need to write a generic function which can be called in all DTS package instead of wrting it everywhere .

    Could u pls help out to do this reusable function?

    is there any other technique available in DTS ?

    Thanks in Advance

    Jones  

     

     

     

  • July 13, 2005 at 9:49 am

    #573982

    Jones,

    You could create stored procedure(s) that can handle the logic of update/insert and make a call to the sp from your DTS package.

    The only other option I can think of is to create a VB6 COM dll and register it on the SQL server. Then you can call this from any package.

    This site might help with the second option.

    http://www.sqldts.com

     

    good luck,

    Darrell

  • July 13, 2005 at 11:08 am

    #574037

    You also could put your generic function in a seperate package and then use the Execute package task from any other package to call it. 

    Diane

  • July 13, 2005 at 9:41 pm

    #574239

    Hi Diane

            Thanks a lot .its  a good idea to implement in my package.

     

    Regards

    jones

  • July 13, 2005 at 9:46 pm

    #574242

    Hi Darrell

          Thanks a lot. i  am using Data Driven Query which takes care of update and delete.so no need to write sps

    let me try with VB Com.

    Thank you

    Jones 

  • July 13, 2005 at 9:46 pm

    #574241

    Hi Darrell

          Thanks a lot. i  am using Data Driven Query which takes care of update and delete.so no need to write sps

    let me try with VB Com.

    Thank you

    Jones 

Viewing 6 posts - 1 through 5 (of 5 total)

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