How do I fix the error unable to enlist Sybase database in distributed transaction?

I had this same problem when I tried to create a transaction around a read from a Gupta SQLBase. Basically, it seems that SSIS (at least as of 2005) isn't able to enroll any other providers in a transaction as part of a package. I've tried a few times without luck, and usually I just end up reading the data from my OLEDB into a temporary table, and then creating a transaction around the import of that data into its resting place in SQL Server.

That's the read side, though - if you're trying to use a transaction to write to SYBASE, you'll need to do something on that side - SSIS won't be able to use a transaction to push data to another provider.

I had this same problem when I tried to create a transaction around a read from a Gupta SQLBase. Basically, it seems that SSIS (at least as of 2005) isn't able to enroll any other providers in a transaction as part of a package. I've tried a few times without luck, and usually I just end up reading the data from my OLEDB into a temporary table, and then creating a transaction around the import of that data into its resting place in SQL Server.

That's the read side, though - if you're trying to use a transaction to write to SYBASE, you'll need to do something on that side - SSIS won't be able to use a transaction to push data to another provider. I addition to that, I didn't even want my transaction to extend to Gupta - I only wanted to enroll my INSERT/UPDATE on the SQL Server side in a transaction, to block users from reading half-updated data, but SSIS refused to allow me to wrap the process in a transaction because Gupta didn't support it. There seems to be no support for transactions just on certain providers, or only on the "Write" side of the process but not on the "Read" side.

I have ended up resorting to the same approach :( – AlanR Jan 22 '09 at 18:14.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.

Related Questions