Category: SSIS
-
SSIS Specified initialization vector (IV) does not match the block size for this algorithm or Change Password Protection Level.
SSIS deploying can be quite a hassle a weird message that I encountered recently was the popup above. It does not say anything. The solution for this issue is changing the target Sqlserver version in your project configuration to the Sqlserver version destination. If you then still have a problem deploying, then make sure that…
-
SSIS Oledb connection component fails with no apparent reason error code 0xC0209029.
error code 0xC020907B Once a while you encounter mysteries that suddenly appear without any known reason. A customer has a once a year scheduled SSIS package running in the Sqlserver manager. Executing the job after a full year results in an error. Examining the dataflow we conclude the error happens pushing its data to the…
-
Session Validation for the alter operation failed , The value specified for the event attribute or predicate source duration is invalid.
Check my other post about creating an extended event in Sqlserver Management studio Using Extended events to find Long-running queries and