SolvedPrivate

Error when executing DTExec

Posted on 2014-11-13
2
39 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
2 Comments
 
LVL 46

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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
How to record audio from input sources to your PC – connected devices, connected preamp to record vinyl discs, streaming media, that play through your audio card: Vista, Windows 7, Windows 8, Windows 8.1 and Windows 10 – both 32 bit & 64.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
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.

911 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now