 SSIS transformation error -
04-14-2008
, 04:51 PM
I am having problems in transformation task. I am retrieving oracle data and
loading into sql server table. Oracle retrieval works fine, at the time of
loading its giving some problem. It is pretty straight forward load to sql
server. When I switched on the logging, here is what I got.
Please let me know what the error is here...
#Fields:
event,computer,operator,source,sourceid,executioni d,starttime,endtime,datacode,databytes,message
5:17:48 PM,4/14/2008 5:17:48 PM,0,0x,Rows in buffer type 0 would cause a
buffer size greater than the configured maximum. There will be only 820 rows
in buffers of this type.
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008
5:17:48 PM,4/14/2008 5:17:48 PM,0,0x,Rows in buffer type 3 would cause a
buffer size greater than the configured maximum. There will be only 834 rows
in buffers of this type.
OnPostValidate,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008 5:17:48 PM,4/14/2008 5:17:48 PM,0,0x,(null)
OnPreValidate,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:51 PM,4/14/2008 5:17:51 PM,0,0x,(null)
OnInformation,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:51 PM,4/14/2008 5:17:51 PM,1074016266,0x,Validation phase is beginning.
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:51 PM,4/14/2008 5:17:51 PM,0,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:51 PM,4/14/2008 5:17:51 PM,33,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:51 PM,4/14/2008 5:17:51 PM,66,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:52 PM,4/14/2008 5:17:52 PM,100,0x,Validating
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,Rows in buffer type 0 would cause a
buffer size greater than the configured maximum. There will be only 820 rows
in buffers of this type.
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,Rows in buffer type 3 would cause a
buffer size greater than the configured maximum. There will be only 834 rows
in buffers of this type.
OnPostValidate,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,(null)
PackageStart,AVPS-RELT-SQL1,AVPS-AD\sqlacct,gfars_load,{37E23607-EE1E-4F86-B330-22984240EED7},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,Beginning of package execution.
OnPreExecute,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,(null)
OnPreValidate,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,(null)
OnInformation,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:52 PM,4/14/2008 5:17:52 PM,1074016266,0x,Validation phase is beginning.
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:52 PM,4/14/2008 5:17:52 PM,33,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:52 PM,4/14/2008 5:17:52 PM,66,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:52 PM,4/14/2008 5:17:52 PM,100,0x,Validating
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,Rows in buffer type 0 would cause a
buffer size greater than the configured maximum. There will be only 820 rows
in buffers of this type.
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,Rows in buffer type 3 would cause a
buffer size greater than the configured maximum. There will be only 834 rows
in buffers of this type.
OnPostValidate,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,(null)
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,Rows in buffer type 0 would cause a
buffer size greater than the configured maximum. There will be only 820 rows
in buffers of this type.
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,Rows in buffer type 3 would cause a
buffer size greater than the configured maximum. There will be only 834 rows
in buffers of this type.
User:PipelineExecutionTrees,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:52 PM,4/14/2008 5:17:52 PM,0,0x,begin execution tree 0
output "OLE DB Source Output" (11)
input "Data Conversion Input" (449)
output "Data Conversion Output" (450)
input "OLE DB Destination Input" (101)
output "OLE DB Destination Error Output" (102)
output "Data Conversion Error Output" (451)
end execution tree 0
begin execution tree 1
output "OLE DB Source Error Output" (12)
end execution tree 1
User:PipelineExecutionPlan,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:53 PM,4/14/2008 5:17:53 PM,0,0x,SourceThread0
Drives: 1
Influences: 88 448
Output Work List
CreatePrimeBuffer of type 1 for output ID 11.
SetBufferListener: "WorkThread0" for input ID 449
CreatePrimeBuffer of type 4 for output ID 12.
CallPrimeOutput on component "OLE DB Source" (1)
End Output Work List
End SourceThread0
WorkThread0
Drives: 448
Influences: 88 448
Input Work list, input ID 449 (1 EORs Expected)
CallProcessInput on input ID 449 on component "Data Conversion" (448)
for view type 3
ActivateVirtualBuffer index 1
CallProcessInput on input ID 101 on component "OLE DB Destination"
(88) for view type 2
End Input Work list for input 449
Output Work List
End Output Work List
End WorkThread0
OnInformation,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:53 PM,4/14/2008 5:17:53 PM,1074016262,0x,Prepare for Execute phase is
beginning.
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:53 PM,4/14/2008 5:17:53 PM,0,0x,Prepare for Execute
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:53 PM,4/14/2008 5:17:53 PM,33,0x,Prepare for Execute
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:53 PM,4/14/2008 5:17:53 PM,66,0x,Prepare for Execute
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:53 PM,4/14/2008 5:17:53 PM,100,0x,Prepare for Execute
User:PipelineInitialization,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:53 PM,4/14/2008 5:17:53 PM,0,0x,No temporary BLOB data storage locations
were provided. The buffer manager will consider the directories in the TEMP
and TMP environment variables.
User:PipelineInitialization,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:53 PM,4/14/2008 5:17:53 PM,0,0x,No temporary buffer storage locations
were provided. The buffer manager will consider the directories in the TEMP
and TMP environment variables.
OnInformation,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:53 PM,4/14/2008 5:17:53 PM,1074016263,0x,Pre-Execute phase is beginning.
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:53 PM,4/14/2008 5:17:53 PM,0,0x,Pre-Execute
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:53 PM,4/14/2008 5:17:53 PM,33,0x,Pre-Execute
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:53 PM,4/14/2008 5:17:53 PM,66,0x,Pre-Execute
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008 5:17:53 PM,4/14/2008 5:17:53 PM,100,0x,Pre-Execute
User:PipelineInitialization,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:53 PM,4/14/2008 5:17:53 PM,0,0x,The default buffer size is 10485760
bytes.
User:PipelineInitialization,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:53 PM,4/14/2008 5:17:53 PM,0,0x,Buffers will have 10000 rows by default.
User:PipelineInitialization,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:53 PM,4/14/2008 5:17:53 PM,0,0x,The data flow will not remove unused
components because its RunInOptimizedMode property is set to false.
OnInformation,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:53 PM,4/14/2008 5:17:53 PM,1074016268,0x,Execute phase is beginning.
OnPipelinePrePrimeOutput,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:17:53 PM,4/14/2008 5:17:53 PM,0,0x,PrimeOutput will be called on a
component. : 1 : OLE DB Source
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:32 PM,4/14/2008 5:18:32 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:32 PM,4/14/2008 5:18:32 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:34 PM,4/14/2008 5:18:34 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:34 PM,4/14/2008 5:18:34 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:36 PM,4/14/2008 5:18:36 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:36 PM,4/14/2008 5:18:36 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:39 PM,4/14/2008 5:18:39 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:39 PM,4/14/2008 5:18:39 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:40 PM,4/14/2008 5:18:40 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:40 PM,4/14/2008 5:18:40 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:45 PM,4/14/2008 5:18:45 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:45 PM,4/14/2008 5:18:45 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:47 PM,4/14/2008 5:18:47 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:47 PM,4/14/2008 5:18:47 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:50 PM,4/14/2008 5:18:50 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:50 PM,4/14/2008 5:18:50 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:52 PM,4/14/2008 5:18:52 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:52 PM,4/14/2008 5:18:52 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:54 PM,4/14/2008 5:18:54 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:54 PM,4/14/2008 5:18:54 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:56 PM,4/14/2008 5:18:56 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:56 PM,4/14/2008 5:18:56 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:57 PM,4/14/2008 5:18:57 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:57 PM,4/14/2008 5:18:57 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:59 PM,4/14/2008 5:18:59 PM,0,0x,Rows were provided to a data flow
component as input. : : 1606 : OLE DB Source Output : 448 : Data Conversion
: 449 : Data Conversion Input : 820
OnPipelineRowsSent,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:59 PM,4/14/2008 5:18:59 PM,0,0x,Rows were provided to a data flow
component as input. : : 455 : Data Conversion Output : 88 : OLE DB
Destination : 101 : OLE DB Destination Input : 820
OnError,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:18:59 PM,4/14/2008 5:18:59 PM,-1073450780,0x,The pipeline received a
request to cancel and is shutting down.
OnError,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:19:00 PM,4/14/2008 5:19:00 PM,-1071636284,0x,The attempt to add a row to
the Data Flow task buffer failed with error code 0xC0047020.
OnError,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:19:00 PM,4/14/2008 5:19:00 PM,-1073450952,0x,SSIS Error Code
DTS_E_PRIMEOUTPUTFAILED. The PrimeOutput method on component "OLE DB Source"
(1) returned error code 0xC02020C4. The component returned a failure code
when the pipeline engine called PrimeOutput(). The meaning of the failure
code is defined by the component, but the error is fatal and the pipeline
stopped executing. There may be error messages posted before this with more
information about the failure.
OnPipelinePostPrimeOutput,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:19:00 PM,4/14/2008 5:19:00 PM,0,0x,A component has returned from its
PrimeOutput call. : 1 : OLE DB Source
OnPipelinePostPrimeOutput,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:19:00 PM,4/14/2008 5:19:00 PM,0,0x,A component has returned from its
PrimeOutput call. : 1 : OLE DB Source
OnError,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40F0AE2A-6C26-49E6-BFE0-56E3F69AFBC4},4/14/2008
5:19:00 PM,4/14/2008 5:19:00 PM,-1073450975,0x,SSIS Error Code
DTS_E_THREADFAILED. Thread "SourceThread0" has exited with error code
0xC0047038. There may be error messages posted before this with more
information on why the thread has exited.
OnPreValidate,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008 5:19:49 PM,4/14/2008 5:19:49 PM,0,0x,(null)
OnInformation,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008
5:19:49 PM,4/14/2008 5:19:49 PM,1074016266,0x,Validation phase is beginning.
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008 5:19:49 PM,4/14/2008 5:19:49 PM,0,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008 5:19:49 PM,4/14/2008 5:19:49 PM,33,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008 5:19:49 PM,4/14/2008 5:19:49 PM,66,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008 5:19:49 PM,4/14/2008 5:19:49 PM,100,0x,Validating
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008
5:19:49 PM,4/14/2008 5:19:49 PM,0,0x,Rows in buffer type 0 would cause a
buffer size greater than the configured maximum. There will be only 820 rows
in buffers of this type.
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008
5:19:49 PM,4/14/2008 5:19:49 PM,0,0x,Rows in buffer type 3 would cause a
buffer size greater than the configured maximum. There will be only 834 rows
in buffers of this type.
OnPostValidate,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{CD92E90F-E819-4240-AEC5-29BA1D28564D},4/14/2008 5:19:49 PM,4/14/2008 5:19:49 PM,0,0x,(null)
OnPreValidate,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008 5:19:54 PM,4/14/2008 5:19:54 PM,0,0x,(null)
OnInformation,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008
5:19:54 PM,4/14/2008 5:19:54 PM,1074016266,0x,Validation phase is beginning.
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008 5:19:54 PM,4/14/2008 5:19:54 PM,0,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008 5:19:54 PM,4/14/2008 5:19:54 PM,33,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008 5:19:55 PM,4/14/2008 5:19:55 PM,66,0x,Validating
OnProgress,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008 5:19:55 PM,4/14/2008 5:19:55 PM,100,0x,Validating
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008
5:19:55 PM,4/14/2008 5:19:55 PM,0,0x,Rows in buffer type 0 would cause a
buffer size greater than the configured maximum. There will be only 820 rows
in buffers of this type.
User:BufferSizeTuning,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008
5:19:55 PM,4/14/2008 5:19:55 PM,0,0x,Rows in buffer type 3 would cause a
buffer size greater than the configured maximum. There will be only 834 rows
in buffers of this type.
OnPostValidate,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008 5:19:55 PM,4/14/2008 5:19:55 PM,0,0x,(null)
PackageStart,AVPS-RELT-SQL1,AVPS-AD\sqlacct,gfars_load,{37E23607-EE1E-4F86-B330-22984240EED7},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008
5:19:55 PM,4/14/2008 5:19:55 PM,0,0x,Beginning of package execution.
OnPreExecute,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008 5:19:56 PM,4/14/2008 5:19:56 PM,0,0x,(null)
OnPreValidate,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008 5:19:56 PM,4/14/2008 5:19:56 PM,0,0x,(null)
OnInformation,AVPS-RELT-SQL1,AVPS-AD\sqlacct,Get the data from
Oracle,{0FC66CC7-834C-47AA-9211-0617A1140CB3},{40DAC15C-2A75-4111-B99B-BE29CCEEE36D},4/14/2008
5:19:56 PM,4/14/2008 5:19:56 PM,1074016266,0x,Validation phase is beginning.
 |
Linear Mode
