hi,

It s a sentence that has benn used over collacially and there is nothing wrong in it as far as the concept of questioning has reached the user.

Regards

cholan

hi,

Had you got the problem solved mate

vijay

hi,

ODBC Cubes can be created depends on the requirement mate 🙂

cheers

vijay

hi,

Try the possibility of using perspectives in the cube.It will definetly speed up the cube processing.

cheers

vijay

hi,

Could you attach the screenshot of the error which you got, so that i can check into it.:)

cheers

vijay

hi,

what you mean by Automate the procedure? could you specify me more insight about the requirement of yours.Because we can perform the automation by creating jobs as well as by...

hi,

Once you got the deployement done after addig a new dimension..you have to process the cube to retrive the datas from the relational database to the sql server cube..So...

hi,

Both you can use.but the named calculation is the one i prefer because its an feature of SSAS 🙂 .

vijay

hi ,

check the below link for the creation of packages.

http://www.codeproject.com/KB/aspnet/Schedule__Run__SSIS__DTS.aspx

vijay

hi,

For running a package as a job.user must have the windows authentication enabled for the particular datasource or database which he was using for the package..Check for the authentication,it...

hi,

Is the file anyhow troubles you? Whats the issue with the file mate..

vijay

hi,

If the data type in the database is varachar or nvarchar then you must use the dt_wstr datatype in SSIS. So use the derived column in the SSIS then...

hi,

Rename the file to some abc.txt and try it mate...It will work

vijay

hi,

I think surely its an permission or accessibility related error.Check the following..

When you are getting this error. Do you get this error when it is running from the visual...

hi,

Had you got any error or the wrong result......whats the result you got with the above code...

vijay