November 9, 2012 at 1:29 pm
I have a very simple SSIS package. It has a data flow task which has an ADO.NET source and a flat file destination. I can preview the data in in the source task just fine. When I run it, the ouitput looks like this:
SSIS package "Package.dtsx" starting.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, SSIS.Pipeline: Validation phase is beginning.
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.
Information: 0x402090DC at Data Flow Task, Flat File Destination [133]: The processing of file "C:\BNK_TEST123.txt" has started.
Information: 0x4004300C at Data Flow Task, SSIS.Pipeline: Execute phase is beginning.
SSIS package "Package.dtsx" finished: Canceled.
The souce task is yellow but the destination stays white. I put in a data viewer but it never pops up. Any clue what I'm doing wrong?
November 9, 2012 at 2:04 pm
My initial guess is that it sounds like you're not getting the entire error from the ADO source. Try connecting to it via a script externally with the same settings and see if you can get the error stack.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply