144 How to handle errors in script task in ssis 

Thank you Sir.

Hi Dhanya, it seems very strange. When you are deploying it to other server, then make sure before deploying it, set the correct sql server version (like sql server 2019 etc) in the project properties. If you right click on the project, go to properties, and then select configuration properties and select General, there you will see the Target server version. Make sure that version is correct as per your sql server version on which you are going to deploy it. If you are sharing the solution with another team member then make sure they are opening the solution in the same visual studio version on which you have created it. From Visual Studio, you can go to Help and click on About Microsoft Visual Studio and check the version number there, it will be something like this Microsoft Visual Studio Community 2019 Version 16.11.29 Make sure, same version is on their machine as well. You can try these things.

Thank you so much ..Actually me and my team member is using different versions

@@user-gm9nd3dt7rThat might be the reason, why this issue is happening. Try to use the same version, it might solve this issue.

Thank you, yes it will work for every script.

@@learnssis Thank you 😊 !!

This works for me ....really apricate Bro keep going....@@learnssis

@@fevenzerai2911Glad to know that it worked for you.

The code should be available in the google drive, and you can get the link of the google drive from the description of the video.

@@learnssis Thank you!

Unsubscribe then Subscribe, Turn on the notifications by clicking on Bell icon.

Thank you Naveen Raja.