CODEWITHSUNDEEP
sql-serverdtsssis
largo68
largo68

Reputation: 629

How to execute a package SSIS 2008

Does anyone know how to trigger the execution of a SSIS 2008 package while running a DTS 2000 package? Actually, my DTS 2000 has to be runned as it is and cannot be converted into a SSIS 2008. SO is it possible to execute maybe a shell command (Dtutil , etc..) to run this SSIS 2008 package?

Thanks for feedbacks

Upvotes: 2

Views: 2369

Answers (1)

Mutation Person
Mutation Person

Reputation: 30488

There are two ways I can think of doing this.

  1. Make the DTS execution a step in a SQL Agent job, and start that job by running the stored procedure sp_start_job

  2. Run by executing xp_cmdshell:

    EXEC xp_cmdshell 'dtexec /f "C:\Package.dtsx"'

Option two involves configuring xp_cmdshell to run. xp_cmdshell allows you to issue operating system commands directly to the Windows command shell via T-SQL code - something I'm not entirely comfortable with, so I would go for option 1.

Some helpful links:

Upvotes: 4

Related Questions