SolvedPrivate

Error when executing DTExec

Posted on 2014-11-13
2
42 Views
Last Modified: 2016-02-11
Receiving error

dtexec' is not recognized as an internal or external command

DTEXEC.EXE /F "C:\SSIS\Testing.dtsx" /SET \Package.Variables[User::Concept].Properties[Value];"66" /SET \Package.Variables[User::ID].Properties[Value];"21603" /SET \Package.Variables[User::BaseID].Properties[Value];"143"

Should I pass in username and password?  Using an ado.net connection.
0
Comment
Question by:LeVette Alexander
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 49

Accepted Solution

by:
Vitor Montalvão earned 250 total points
ID: 40447140
it's because you need to provide full path.
Guessing that you are using SQL Server 2008 32bits, then this should be the correct path:
C:\Program Files (x86)\Microsoft SQL Server\100\DTS\Binn\DTExec.exe /F "C:\SSIS\Testing.dtsx" /SET \Package.Variables[User::Concept].Properties[Value];"66" /SET \Package.Variables[User::ID].Properties[Value];"21603" /SET \Package.Variables[User::BaseID].Properties[Value];"143"
0
 
LVL 15

Assisted Solution

by:JimFive
JimFive earned 250 total points
ID: 40447151
The error indicates that the OS cannot find the executable DTEXEC.EXE, try using the full path the file.  On my computer that is at C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTEXEC.EXE
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Viewers will learn how the fundamental information of how to create a table.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question