Viewing 12 posts - 1 through 12 (of 12 total)
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.
December 19, 2007 at 9:06 am
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
December 17, 2007 at 1:38 pm
Thanks a lot, it helped
December 11, 2007 at 12:39 pm
This is my query
WHEN TRANSACTIONID IN (1,2,3) THEN PAYMENTDT
END) AS Q1
WHEN TRANSACTIONID IN (4,5,6) THEN PAYMENTDT
END) AS Q2
WHEN TRANSACTIONID IN (7,8,9) THEN PAYMENTDT...
December 11, 2007 at 9:47 am
Thanks for the reply. I would like to get a query for the same.. Need to get this value in my application
November 7, 2007 at 12:16 pm
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...
October 29, 2007 at 9:34 pm
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...
October 29, 2007 at 4:35 pm
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...
October 29, 2007 at 2:47 pm
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...
October 29, 2007 at 12:25 pm
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...
September 25, 2007 at 3:41 pm
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...
September 25, 2007 at 12:34 pm
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...
September 6, 2007 at 7:55 am