Now that's a much simpler alternative. The output from xp_cmdshell is streamed into a table.

Once the messages are there you can poke and prod them to work out what you...

Also, sample data and expected output is very helpful

Without seeing how your package is setup, I'd say the most likely problem is to do with workflow. Fiddling with the workflow precedence during package execution can lead to a...

See my post over here

http://www.sqlserver.org.au/forums/ShowPost.aspx?PostID=764

Post the script in the Script Library so all can enjoy.

Ahh ... yes, missed that important bit of information in your original post.

In SQL 7, I think there is an option to output to a text file and I believe...

From the dim dark annals of my brain, I think you need to add the table to the relationships page twice. Then you can link the relevant fields.

It's been ages...

You enable logging from the Logging tab of the Package Properties dialog. Just right-click on a blank space on the design panel and choose "Properties"

To get the logging detail take...

Best solution is to enable DTS package logging. Then you'll be able to query the sysdtspackagelog and sysdtssteplog tables in the msdb database for specific error information.

As you've stated deadlocks usually only occur if there are update activities. So there must be something else that is causing the locking. Maybe something on the client, or something extra...

Validation of parameters is provided by means of a drop-down list, as I've illustrated, prevention of null inputs and basic datatype mapping. To me this is not strange at all, that's like...

The only way you'll be able to achieve that is with some VB.Net code, or an external .Net assembly.

I'm not sure this would solve your issue either. At what point...

As mentioned in my previous post, don't just set it to 2000, experiment with a range of values and see what gives you the best performance. On your hardware, a...

Do you have a nums table in your database? This is a general purpose table that has a single integer column with numbers increasing from 1 up to an abitrary...

A bit of your script here might help us help you