Maybe a stupid question, but how do I start a DTS in a job?
I have to write some kind of command in a step to get the DTS started.
Can't figure out how...
The reason behind this is that I have sql-server database and an Access project as a frontend. I want to be able to start the DTS from the frontend via a stored procedure that uses sp_start_job to run a job that runs the DTS. Is this a bad idea?
The DTS imports a textfile weekly on a schedule but i want the users to be able to import the file att anytime also istead of having me do it for them.