Skip to Content
0
Former Member
Dec 01, 2006 at 10:08 PM

DB Connect MS SQL

37 Views

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?