I need to pass a variable {select convert(varchar(8), getdate(), 1) } to AS400 Query, where a column gets updated with the current date.
My AS400 connection type : ADO.NET
Currentdate variable Datatype : int32
Parameter mappings : Currentdatevariable i/p int32(datatype) 0 -1
When I do this way, its not updating column. Tried in changing Datatype of CurrentDate Variable but all I can see is Datetime. And when I want to pass this Variable to AS400 Query, I am not sure of the datatype in the parameter mappings of Execute SQL task, because their are DBDate, Date. I tried with this all Datatypes in the Parameter mapping, but the query fails.
Please help, if am I doing wrong. And Please suggest me Documentation for ADO.NET parameter Passing.
Let me know, If not clear above ......Thank you GUys