Post reply

Is it possible that I change the data''s type when I create the DSV in the Visual Studio 2005?

  • February 2, 2007 at 1:25 am

    #194133

    Hello everyone:

        Recently, I was responsible for creating a analysis services project with the SQL Server Business Intelligence Development Studio in Visual studio 2005. I encountered a error that the data type is not supported when I tried to add the table from a remote Oracle server. I can not modify the data type in the oracle server. Is it possible that I change the data's type when I create the DSV in the Visual Studio 2005? (if I have known the table's name)

      Help me Please! tell me the steps or some references if it is possible

    Kindest Regards,

    winnie.wang

  • February 2, 2007 at 2:36 pm

    #687568

    If you can get the table in to the DSV then you can change the properties for each column in each table.  Once (if?) you get it in there, select the field/column you want to modify and then review/change the field settings in teh Properties pane (defaults to bottom right hand side of Dev Environment).

     

    Steve.

  • February 2, 2007 at 8:02 pm

    #687611

    I think that is why I can not continue.....

    The problem I encounter is that I can not add that table to the DSV because of the unsuited the datatype for the column.

    I think I should query and modify the table in the DSV...

     

    Thanks ^_^

    Winnie

    Kindest Regards,

    winnie.wang

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply