SolvedPrivate

Error when executing DTExec

Posted on 2014-11-13
2
37 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 45

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

Want to promote your upcoming event?

Are you going to an event? Are you going to be exhibiting at a tradeshow? Talking at a conference? Using a promotional banner in your email signature ensures that your organization’s most important contacts stay in the know and can potentially spread the word about the event.

Join & Write a Comment

Whether you've completed a degree in computer sciences or you're a self-taught programmer, writing your first lines of code in the real world is always a challenge. Here are some of the most common pitfalls for new programmers.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

706 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

18 Experts available now in Live!

Get 1:1 Help Now