144 How to handle errors in script task in ssis

[@fevenzerai2911]

such a wonderful explanation, But I have a question is the code that u provide to us will work for every script??

[@learnssis]

Thank you, yes it will work for every script.

[@fevenzerai2911]

@@learnssis Thank you 😊 !!

[@fevenzerai2911]

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

[@learnssis]

@@fevenzerai2911Glad to know that it worked for you.

[@tejaswinerella5223]

Hi Aqil For me, if the ID value is 0 then I get a runtime error it's not stored in the log file Runtime Error: at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor) at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams) at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()

[@DhanyaGowda-l9m]

Hi Akil, Actually I am working for ssis project I am using vs 2019 ..whenever I change any package and save run locally the package runs fine but when I deploy the package in other server or If I share it someone the script task readonly variables and write only variables gets blank.. what is the solution for this?

[@learnssis]

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.

[@DhanyaGowda-l9m]

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

[@learnssis]

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

[@koushaljha4507]

Very useful

[@learnssis]

Thank you Sir.

[@sathiyamoorthi9224]

Hi Aqil thanks for the video.where can get code? Can you please let me know

[@learnssis]

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.

[@sathiyamoorthi9224]

@@learnssis Thank you!

[@darbardarbar9460]

What happened I am not coming your notification

[@learnssis]

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

[@fevenzerai2911]

I will really apricate if u give me an Idea!!! Thank you!!!

[@learner_SSIS]

Great sir 😀

[@learnssis]

Thank you Naveen Raja.