What you need is to apply a workflow to this process.  Select the first task to complete then the second (if they are transform tasks, select the target connection of...

What are the schemas for the three tables?  What are the unique/primary constraints for these tables?

Russel Loski, MCSD

I usually use sub-queries:

select t10.Partner, t10.staffname, t10.clientcode, t10.clientname, t10.DebtTotal

from

  (SELECT TOP 10 Partner, staffname,clientcode, clientname,sum(DebtAmount) AS  DebtTotal

  FROM tbl_Billsfortheyear INNER JOIN tblStaff ON staffindex = Partner

  group by Partner, clientcode,...

Do you have IIS installed?  And dot net framework 1.1?

Russ

I don't have the means to test this (let me know if it works:satisfied:

dim cmdXML as new SQLCommand ("xmlProc")

dim xmlInput as XMLReader = cmdXML.ExecuteXML()

dim...

I used it on one project.  It had a few problems in set up (you had to be very careful on most steps and starting over could be a pain).

Russ

Actually your problem is a lot simpler than I made it.

You need a second global variable.  You need one activex script, one dynamic properties task and of course the execute...

That is easy.  Click the tools/options menu.

Then go to the Connections tab.  I have the "Query Timeout (seconds)" set to "0" which I believe means don't timeout.

Russ

This might work:

set @oldpk = (select name from sysindexes i where id =

 object_id(@oldtable) and indid = 1)

indid = 1 -- Indicates the clustered index which frequently is the key.

Also try:

set...

That is something the client sets.  I think that the server has a timeout, but by default it is unlimitted.

What tool are you using?  Each one has a different method...

Create an execute sql task that executes on error.  You would have a seperate one for each connection.

Set it to use the connection where you will be writing your error. ...

This is rather fun and relatively easy to do:

You need four tasks

ActiveX to get the file list

Dynamic Properties task (step called LoadPackageName to work with the code below)

ActiveX script to...

These two roles are database specific roles. Is the login in a sysadmin group?

I am going to suggest a way to prevent people from saving dts packages on your server. ...

I tend to allmost always use left join.  It highlights the table that is going to show all rows.

I think that I tend to use Right joins when I am...

I have some ideas of what you could check.

Could some windows system setting be formatting the date with a hyphen?

What kind of transformation is used to transfer the date column...