We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Executing SSIS Package with DTEXEC

Medium Priority
888 Views
Last Modified: 2013-11-10
With SQL 2005 I was able to develop a Batch File that did some file manipulation and then executed a SSIS package. The code to execute the SSIS package is: DTEXEC.EXE /De Password /F File path to package.dtsx

My Server was upgrade to SQL 2008 and now the Batch will still manipulate my files however, it will NOT execute the SSIS package.

Any ideas? Thanks Much
Comment
Watch Question

Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
SeTechAnalyst

Author

Commented:
PedroCGD
Thanks for the link. The code for a bat in the link is:
set OLDDIR=%CD%
dtexec /F "%OLDDIR%\MyPackageName.dtsx

What is the purpose of the set OLDDIR=%CD% ? Do you need to have it?

Is this an interactive batch job, or is this running under the agents security context?  If it is interactive you will have to add the the needed lauch permissions to DCOM config. Also ensure the user or service account is in the db_dtsoperator role.

Commented:
it's used to get dinamically the path of the package.
You cannot store the packages insider SSIS Server?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.