Select T1.ToDisplayName  as DisplayName,                    T1.ToEmailAddress  as EmailAddress ,                      T1.AddressListID  as AddressListID

FROM T1

UNION

Select T2.ToDisplayName  as DisplayName,                    T2.ToEmailAddress  as EmailAddress ,                      T2.AddressListID  as AddressListID

FROM T2

UNION

Select T3.ToDisplayName  as DisplayName,                    T3.ToEmailAddress  as EmailAddress ,                      T3.AddressListID ...

Can you run the quey in QA and see if it is running fine?

go to the Package in the menu bar

Package --> disconnect edit -->  Steps

It will list down all the steps in the DTS package  and on the right hand side...

How are you transferring the data between the two databases ? Are you using any query to transform the data from sql server ( in Transform task) or is it...

This thread might give some idea for you to get started

http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=166709

Can you tell what your function dbo.GetSpecifiedSlumpInfo does ?  does it return just the UID or something else ?

SELECT Name, Elcl_grant, ol_grant, sum(elcl) as elcl_given, sum(ol) as ol_given

FROM Master

JOIN Detail ON master.code = detail.code

GROUP by Name, Elcl_grant, ol_grant

I have been seeing the exceptions a lot as well...

The filename 'UNC_to_file' might not be present in the folder from where you are executing the procedure .

Give an absolute path in the Filename field and see if the...

Based on the Value from the control table you can set a flag (Global variable) and using that flag you can disable/enable the step.

use the example of

Try setting the Autorestart SQL Server Agent if it stops unexpectedly to true in the Properties of SQL Server Agent

Sql Server Agent --> Properties --> advanced (tab) --> Restart Services...

Very nice article..although I saw this at a very later date

This thread might help you ....

http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=23&messageid=111988

-Meghana

The time will always be stored as a part of the datetime datatype AFAIK. But you can use date functions to get the data in the format you want.

Please refer...

Try checking the log files for any problem with the source records. You might have some erroneous records because of which only half the records are getting inserted

right click the...