DSXchange

Is it possible to call a SQL Server stored procedure in a ODBC stage that is a reference link to a transformer

Craig,

Thank you for all your help. As per your suggestion,I moved the marker as a part of the where clause when calling the function and it worked.

Thanks again
Samir

I have the Account_nsp_id as the key. Yes the column order is the same. Does the column name in the stage have to match the column names in the query.

Ray,

That is correct. We are passing the account numbers to get data for them.

Thank you
Samir

Yes one of the four column selected is substituted in the parameters marker. The marker is for column Account_nsp_id. 4 columns are defined in the stage.

Yes one of the four column selected is substituted in the parameters marker. The marker is for column Account_nsp_id. 4 columns are defined in the stage.

Yes one of the four column selected is substituted in the parameters marker. The marker is for column Account_nsp_id. 4 columns are defined in the stage.

Hi Craig,

There are no where clauses. I am calling a function in SQL Server that is returning data.

Below is the sql from Select Account_nsp_id,BENCHMARK_nsp_id,SEQUENCE_NUM,PRIMARY_BENCHMARK from V_Account_Benchmarks('ABC',?)

Thank you for your help.

Regards
Samir

Hi Craig,

There are no where clauses. I am calling a function in SQL Server that is returning data.

Below is the sql from Select Account_nsp_id,BENCHMARK_nsp_id,SEQUENCE_NUM,PRIMARY_BENCHMARK from V_Account_Benchmarks('ABC',?)

Thank you for your help.

Regards
Samir

Hi Craig,

Thank you for your response.
I verified the number of result columns defined in the stage. They match the number of columns in the query.
Is there something else that I should verify.

Thank you
Samir

Hi Craig,

Thank you for your response.
I verified the number of result columns defined in the stage. They match the number of columns in the query.
Is there something else that I should verify.

Thank you
Samir

Micheal,

Thank you for your reply.

Where do I find multiple results check box to check it.

Thank you
Samir

I am trying to run a job that has a reference link. There is an ODBC stage that has a reference link to the transformer. This stage returns multiple rows for a particular id which I need to either insert or update into the database. I get the below error when running the job. DSD.BCIOpenRef call to ...

Thank you. I will try it.

DSguru2B wrote:I believe the following should work. Test it out before you stick to it.

Code: Select all

sed '/**DISCLOSURE**/;/^*$/d'

Thank you. Another question I have is how would I delete all the lines below the Disclosure text.

DSguru2B wrote:In the sequential file stage, activate filter command and put the following in the filter command box

Code: Select all

sed '$d'

This will delete the last line before the stage even starts reading it.