Accessing MSSQL server using DRS stage
Posted: Wed Mar 23, 2005 7:18 pm
Hi,
I am facing a strange issue with DRS stage. I have a simple job that reads data from a table in ORACLE and inserts it into a table in MSSQL Server. I am using DRS stage to connect to both the databases. The reading part is fine but while writing the records into MSSQL Server the job is inserting either nothing OR some weird characters in the VARCHAR columns. I have tried using MSSQL Server and ODBC as database type but nothing worked.
If I replace the target DRS stage with ODBC stage the job works fine.
Job design
[DSNNAME]
Driver=/home/dsadm/Ascential/DataStage/xxxx/VMmsss19.so
Description=DataDirect SQL Server Wire Protocol
Database=GGGG
LogonID=uid
Password=pwd
Address=XXXXXX,1111
QuotedId=No
AnsiNPW=No
Does anyone have any clue why is this happening.
Regards,
-Sumit
I am facing a strange issue with DRS stage. I have a simple job that reads data from a table in ORACLE and inserts it into a table in MSSQL Server. I am using DRS stage to connect to both the databases. The reading part is fine but while writing the records into MSSQL Server the job is inserting either nothing OR some weird characters in the VARCHAR columns. I have tried using MSSQL Server and ODBC as database type but nothing worked.
If I replace the target DRS stage with ODBC stage the job works fine.
Job design
Below is the entry that we have for the target MSSQL Server in .odbc.ini file in DataStage host machine.DRS-->TRF-->DRS
[DSNNAME]
Driver=/home/dsadm/Ascential/DataStage/xxxx/VMmsss19.so
Description=DataDirect SQL Server Wire Protocol
Database=GGGG
LogonID=uid
Password=pwd
Address=XXXXXX,1111
QuotedId=No
AnsiNPW=No
Does anyone have any clue why is this happening.
Regards,
-Sumit