SSIS 2008 Simple csv file to uplod into a database table -
morning all,
i new ssis have simple task complete , small problem.
i have data flow task has flat file source connected ole de destination object. csv file holds header matches columns in database table.
i has problems 3 fields in destination object these needed converted datatype [dt_str] [dt_wstr].
my dataflow objects not produce erros in form of red cross when run package following message immediate/output window ...
task failed: employee load warning: 0x80019002 @ package: ssis warning code dts_w_maximumerrorcountreached. execution method succeeded, number of errors raised (4) reached maximum allowed (1); resulting in failure. occurs when number of errors reaches number specified in maximumerrorcount. change maximumerrorcount or fix errors. ssis package "package.dtsx" finished: failure.
in properties pant of dft have increased maximunerrorcount 100 still producing error. have 1 row of data in csv test package im confused why doesnt work?
any appriechiated.
regards b
as still issue have found alternative method complete task.
Comments
Post a Comment