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?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
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!
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply