As I can see I am not alone with my pain

Thanks to everyone!

I modified DTS manually on the new server and we will...

Oh, yes! it was the OSQL ! Thank you people, you made me think!

osql  -SServerName -dmsdb -i"d:\MSSQL\BACKUP\TEST\TESTScript_JOBS.txt" -E

and it worked

Thanks to all!

The databases will be already on the new server and jobs will be modified a little manually after all (like the email operator or output file path).

The...

Need to create the job to run the script (script created already).

Have a problem to remember the command line - is it something with xp_cmdshell or ...?

Thanks!

Thank you! I did not look at that table at all, just checked sp_helpfile and sp_helpdb trying to find where the files name are coming from silly me 

and that LEN will confuse you here too:

DECLARE @val CHAR(2)

SET @val = 'D'

print 'copy c:\temp\test.txt' + @val + ':\temp\test.txt' 

It will be 'D space' ...

Thank you very much! I did it and the GROUP worked!

I did not know about record count counting problem

Went this far

select count(@@rowcount), sum(amount)

from TableName

Now - can we break the count(@@rowcount) for the Group By ?

count(@@rowcount)/3 is not good....

OK, now I am thinking if the NumberOfTheWeek is too easy to perform this procedure. What if :

CustomerID           Amount

12                          5

56                          12

51                          45

123                         47

456                         63

125                          2

10                          55

If it needs to be...

THANKS!

group by (numberoftheweek-1)/3 - worked perfect!

Now, Sergiy, why it's numberoftheweek-1? (because it starting to count from 0?)