November 8, 2018 at 7:19 pm
We recently had to rebuild one of our sql servers with ssis due to an issue with upgrading SSDT to 15.8.8 release.
Finally able to deploy and debug again, but now running into an odd issue with ODBC Source.
Add an ODBC Source to a data flow, click properties for the data flow task itself, and no longer does it show the SqlCommand property.
Same package that had this functionality prior to the system rebuild, no changes made, existing ODBC sources also affected.
Clicking the drop down in the expressions list, shows only normal properties (BatchSize, AutoAdjust, etc etc).
Anyone else run into this problem and found a solution short of another rebuild attempt or reinstall?
November 8, 2018 at 11:57 pm
Try to reregister ODBC or reinstall your ODBC driver. It will work.
November 9, 2018 at 7:00 am
No, that didn't unfortunately. This wasn't just ODBC source components that had the issue. The only source that I could see normal properties on in data flow task properties was ADO.net.
I ended up having to completely uninstall SSDT. Then do an install clean of the VS 2017 shell, then reinstall from standalone. It failed once, but noticed in the log that there was an issue with a restart not getting kicked off, so I restarted.
Re-tried the re-install from standalone, was successful, but nothing was showing after. Restarted again, and everything started working.
At least in this case it wasn't the ODBC driver.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply