whereisSQL? (8/20/2013)
I am stuck at a similar dilemma with Excel source and Jet provider.Cannot edit registry key.
I was thinking about this.. but I am not sure if it is possible.. Can I add a dummy row with more than 255 chars each time data flow task runs by using a script task and then take the dummy row out using an identifier?
Script Task (add dummy row, move all rows one level below dummy)
Excel Source
Some other Task (which you would normally go to and take dummy row out)
I have near zero scripting skills and am looking for help to see if this is a possibility
If you can't use a CSV as your source instead - which is my preferred approach whenever the subject of Excel comes up - then yes, you can do this. Use a Conditional Split in your dataflow to send the unwanted row to an unused output.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.