Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

running a dts package via a user interface

Hi,

I have a dts package that imports from a textfile into a temp table and then calls some stored procs to work on that table.

It would be nice if i could give the marketing department a user interface so they click a button and it starts the job.

ideally they would then be notified when the job had finished.

is all this possible?
0
scm0sml
Asked:
scm0sml
1 Solution
 
orbulatCommented:
can u write a store procedure / query that run the dts package?
then in your interface, onclick will call a function that runs that store proc.

just like u run a dts from query analyzer

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/DTS/Q_22428234.html
0
 
scm0smlAuthor Commented:
to be honest ive not done much with dts packages.

i will read thru your link tho and get back to you.
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now