OLAP

If I paste a dimension in excel (import data) per default all data is
selected.
How can I cange this default.Not 100% on your needs but you could create a view off the dimension and use
the view in your cube as a dimension that has the criteria you need.
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Franz Chernjak" <f.ch@.gmx.at> wrote in message
news:OuwbWzF%23DHA.3428@.tk2msftngp13.phx.gbl...
> If I paste a dimension in excel (import data) per default all data is
> selected.
> How can I cange this default.
>
>

ODBC-based to OLE DB-based data transfer

I would like to transfer selected data from an ODBC-based table to a OLEDB-based table. However, there isn't a data flow source on the Data Flow Design screen to accomodate such an action. Please help!

Roberto,

You need to create a package with a DataFlow task in it; then inside of the DataFlow; then from the toolbox you can use a Data Reader component to use an ODBC connection. Additionally you will need to add any data transformation logic/tasks and an OLE DB destination component.

There is not such 'all-in-one' task to perform what you want; but you have many components that you can combine together to get it

Rafael Salas

ODBC-based to OLE DB-based data transfer

I would like to transfer selected data from an ODBC-based table to a OLEDB-based table. However, there isn't a data flow source on the Data Flow Design screen to accomodate such an action. Please help!

Roberto,

You need to create a package with a DataFlow task in it; then inside of the DataFlow; then from the toolbox you can use a Data Reader component to use an ODBC connection. Additionally you will need to add any data transformation logic/tasks and an OLE DB destination component.

There is not such 'all-in-one' task to perform what you want; but you have many components that you can combine together to get it

Rafael Salas