Microsoft SQL Server 2008
--
Questions
--
Followers
Top Experts
Need help with my first SSIS package
just getting started with SSIS. I had this basic package working a couple of weeks ago, but then my machine blew up, and upon getting a new machine can't get the simple package to work (I had to recreate from scratch).
The package
- reads from an Oracle d.b.
- writes to a flat file
everything seems to be in order, as I recall from a couple of weeks ago, but I get two errors and can't tell what is the error . . .
The simple query parses ok and shows me the data I expect in the designer.
Here's a picture of the package:
When I execute I get two errors, but I can't see what they are . . . (the two warnings are just that the oracle column info can't be read, I believe)
The package
- reads from an Oracle d.b.
- writes to a flat file
everything seems to be in order, as I recall from a couple of weeks ago, but I get two errors and can't tell what is the error . . .
The simple query parses ok and shows me the data I expect in the designer.
Here's a picture of the package:
When I execute I get two errors, but I can't see what they are . . . (the two warnings are just that the oracle column info can't be read, I believe)
Zero AI Policy
We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Ok, I'll look for that but wouldn't it jump out and be easily seen ? I'll try and get something shortly.
That depends on how you configured your Visual Studio. The window manager could sometimes be a nightmare.
Here's the output, the errors being
Error: 0xC0202095 at Data Flow Task, Flat File Destination [168]: Failed to write out column name for column "SUBJ_AREA_CD".
Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: component "Flat File Destination" (168) failed the pre-execute phase and returned error code 0xC0202095.
But my query works . . . and  SUBJ_AREA_CD is good . . .
Error: 0xC0202095 at Data Flow Task, Flat File Destination [168]: Failed to write out column name for column "SUBJ_AREA_CD".
Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: component "Flat File Destination" (168) failed the pre-execute phase and returned error code 0xC0202095.
But my query works . . . and  SUBJ_AREA_CD is good . . .
SSIS package "JHU member-terms.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Warning: 0x80202066 at Data Flow Task, OLE DB Source [16]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Warning: 0x80202066 at Data Flow Task, OLE DB Source [16]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
Information: 0x40043006 at Data Flow Task, SSIS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, SSIS.Pipeline: Pre-Execute phase is beginning.
Warning: 0x80202066 at Data Flow Task, OLE DB Source [16]: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.
Information: 0x402090DC at Data Flow Task, Flat File Destination [168]: The processing of file "H:\SSIS Projects\JHU member\JHU member results.txt" has started.
Error: 0xC0202095 at Data Flow Task, Flat File Destination [168]: Failed to write out column name for column "SUBJ_AREA_CD".
Error: 0xC004701A at Data Flow Task, SSIS.Pipeline: component "Flat File Destination" (168) failed the pre-execute phase and returned error code 0xC0202095.
Information: 0x40043008 at Data Flow Task, SSIS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Flat File Destination [168]: The processing of file "H:\SSIS Projects\JHU member\JHU member results.txt" has ended.
Information: 0x4004300B at Data Flow Task, SSIS.Pipeline: "component "Flat File Destination" (168)" wrote 0 rows.
Information: 0x40043009 at Data Flow Task, SSIS.Pipeline: Cleanup phase is beginning.
Task failed: Data Flow Task
Warning: 0x80019002 at Package: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method succeeded, but the number of errors raised (2) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
SSIS package "JHU member-terms.dtsx" finished: Failure.
The program '[8760] JHU member-terms.dtsx: DTS' has exited with code 0 (0x0).
EARN REWARDS FOR ASKING, ANSWERING, AND MORE.
Earn free swag for participating on the platform.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
I isolated better what issue I was having and posted this at the above link.
Microsoft SQL Server 2008
--
Questions
--
Followers
Top Experts
Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the Always On technologies and support for unstructured data types.