Briceston (7/27/2014)
I have a SSIS package that consists of a Foreach file Enumerator and a Foreach ADO.NET Schema Rowset Enumerator. Within Foreach ADO.NET Schema Rowset Enumerator, I have DFT that has an excel source, data conversion, derived column and OLEDB destination.
I want to confirm that this is ALL it does, and there's no previous steps. Why is below...
My problem is when I run the package it turns yellow, then a black window flashes very quickly and that's it. I can't read what the black window so says because it flashes so fast. I have no error messages.
My best guess is that's a console opening up, then hiding itself. Nothing you described above should be doing that to my knowledge.
For the Foreach ADO.NET Schema Rowset Enumerator my settings are as followed:
Connection: Excel Schema
Schema: Tables
Variable Mappings: User::VarSheet Index set to 2
I've never used the Schema Rowset enumerator before, particularly against Excel, so I can't speak to this component yet. However, when you run this as a job, inside the step for the job you can turn on logging for the process; inside the step, go to Advanced, a few lines down is Output File. Stuff an output into a file somewhere and then come back with the results of it from a failure. This will help give us more details about what exactly has, is, and attempted to occur in your package.
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