ok so before i do my check,i insert a row count into a table,for a simple audit trail

this is done by using this statement :

So Step 1

insert into...

Im not using a stored proc its a job step,and believe it or not the use statement works in it.The problem im having is prior to this point though,my problem...

The DM Check Job does the following if the count is > 0 it sends a condition via control M(via DTS ->BAT File) to our operators,that theres a problem with the...

It varies and can be random, i would create a pump for each client,but i dont want to hardcode as clients could increase or decrease.

You might have a duplicate column name in the import file,just check the column names.

hey dude try this

Put the ffg in a SQL Task, as the final step of your dts

--- copyfile from after extract to temporary location

EXECUTE master..xp_cmdshell 'Copy \\server1\dts*.xls ,\\server1\temp '

--...

Yes i do overwrite the db on the standby server.the live db,is copied to two servers,one is the SAN backup server and then thereafter the other is copied to the...