CODEWITHSUNDEEP
etlinformatica-powercenterinformatica
chopland
chopland

Reputation: 71

Using mapping parameter in an Informatica stored procedure call

I am using a stored procedure as a source in my Informatica mapping, and I have defined the SQL query in the source qualifier as 

exec dbo.GET_ATTRIBUTES($$fromDate, $$toDate)

where $$fromDate and $$toDate are mapping parameters I have defined in a parameter file. I have tried a number of different ways of going about this and none seem to work, as the SQL query fails to validate.

So, my question boils down to this, is there a way to call a stored procedure while passing in two mapping parameters?

Thanks in advance

Upvotes: 1

Views: 5249

Answers (2)

Ele
Ele

Reputation: 11

I have had exact opposite problem.

When executing t-sql stored procedure from mapping, that accepts time in hh:mi:ss, using parameter that is set with IsExprVar to FALSE, have been failing with error "[Informatica][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Conversion failed when converting date and/or time from character string.]"

After changing the same parameter to IsExprVar to TRUE, executing t-sql stored procedure from mapping finished successfully.

Upvotes: 0

chopland
chopland

Reputation: 71

I actually figured out what my issue was. It turns out that when I defined the mapping parameters I had set the IsExprVar field to TRUE. When I set it to FALSE I was able to pass the parameters to the stored procedure when calling it in the SQL query field of the source qualifier.

Upvotes: 4

Related Questions