ssdtssisvisual studio 2017
I have downloaded and installed SSDT from Microsoft docs. The install was successful and I now have SSDT for VS 2017 installed – version 15.8.9 (as per screenshot)
However, I cannot create an SSIS project. There is no option in SSDT to do so.
When I try to open an old version of an SSIS package I get the below 'Unsupported'…
What else am I missing?
The OBJECTPROPERTY call requires a schema stability (Sch-S) lock, which is only incompatible with a schema modification (Sch-M) lock.
The BULK INSERT will take a Sch-M lock in some circumstances. These are listed in the "Table Locking and Logging During Bulk Import" section of Guidelines for Optimizing Bulk Import in Books Online:
If the destination table is clustered, you may find enabling trace flag 610 helps. Please read the whole series of those posts and the Data Loading Performance Guide and test thoroughly if you decide to go this route.
I have no idea why SSDT checks the IsEncrypted property for tables. I cannot imagine a scenario where that makes sense, but that's a question for the SSDT people.
I've uninstalled the old version of VS2017 SSDT (15.4.xx) and download the latest SSDT 2017 (15.5.x) from Microsoft then, install it. It seems to be working now. I can create a new SSIS package. Yehey!
Best Answer
Repairing the installation of SSDT resolved the issue.