Yup query time out is set to zero in managemetn studio and on the server itself. Not cross-server, just remote from my local machine. And not all queries...

Yes, we used RetainSameConnection=True in the Connection Manager also, and it worked for the transactions.

We had to stop using DTC altogether.

Thanks all!

Jamie, thanks for adding "In this case the transactions are handled by DTC."

I've been trying to find out what kind of trans. the Sequence Container used.

We've had issues with...

Really looking forward to part 2!

We were trying to do this, finally tried to use a stored procedure and got snagged trying to access all the .net image libraries from...

Thank you Tommy Bollhofer

I needed something like this for a non-maintenance plan ETL package to clean up archived files.

Still wish we were able to use C# in SSIS.

That's good news at least.

Unfortunately, we had to put SP2 on hold here, we hit a bug where the jobs stopped running due to a profile issue,

on our DEV...

There were no lookups involved in the packages I was working on at the time.

No deadlocks were shown in sp_who2 when the packages hung.

I could not find any thing in...

Thanks for the reply.

No there are no nulls in the primary key tables.

An intermediary database without keys is certainly possible, but in this case it's just a data update for...

Yeah you probably will need a book (or two). SSIS is *completely* different from DTS.

Technet has a good introduction

http://www.microsoft.com/technet/prodtechnol/sql/2005/intro2is.mspx

And there's stuff in BOL of course too.

They are the only compact graphic tool I've seen and it looks great.

There's a lot of new hope with XLCubed and all for more flexible use with RS.

We need components...

Found it finally!

SQL Server 2005 SP2 updated the library.

Be careful if you install Visual Studio later, it may overwrite that dll, and even VS-9 has an older version of...

Tired grabbing the Microsoft.ReportDesigner.dll from another developer who has VS-9, it was a newer version but still does not contain CustomReportItemDesigner needed for the CRI designer.

Has anyone had success with...

If you are using the SQL manager remotely, try terminal servicing into the machine itself. (The issue started after I ran SP1 locally, but has not appeared on dedicated...

This is great timing we were just discussing this in regards to using HaDoop or SQL Server to do some very large, close to terabyte, imports and transformations.

I have a...

thanks so much for the tips, I'll check them out.

Very good to know, I appreciate the info. a lot!