SLT to MSSQL error

[former_member228828]

Hi,

I'm trying to connect the SLT to MSSQL as target system. I've created the DBCON entry in the SLT system for the MSSQL and check that the  connection is established. After that I configured the SLT system with ECC as source as this MSSQL as target. When I tried to do the initial load for DD02L I'm getting error that 'Creation of table DD02L is failed'.

Is there a way to check if the connection from SLT to MSSQL is working by writing a small SQL statement to create a table on MSSQL in the SLT  system. What else could be the reason for the error that I'm getting ?

Thanks

Alok

[kr_pavankumar]

Hi Alok,

SE38 --> ADBC_TEST_CONNECTION --> give the DB connection name (SLT to MSSQL)

Execute.

This way you can check the db connection is working or not. Thanks!

-- KRPK

[former_member228828]

Hi Pavan,

I already did that and the connection is okay but during the initial load of table DD02L I'm getting this error.

Any idea ?

Thanks

Alok Varma