November 23, 2004 at 12:29 pm
I am calling a stored procedure which runs a dts package. The dts package imports a text file into a table. The dts package runs fine when it is called from enterprise manager directly. However, when I call the dts from the sp, the dts package again runs fine and completes its task, but the sp never finishes. It just keeps on running.
Here is the sp:
set @retStatus = 99 -- reset return status
Set @Cmd = 'dtsrun /S' + @@SERVERNAME + ' /E /Nhr_KronosImport' -- run DTS package
execute @retStatus = master..xp_cmdshell @Cmd
print 'return status'
print @retStatus
if I run this from a dos prompt, the dts package runs its last step but will not return to the command prompt. The last message is:
DTSRun = Package execution complete.
A blinking cursor is on the next line. The only way to return to the command prompt is to hit CTL+C. There are no message boxes or pop-ups.
Any help with this is greatly appeciated! Thanks!
November 26, 2004 at 8:00 am
This was removed by the editor as SPAM
November 29, 2004 at 6:19 am
I found the answer at
http://support.microsoft.com/default.aspx?scid=kb;en-us;318819
On the Workflow properties of the dts package, checking "Execute on main package thread" fixes the issue. The package now runs and quits as it should.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply