SolvedPrivate

Error when executing DTExec

Posted on 2014-11-13
2
44 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 50

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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Determining the an SCCM package name from the Package ID
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…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…

696 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