• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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