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...

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...

you can call dtsrun command using xp_cmdshell

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....

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 =...