Hi everybody, I have a Execute SQL Task with UPDATE with the follow script:
UPDATE [DBO].[IN_FILEFD_MICRO] SET FEC_FAC=A.[Column 16]
from [dbo].[TEMP_MICRONARG] A,[DBO].[IN_FILEFD_MICRO] B
where A.[Column 0]='0006000000' AND RIGHT(A.[Column 12],7)=B.NUM_CTA AND B.FEC_REP=?
UPDATE [DBO].[IN_FILEFD_MICRO] SET SAL_ACTUAL_SOL2=A.[Column 21]
from [dbo].[TEMP_MICRONARG] A,[DBO].[IN_FILEFD_MICRO] B
where A.[Column 0]='0027000000' AND RIGHT(A.[Column 12],7)=B.NUM_CTA and A.[Column 21]<>'' AND B.FEC_REP=?
Parameter Mapping:
- Fec_Arch
- Direction: Input
- Data Type: VARCHAR
- Parameter Name: 0
The same parameter is duplicated but with the parameter name 1.
When I execute the package show the follow error:
[Execute SQL Task] Error: Executing the query " UPDATE [DBO].[IN_FILEFD_MICRO] SET FEC_FAC=A.[Column 16] from [dbo].[TEMP_MICRONARG] A,[DBO].[IN_FILEFD_MICRO] B where A.[Column 0]='0006000000' AND RIGHT(A.[Column 12],7)=B.NUM_CTA AND B.FEC_REP=? " failed with the following error: "Error no especificado (Exception from HRESULT: 0x80004005 (E_FAIL))". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Is right the assign of value from variable 'Fec_Arch' to UPDATE in the sript or I have to use other way?
Thanks by your help!