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
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.
- Craig Farrell
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 | Forum Netiquette
For index/tuning help, follow these directions. |Tally TablesTwitter: @AnyWayDBA