Lee posted on January 23, 2010 08:20

I was looking around the other day on Google! and elsewhere for info on SSIS transactions and MSDTC setup, but didn’t find much; actually what I found were a lot of questions around their use. Check out my screencast as I geek with them, and try to make heads or tails out of their use. Expand the embedded video and check it out!

Hopefully this will help someone down the road when setting up and configuring SSIS packages to use transactions.

 

 

 

 

Lee Everest, M.S.
www.texastoo.com

 

------------------------

This dude chose not to watch the vid

Crash

 

Code: http://texastoo.com/images/ssistransactions.zip


Posted in: SQL Server 2008 , SQLServerPedia , SSIS , Video  Tags:

Comments


January 23. 2010 08:47
SSIS Transactions and MSDTC configuration and setup

You've been kicked (a good thing) - Trackback from DotNetKicks.com

http://www.dotnetkicks.com/database/SSIS_Transactions_and_MSDTC_configuration_and_setuphttp://www.dotnetkicks.com/database/SSIS_Transactions_and_MSDTC_configuration_and_setup


United Kingdom Dhruv
January 26. 2010 04:07
Hi Lee

We have a scenario where a SSIS package is using a MSDTC transaction. The remote server is running on Windows Server 2008 and has sql server 2008. The desktop on which SSIS package is executing has windows xp and sql server 2008. Even after configuring the MSDTC as specified we are still hitting issues with the package.The errors are similar to ones that you mentioned in your video.Any ideas if there is anythig extra that needs to be done for enabling MSDTC on a windows 2008 Server?

no site


United States lee
January 26. 2010 06:57
Can't think of any off hand. You are sure that the firewall is allowing the .exe to pass through?  What I would do to debug is see if you can get it running locally first, or maybe check the even logs on the workstation and server.  I'd also probably look at SQL Profiler to see if a transaction has actually been attempted. Open the MSDTC panel and see if you can find aborted transactions.

http://www.texastoo.com/http://www.texastoo.com/


United States Lee
January 26. 2010 20:15
Also try running it on the server by right-clicking the .dtsx file >> Open >> Execute.  See if the problem is communication between the local and remote host.

http://www.texastoo.com/http://www.texastoo.com/

Comments are closed

by Lee Everest, M.S.

Search


Ads

Calendar

«  March 2010  »
MoTuWeThFrSaSu
22232425262728
1234567
891011121314
15161718192021
22232425262728
2930311234
View posts in large calendar

Tags

Disclaimer
The opinions, code, examples, et.al. expressed herein are my own personal opinions and do not represent my employer's view in any way, shape form, or fashion.  All code for demonstration purposes - no guarantees, either written or implied, are made.

© Copyright 2010 Lee Everest's SQL Server, etc. weblog