Viewing 5 posts - 1 through 5 (of 5 total)
Thanks a lot Frank, the script is exactly what I was looking for
As for your recommendation, I feel the same way in a sense...
February 15, 2005 at 6:45 am
#542261
I once had a similar problem with different error message. Actually the message was logged in Event Viewer. I'm not sure whether yours is the same as the one I've...
January 28, 2005 at 12:48 am
#539475
you can call dtsrun command using xp_cmdshell
September 26, 2003 at 4:12 pm
#476086
Diane,
I can't say antyhing about how these packages will be called. The possibilities are :
1. packages that are run manually within Enterprise Manager
2. packages that are part of jobs
3....
August 5, 2003 at 8:44 am
#468675
If you know the columns in table A, it's quite easy:
DECLARE @fld VARCHAR(4)
DECLARE @T INT
DECLARE @SQL VARCHAR(255)
SELECT @T = 0
WHILE @T<4
BEGIN
SET @T = @T +...
January 9, 2003 at 1:28 am
#445918