Ssis-171

| ✅ Check | How to Verify | What to Do If It Fails | |----------|---------------|------------------------| | | Open the package in SSDT/BIDS → Right‑click the component → Properties → Version . Compare with the version of the DLL in C:\Program Files\Microsoft SQL Server\<major>\DTS\Binn . | Re‑compile the component against the current SSIS SDK (SQL Server Data Tools) or install the matching SSIS Feature Pack for the server version. | | Bitness matches execution mode | In the Project → Properties → Debugging → Run64BitRuntime (True/False). Also check the Agent job step “Use 32‑bit runtime”. | Switch the runtime flag to match the component, or replace the component with a 64‑bit version (most third‑party vendors ship both). | | DLL present & registered | Browse the Binn folder or run gacutil -l | find "MyComponent" in a Developer Command Prompt. | Copy the DLL to the Binn folder and run gacutil /i MyComponent.dll (or use the MSI installer from the vendor). | | TargetServerVersion is correct | In SSDT → Project → Properties → TargetServerVersion (SQL Server 2012/2014/2016/2017/2019/2022). | Change the property to the version of the server you will execute on, then re‑save the package. | | Custom component is signed (required on newer platforms) | Open the component DLL in ILSpy or dotPeek → check for a strong name. | Re‑sign the component with a strong name key, or ask the vendor for a signed build. |