Lee posted on January 23, 2010 10: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/R2 , SQLServerPedia , SSIS , Vids  Tags:

Comments


January 23. 2010 10: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 06: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 08: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 22: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/

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading




by Lee Everest, M.S.

Search


Ads

Calendar

«  July 2010  »
MoTuWeThFrSaSu
2829301234
567891011
12131415161718
19202122232425
2627282930311
2345678
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