July 24, 2009 at 10:33 am
my sql job run the package every night, but last night I got this error Code: 0xC002F210
July 24, 2009 at 11:03 am
your description is a little vague...but this post maybe of use:
http://www.sqlservercentral.com/Forums/Topic575769-148-1.aspx
Gethyn Elliswww.gethynellis.com
July 24, 2009 at 12:44 pm
Hi thanks for the replay, but I can not open this page, I will explain you again
I have a SQL job to run every night, this job run the SSIS package and this package get the data from .txt file and load into the stage table and then load into the producation tables, but last night I got following error
Executed as user: \svcSQLadm. ...sion 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:05:47 AM Error: 2009-07-24 10:05:50.38 Code: 0xC002F210 Source: Insert Execute SQL Task Description: Executing the query "insert INTO dbo.cnsmr_accnt_ar_log (actn_cd, cnsmr_accnt_id, evnt_cst_id, cnsmr_id, rslt_cd, wrkchn_id, wrkgrp_id, cnsmr_accnt_ar_log_crt_usr_id, cnsmr_accnt_ar_mssg_txt, upsrt_dttm, upsrt_soft_comp_id, upsrt_trnsctn_nmbr, upsrt_usr_id ) select '184' as actn_CD, cnsmr_accnt.cnsmr_accnt_id, NuLL as evnt_cst_id, cnsmr.cnsmr_id, rslt_cd, Null as wrkchn_id, cnsmr.wrkgrp_id, 3 as cnsmr_accnt_ar_log_crt_usr_id, Dialer_notes + ' ' + LV.phone as [Notes], rtrim(dialer_date) + ' ' + ltrim(Finish_time) as [time_of_result], 0 as upsrt_soft_co... The package execution fa... The step failed.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply