Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    San Francisco
    Posts
    10

    Unanswered: OLAP Services Task and C# .Net

    Hi,

    I try to load in a C# application a DTS Package containing only one OLAP Task.
    But the "LoadFromSQLServer" command hangs for 1h30 before retrieving the DTS Package information.
    The same code is working perfectly fine for other DTS Packages.

    I have already set the Workflow properties of the DTS task to "execute on main thread". It doesn't change anything.

    HELP!!!!

    Thanks for listening.
    Nicolas.

  2. #2
    Join Date
    Feb 2004
    Location
    San Francisco
    Posts
    10
    I have found the solution. I had to change the thread apartment state of my .Net app from MTA (Multiple Thread Aparement) to STA (Single Thread Apartment).

    In the Main function, the very first line shoud be:

    System.Threading.Thread.CurrentThread.ApartmentSta te = System.Threading.ApartmentState.STA;

    HTH
    N.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •