These are 4 jobs and not 4 DTS packages. Each of the 4 jobs have a number of DTS packages inside them and they are pulled from different datasources.

Thanks

Vinu

If you remember the package name that you used it for saving at the time of the Import task, then you can actually view it using your BDIS

1) Open...

Thanks a lot, it helped

Vinuverma

This is my query

SELECT

POLICYID

,TRANSACTIONID

,MAX(CASE

WHEN TRANSACTIONID IN (1,2,3) THEN PAYMENTDT

END) AS Q1

,MAX(CASE

WHEN TRANSACTIONID IN (4,5,6) THEN PAYMENTDT

END) AS Q2

,MAX(CASE

WHEN TRANSACTIONID IN (7,8,9) THEN PAYMENTDT...

Thanks for the reply. I would like to get a query for the same.. Need to get this value in my application

Wisenut

Hi any idea about this error

Errors in the high-level relational engine. The following exception occurred while an operation was being performed on a data source view: Could not load type...

Thanks a lot, whew that was a bit of information. Suppose the Servername is Server1 and I created a database Test1, then when the user tries to deploy the cube...

Thanks a lot.. One clarrification on the second point. Do i create the role on the Analysis Server or the Database Engine. If its on the Analysis Server, then do...

Thanks a lot it worked.. Couple of questions on this..

1) Is there any recommendation as to which account the SQL Server Analysis Services should be running on. As of now...

Hi David,

That really was a very helpful advice. I removed the DENY on the CONTROL and the user can access all the tables. I added another user to the...

Hi David,

Thanks for the reply. I have the the role created and then I selected the securables tab, clicked on the Add button, when the Add objects window popped...

I have not been able to figure it out. Did some debugging steps from my end

1) Used runas command and forced a command window which runs under the SQL Agent...