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...

I have put a Run SQL task that first drops an index, then a second Run SQL task that creates that index.  The first task runs before the transformation and...

I had some theories as to what might have happened.  What did you do to fix it?

Russel Loski, MCSD

Actually what I mean by x < 5 is that if the varchar is less than 5 I convert to char.  My rationale for that is that a varchar takes...

I have never seen this problem.  Here are a couple thoughts.

Try changing the SQL field from ntext to text.  ntext is for Unicode data and text is for ANSI data.

Another...