SQL Server Business Intelligence

SQL SERVER 2005 & 2008 IS THE MAIN THEME OF THIS BLOG

Friday, December 09, 2005

SQL Server 2005

While I was working for Reuters I had the opportunity to have access to SQL Server 2005 as Reuters was one of the Technology Adoption Programme (TAP) partners. I have been working with SQL Server 2005 over 2 years now.

I have concentrated mainly on SQL Server Integration Services (SSIS), but have spend time in understanding new features with SQL Server database as well as SQL Server Analysis Service (SSAS).

Thanks
Sutha

posted by Sutha Thiru @ 3:22 AM  

2 Comments:

  • At 10:38 AM, Blogger Eugene said…

    Sutha,

    I am working on getting the SQL Server 2005 SSIS Package to use a transaction, but I ran into same problem as in this post
    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=184654&SiteID=1
    The issue I am running into is there is no documentation on how to setup a transaction using SSIS. I have setup 5 packages to run in sequesnce and i need to wrap them up in a package. So I set the first Package TransactionOption = Required. Now I get the error you had in your post...

    "Error: The SSIS Runtime has failed to start the distributed transaction due to error 0x8004D01B "The Transaction Manager is not available.". The DTC transaction failed to start. This could occur because the MSDTC Service is not running. "

    Is uninstalling Norton really the solution? Is there a step I missed? Any help is appreciated.

     

  • At 12:21 AM, Blogger Sutha Thiru said…

    Hiya

    It was a while ago now, but to be honest I dont think that was the problem.

    Please check the following:
    1. MSDTC is running under network service account.
    2. All the Tick Boxes under "Security Configuration" is selected.
    3. Make sure MSDTC started before executing package (i know it sounds daft)

    Yes if you want the transaction to be activated you need to set the TransactionOption = Required, then childern will under same transaction as long as they have "Supported" selectd under TransactionOption, which is default.

    If this didn't resolve your problem let me know I will investigate further.

    Thanks
    Sutha

     

Post a Comment

<< Home