Hello,
I have a MS SQL 2005 srv and want to upload data from a table into my InfoCube in BW.
The InfoCube works fine with a CSV File.
It contains 3 fields: 0CALDAY, a simple number infoobject and a char(8) object.
Connection to the SQL Srv is fine and when selecting the datasource/table i can see the content of that table with "view table content".
(As datatype "datetime" does not work, i used a char(8) attribute in mssql with yyyymmdd syntax like in my csv file)
but when i want to load that data through my infosource with infopackage into my infocube, there is always an timeout error and my cube recieves no data.
can someone help?