DSXchange

Hi,
Can you please tell me the full syntex to connect to seqserver from unix command prompt using sqlcmd.
When i am running this command it got failed.

Hi, I am connecting to SQL Server using ODBC connection and i have requirement where i need to call package after job completes. EXEC msdb.dbo.sp_start_job @job_name = 'app.GetVisionCasaDailyExtract'; My question is can i run this in Stored Proc stage if not then which stage should i use to trigger ...

Hi Chulett,

This is interesting.I am going to talk to DBA fist to check if it is using bulk load.

Thanks a lot for this information.

Hi,
I made changes in DSN

EnableBulkLoad=1

Rest are having default value:-

BulkBinaryThreshold=32
BulkCharacterThreshold=-1
BulkLoadBatchSize=1024
BulkLoadOptions=2

I reran the job but still i cant see any change .Again in log i can check is job is generating insert statement.

My ODBC connection details are below:- [MSSQL_SRE] QEWSD=2456224 Driver=/opt/IBM/InformationServer/Server/branded_odbc/lib/VMsqls25.so Description=DataDirect SQL Server Native Wire Protocol AlternateServers= AlwaysReportTriggerResults=0 AnsiNPW=1 ApplicationName=Caissa ApplicationUsingThreads=1 Auth...

Hi, I want to perform bulk load on sql server databse but i am using ODBC connection to sql server. I tried to do bulk insert using DRS connector stage but it seems that it is inserting throgh normal load.I got below entry in log. Generated INSERT statement: INSERT INTO AIT_Staging.dbo.SRE_CORRECTED...

Where the batch is scheduled and which scheduling tool you are using?

Hi ,
Its good to use mq connector stage because it has useful supports like mq dynnamic queue, transmission queue,shared clusted queue. It can also have standard reject link.

IsValid("date", to_transf.EMP_START_DT_ORIGINAL, "%yyyy%mm%dd")=1 Put this in transformer constraint to output link and draw another link as reject from transformer and make constraint condition as "Otherwise". If your input records are not in valid date format it will ...

What load tecnique you are using in connector stage...bulk load or normal load?

Hi,

Iit seems to be a interview question.
Please tell us that what you have attempted so far.

Hi There,
You need to get return value from SP and based on return value you need to success or fail the job, that you can do in downstream transformer stage.
First you have to understand and check the procedure what return code you get in case of fail and success.

Thanks Sura and everyone.

Hi Chullet,

My job design is like below:-

Ora Src-------TSFM------> OraTgt-------->Reject

and i have defined below reject condition in oracle reject:-

sql error-data truncation.

I made target column type as varchar,and hence value more then (14,2) for this column is going to reject.

Hi There, I have done below tests :- IsValid("decimal[12,2]","1234567891011.123")=0 IsValid("decimal[12,2]","12345.12")=1 IsValid("decimal[12,2]","ABC01")=0 IsValid("decimal[12,2]","12345,12")=0 It seems to working fine....