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)
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.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.