Post reply

how do I present my DTS package to end user.

  • June 28, 2006 at 11:35 pm

    #113558

     

    Hi 

     

    I am a new comer in SSIS.

    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

  • July 3, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • July 3, 2006 at 8:58 am

    #647240

    Look up DTEXEC and DTEXECUI utilities in BOL to find out how users can run SSIS packages.  Packages won't run anywhere, users must have .NET framework and several other components installed.  I don't have the complete list memorized but it's probably in BOL.  One approach might be to require users to install the free SQL 2005 Express Edition as a prerequisite for your package.

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

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