Post reply

How Do I apply my DTS package to end user

  • June 29, 2006 at 3:53 pm

    #67501

    Hi 

     

    I am a new comer in DTS.

    I have a task to convert  from 1 txt file then produce another txt file ( less column data).

    The user will use this new txt file to import to their system. ( this part is not my task anymore – my task is up to produce a new txt file)

     

    I create a simple package using SSIS wizard in VS2005 for  import from txt file then export it again with query ( because I want it to have less column).

     

    The question is how do I  present this package  to user.

    Do I need to write a program for end user?

     

    I guess the user wants have 2 buttons

    How do I attach this DTS package to the button?

     

    1 button for import file   ( it wil be good if the user can choose their own path where they keep the old txt)

    2 button for export file  ( also choose the path where they want to save a new txt file)

     

    thanks,

    Susan

  • June 30, 2006 at 5:20 am

    #646930

    The best way is to write a stored procedure that calls the package. That way you can control security to the package through the sp.

    If you want them to choose their own path, you can pass this value into the stored procedure or code it directly into the package using an InputBox to accept the code.

    The other method is through a run command on the local client. You will have to construct the batch command before running if you are adding parameters.

    You could create a simple front end in excel or word for either approach to do this in vba, although if you have visual studio installed (I see you have SQL2005) then write a quick app using either approach.

    ------------------------------
    The Users are always right - when I'm not wrong!

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

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