I have been testing CozyRoc locally (Visual Studio) for a couple of weeks now, and am very impressed with the components/tasks that I have used. Today, I wanted to start the 30-day server trial license, so that I could make sure that everything would work as expected in our typical production environment (our Data team, at least for now, will simply run our "data imports" directly from SQL Agent in SSMS. However, for some reason, my Excel loader step is failing with an "object not found" error when trying to load the specified sheet:
"Import Data Sheet" is the correct sheet name, and this works fine if I run the package locally using Visual Studio. In our existing import packages, I use the "stock" Excel source, and have never run into this (or similar) issue. Is there something about the CozyRoc "Excel Source Plus" where I need to do something differently?
Thanks in advance!