One thought:  use a uniqueidentifier column and the NewID.  It is somewhat wide, but it is almost certainly going to be unique.

What happens if there are more than one Attachment?  What is the pattern? 

Are you changing the c:\ to h:\ in place?  DTS might not be the tool for you.

Can the...

SELECT e.Employee, e.ChildName, e.ChildSex, e.Age

FROM EmployeesChildren e JOIN

(SELECT Employee, ChildSex, Max(ChildAge) as Age

FROM EmployeesChildren

GROUP BY Employee, ChildSex) a

ON e.Employee = a.Employee

and e.ChildSex = a.ChildSex

and e.Age = a.Age

This would return the result you ask for if I had a way to distinguish the two patient 01 rows

select t.Patient, t.arm, t.bestres, t.delay

from t

inner join

(

select

arm,  bestres, min(patient) as...

Your example has a flaw.  What is the difference between the two Patient 01 rows?  There is nothing to distinguish them.  You need some key:  a date, an identity.

I found the execute process task in SQL 2000 DTS.

I have basic workflow (Task2 starts on success for Task1, Task3 starts on success for Task2).  I would prefer not to link the sets in a workflow.  I'm not sure...

The following is clumsy, but it works:

CREATE FUNCTION dbo.GetEmployeesByUserID

 (@userid int)

RETURNS TABLE

AS

 RETURN SELECT e.EmployeeID from mstEmployees e

         where (exists (select 1 from secUserMasterMappings s

             where s.UserID = @userid...

This is puzzling.  The executesql step 1 is not disabled is it?

I had a couple puzzles with your script (you have the wrong table in your second append query). Also, I didn't understand your result for user 1. Since all of...

What derived table did you try?  What are you trying to achieve?

select o.*

from z_inquiry o

inner join

where inquirydatetime = (

    select frontend_id, max(inquirydatetime) as maxinq_dt

    from z_inquiry i

    group...

Have you tried doing a backup and restore?  That many times can be easier.  When trying to move an entire database I get into problems with relationships.

Do you have logins...

You can store them in an image datatype.

The problem is that you need application code to load the data.

I have set the priority for the Task3 steps higher than normal.  I will watch to see if that achieves the results I want.

Is there a reason that you are not using the execute process task?  I find that when the batch file returns an error, the execute process shows an error.