Hi,
I have a stored procedure where I am executing a dts package :
SET @cmdString ='dtsrun /S WEBSRV /E /N Load_textFile '
EXEC master..xp_cmdshell @cmdString,no_output
In this DTS package
1) Truncate existing Table
2) Load the text file in the table.
The problem is , when executed it performs just the task 1 and not task 2. It was working fine before. What can be the reason ?
Please help
Thanks
I have a stored procedure where I am executing a dts package :
SET @cmdString ='dtsrun /S WEBSRV /E /N Load_textFile '
EXEC master..xp_cmdshell @cmdString,no_output
In this DTS package
1) Truncate existing Table
2) Load the text file in the table.
The problem is , when executed it performs just the task 1 and not task 2. It was working fine before. What can be the reason ?
Please help
Thanks