Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2014-07-24 : 07:28:26
|
| Hi,I'm trying to run an SSIS pakckage from sql server 2012 from SSMS.But the script I'm trying to check is not giving any result.This problem started happening last two days, before that everything was fine.xp_cmdshell 'dtexec /F "I:\DTStoSSISMigration\SSISProject\Transaction.dtsx"'when i try to run the above script no result is giving not even error is throwing it keep on executing. sql server keep on executing even for one day.exec master..xp_cmdshell 'dtexec' Even this simple query is not giving any result set. Same package when i'm trying to run from cmd prompt its executing without any issues.Please help me out. |
|
|
|
|
|
dtexec issue in SSIS Package execution from SSMS