DSXchange

This issue has been resolved :D . Actually in my Target SQL server table two columns are defined as datetime , Before, I was defining this two column as Timestamp in my DS job. I changed to char now its working fine.

I created new server job.
SQL type :- Auto Generated

Namit,
You can connect to SQL server by ODBC Stage or DRS Stage.
Make sure you have configured your ODBC connection on ETL server.


Thanks

The same job you are trying to run? No. Thanks Ray, I included DSLogInfo() into routine code then I realize that routine code was getting kicked but it was stucking there it self. Now I included Bad Handle check and DSDetachJob (I found from one of your post ;) )so it is working fine :D . Once agai...

Not without a better explanation of your job. I can't follow what you are doing in the UserVariable Activity stage... running a routine? And the return value is passed as a Job Parameter to the Job Activity stage? Yes Sorry for creating confusion :cry: Routine is simple. It takes jobname as argumen...

I am running job sequence. It has two activity 1. user variable activity and 2. job activity. In user variable activity I am defining job parameter and value of that parameter is return value of a routine. this Parameter I am passing in following job activity. Problem is: It is starting but keeps ru...

DSguru2B wrote:Do you have BigInt as any of your target datatypes?

I Have Int(10), varchar(50), char(5), timestamp(32)

chulett wrote:User-defined SQL?

I tried both way USER DEFINED and AUTO GENERATED SQL

Hi All, I am getting following error log while loading to SQL server DB using DRS stage. Dynamic_RDBMS_8,0: Warning: Audit_job.Dynamic_RDBMS_8: [DataDirect][ODBC SQL Server Driver]20172 Dynamic_RDBMS_8,0: Failure during execution of operator logic. Dynamic_RDBMS_8,0: Fatal Error: Fatal: SQLBindParam...

Or try UtilityHashLkp - gerenate DUMMY key as lkp key.

arsheshadri wrote:Hi,
Can you please explain a bit on socket?
Can I ask him to kill dsrpc process?

Search with clear+socket words(Search for all terms)

Ask your system admin to clear the socket,in this case.

Wolfgang,
Can you please share those useful links ?

Thanks

Can you provide more details.

You can do:-

Read installments as source ,and do ODBC look up against same table,using installments as key.

Thanks Ray,

All, I have searched thru this forum but I could not resolve: Iusse is: I am using Env. verialble as job paramenter.I have set default value at Administrtor client and In job level parameter I have kept default value as $PROJDEF. So when I am doing view data and when windows to enter parameter value...