Results 1 to 8 of 8

Thread: SQL Server 2000 DTS Package - Executions of Analysis Service

  1. 08-14-2006, 07:10 AM #1
    Sreeraj
    Sreeraj is offline Registered User
    Join Date
    Sep 2005
    Posts
    14

    Unhappy SQL Server 2000 DTS Package - Executions of Analysis Service

    Hi,

    I have a problem with Analysis Services Processing Task in DTS.

    I can't run a Package Programatically, which uses Analysis Sevices processing task.
    The same problem occurs when I try to execute the Package through Pacakage Execution Task.

    Kindly give me a solution to this.

    -----------
    Thank you,

    Sreeraj.P.T
    Reply With Quote Reply With Quote
  2. 08-14-2006, 08:13 AM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Any error message?
    Reply With Quote Reply With Quote
  3. 08-14-2006, 09:54 AM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Does job owner or your windows account have proper permission to access source data?
    Reply With Quote Reply With Quote
  4. 08-16-2006, 03:31 AM #4
    Sreeraj
    Sreeraj is offline Registered User
    Join Date
    Sep 2005
    Posts
    14
    Quote Originally Posted by skhanal
    Any error message?
    No, there is no any error message.
    Reply With Quote Reply With Quote
  5. 08-16-2006, 03:33 AM #5
    Sreeraj
    Sreeraj is offline Registered User
    Join Date
    Sep 2005
    Posts
    14
    Quote Originally Posted by rmiao
    Does job owner or your windows account have proper permission to access source data?

    If I try to execute that task only, it completes successfully. It shows problem only if I execute it programmatically or through any Package Execution task.
    Reply With Quote Reply With Quote
  6. 08-16-2006, 08:36 AM #6
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    How do you run it programmatically? What kind of problem you got? Does caller have proper permission to access source data?
    Reply With Quote Reply With Quote
  7. 08-17-2006, 01:00 AM #7
    Sreeraj
    Sreeraj is offline Registered User
    Join Date
    Sep 2005
    Posts
    14
    I am trying to execute it through C# ASP.Net code using DTS library. All other package packages, except this, exceutes well.
    Reply With Quote Reply With Quote
  8. 08-17-2006, 08:17 AM #8
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    What does the package do? Any remote data source involved?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules