[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 872
  • Last Modified:

Executing SSIS Package with DTEXEC

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
0
SeTech
Asked:
SeTech
  • 2
1 Solution
 
PedroCGDCommented:
0
 
SeTechAuthor 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?

0
 
SQLSergentMikeCommented:
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.
0
 
PedroCGDCommented:
it's used to get dinamically the path of the package.
You cannot store the packages insider SSIS Server?
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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