http://msdn.microsoft.com/en-us/library/cc671628.aspx

We went for XML files. We have a consistent folder location across all SSIS server and development PCs (e.g. C:\SSIS\Configs or somesuch) which works very well for us. ...

Might be a red herring but... does the last comment from sql.techo in this post help?

http://www.sqlservercentral.com/Forums/Topic793585-147-1.aspx#bm821697

Yep Phil, you read my mind!

Books online is all well and good but isn't really telling us what effect this property has on the package or how it handles the...

Gila is absolutely correct, this is a backup application attempting to snapshot the server including database files. If it helps, the application is running under an account with sysadmin...

Hi all,

You're best bet to understand what's happening is to read these two:

http://support.microsoft.com/kb/919023

http://technet.microsoft.com/en-gb/library/cc966520.aspx

Cheers,

Martin

Hi Dost,

It's all about transaction management or more to the point distributed transaction management. In our case, we were trying to do to much in the one package and...

It sounds to me a lot like the Distributed Transaction Coordinator which is tripping up a lot of people here.

What seems to behappening is that SSIS is using DTC to...

Hi Ellis,

To the best of my knowledge this is where SQL Server installs write their log files to. In it you should find log files generated by your SQL...

*sigh* I'm losing the plot here. :crying:

Snapshot isolation cannot be used within distributed queries.

http://msdn2.microsoft.com/en-us/library/ms188277.aspx

"For most applications, read committed isolation using row versioning is recommended over snapshot isolation for the following...

Is anyone else able to reproduce this?

Has anyone else been able to force a required snapshot transaction with SSIS?

Cheers,

Martin

Hi Michael, thanks for the quick response!

As you suggested, I have added a second Execute SQL Task configured in exactly the same way as the first one described previously except,...

Unfortunately you're in for a world of grief.

Your options are:

a) reinstall SQL Server and choose exactly the correct collation you need.

b) rebuild master

Either way you will need to either recreate...

Sorry, meant to post this link too.

http://support.microsoft.com/kb/325335

Check out the bit about "Change the collation of the master database in SQL Server 2000"

Hi Helmut,

What version of SQL Server are we talking here?

Create Procedure usp_MyProc @Ticket Nvarchar(50)

as

 SELECT DISTINCT sc.Name as FieldName, so.Name as TableName

 FROM sysobjects so WITH (NOLOCK)

 INNER JOIN syscolumns sc  WITH (NOLOCK) ON so.id = sc.id

 WHERE  so.type ='U'

 AND sc.name like @Ticket

Then...