Execute a DTS Package from QA

Hi there,

I have a DTS package called: ImportNewFSLData. How do I execute this from a script I have in QA?

Cheers,

LoveToSpod

LoveToSpodAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
The simplest way:
schedule the dts package, go to the job and remove the schedule, and in the QA just start the job using:
sp_start_job 'job_name'

with the scheduled job, you can see how you could start the dts via QA: the job contains the command line (DTSRUN.EXE ...), use xp_cmdshell to run that command from QA.
0
 
SireesCommented:
0
 
LoveToSpodAuthor Commented:
angelIII

schedule the dts package - DONE
go to the job and remove the schedule - Where is the 'Job'?

Sorry, acting like a REAL novice...

LTS
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>go to the job and remove the schedule - Where is the 'Job'?
in the enterprise Manager, find the SQL Server Agent folder, below that you have jobs...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.