0

I am experiencing the following errors when using the "Transfer SQL Server Objects" task in SSIS on Visual Studio 2019:

An exception occurred in SMO 
Value cannot be null. Parameter name: server  

These errors have previously been described in SSIS 2017 and could apparently be solved by changing the deployment target version to 2016 as described in these links:

https://social.msdn.microsoft.com/Forums/SECURITY/en-US/6096339d-766b-45ab-9e97-e8b49812aaf5/object-transfer-error-an-exception-occurred-in-smo-value-cannot-be-null-parameter-name-server?forum=ssdt

https://stackoverflow.com/questions/48145026/why-does-ssis-transfer-object-stage-return-smo-failure

So as directed in the linked pages, I opened the "Deployment Property Pages" window and looked in "Configuration Properties" for the "General" option, but it is not present, all that is present is "Configuration" and it does not have a "Deployment Target Version" option.

image of Deployment Property Pages

Is there any way I can change the Deployment Target Version (or any other ideas about how best to resolve this error) in SSIS 2019?

I've tried Google but can't find anything relevant!

4

Be sure to go to the Project properties, not the solution properties. See image below.

enter image description here

  • Thanks! I was able to find it in the end but wasn't sure what I had done differently, this must have been why! – Mel May 8 at 15:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.