March 14, 2012 at 5:35 pm
Hello All,
During some testing I hacked up an import file to cause my package to fail. It only gave me a waring and reported package level success. How can I fail the package in a scenario like this?
Thanks....
SSIS package "Mypackage(1).dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Data Flow Task, Source - Myfile_20120306_TXT 1 [2160]: The processing of file "\\Myserver\MypathMyfile_20120306.TXT" has started.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Warning: 0x8020200F at Data Flow Task, Source - Myfile_20120306_TXT 1 [2160]: There is a partial row at the end of the file.
Information: 0x402090DE at Data Flow Task, Source - Myfile_20120306_TXT 1 [2160]: The total number of data rows processed for file "\\Myserver\MypathMyfile_20120306.TXT" is 1.
Information: 0x402090DF at Data Flow Task, Destination - Myfile_staging 1 [2091]: The final commit for the data insertion has started.
Information: 0x402090E0 at Data Flow Task, Destination - Myfile_staging 1 [2091]: The final commit for the data insertion has ended.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Source - Myfile_20120306_TXT 1 [2160]: The processing of file "\\Myserver\MypathMyfile_20120306.TXT" has ended.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination - Myfile_staging 1" (2091)" wrote 0 rows.
SSIS package "Mypackage(1).dtsx" finished: Success.
March 15, 2012 at 2:14 am
What did you do exactly with the file?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 10:41 am
I left the header row alone. I deleted half of the first data row and all the other data rows.
March 15, 2012 at 2:06 pm
Strange indeed.
What if a full row comes after the half row?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 3:07 pm
The package will then fail.
Description: Data conversion failed. The data conversion for column "Report_Period" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
Report_Period is the last column.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply