Archive for July, 2009

IP > Server Objects > New Linked Server>

Linked Server (Any name you want to use)
Other data source (select this one)
Product name (put the IP here)
Data source (put the same IP here)

Be made using this security context (select this one)
save the user name and password

Press OK

Read Full Post »

Once a date table is creted from SSAS (right click on the dimentions and selecting the appropriate options)  the same talbe can be used multiple times. This same date table can be used to create different date dimensions.

Read Full Post »

My recommendations are:
SQL Server – Save here if you want to use SQL server Athentication (e.g. when scheduling a SSIS package)

SSIS Package Store – Save here if you just want Windows authentication (e.g. to run the package in another SSIS package). Please also note that the file here are just references to the location of where they reside in HDD.

Read Full Post »

SSIS package can be run throguh SSMS jobs automatically only if

  1. it is created in the same machine
  2. the package accespts user key (user key is the saved profile for the user which created it) – (I don’t know how to do this from a different machine)

then either saving it to SQL server or File system of the SSIS server would allow the job to refer it.

When executing a SSIS “execute package task” from differenct server (not local) – the package can be saved to accept password but this CANNOT be run

automatically as there will be prompt asking for the password.

Read Full Post »

1) Build a SSIS package and use “Analysis Service Processing Task” control to identify the cube to process.
2) Copy this package to the Server and create a job to run this package
3) In the script run the job. e.g. “EXEC MSDB..SP_Start_Job NameOfTheJob

Read Full Post »

For each single quote type TWO single quotes (inside a full quote).

For example, to display ‘Hello’:

print '''Hello'''

Read Full Post »

  1. Create a group in Windows say ‘CubeGroup’
  2. Create as many Windows users and passwords as needed and add them to the group above
  3. Create a role in SSAS cube then add ‘CubeGroup there

Read Full Post »

Older Posts »