June 29, 2006 at 3:53 pm
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
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.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply