May 12, 2015 at 1:08 am
Hi I am trying to insert in table using execute sql task.
I want to pass value of Load_Frequency through parameter
but I ma getting error
[Execute SQL Task] Error: Executing the query "Insert Into [dbo].[ETL_LOAD_MAIN] (
[Load_Fr..." failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Insert Into [dbo].[ETL_LOAD_MAIN] (
[Load_Frequency]
,[Load_Start_DateTime]
,[Load_Overall_Status]
) Values (?,getdate(),'In Progress')
Regards,
Vipin Jha
May 12, 2015 at 1:30 am
Can you confirm that you have resultset set to none and include a screen shot of your parameter mapping screen?
May 12, 2015 at 2:49 am
Hi ,
It was a problem with the length of column.
i increased the length of column and now running fine.
regards,
Vipin jha
May 12, 2015 at 2:58 am
vipin_jha123 (5/12/2015)
Hi ,It was a problem with the length of column.
i increased the length of column and now running fine.
regards,
Vipin jha
I'm amazed you worked that out, based on the error message!
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply