It got me again, during development I used a mapped drive throughout my project and everything works perfectly. To see those green boxes fill your screen relaxes you like nothing else. I mean, not really but it feels good like nothing else. Ok, not true, but back to the point...
Deployed the package, run it through a SQL Agent job and kaboooom. Error. Spit out the gum, straighten the back, pull the chair into the desk a little more...
After hours of agony I remembered that you should never use mapped drives with SSIS/SQL jobs, and pretty much anything else.
After using UNC paths to network shares everything is back to green.
Take away: D O N O T U S E M A P P E D D R I V E S I N S S I S. They don't mix well, just like oil and water...
1 comment:
I just feel that there is always a need to provide some very good information and find out about solutions to some very complex database problems.
Qlik Soap API Connection
Post a Comment