19 Debugging Script Task in SSIS

[@catierobin346]

Thank you so very much for this tutorial! I am currently learning SSIS and was attempting to do something similar but could not get it to work correctly. Watching this video has helped me figure out where my issue was and correct the package. I look forward to learning from your other tutorials

[@learnssis]

Glad to know Catie that it helped you.

[@cifufull]

Thanks Friend¡¡ great scenario to apply

[@learnssis]

Thank you Andres.

[@rams_here]

Thank you once again🤗. I request you to create new channels for Python, AI/ML/GenAI in same format as Learn SSIS...

[@learnssis]

That's so nice of you, but I don't have experience working with Python, AI/ML/GenAI.

[@anandreddy9591]

Excellent video sir, Sir I have one scenario package running fine in production but when I check the same package fails saying binary code of the script component failed .

[@learnssis]

There can be multiple reasons for this. 1. Check the target sql server version of the ssis package, if it is not correct then correct it and save and close the package. 2. If you are using any DLL in the script component then make sure that DLL are registered to gac using developer command prompt window using admin rights. 3. Open the script component and try to rebuild it and see if rebuild completes successfully or not.

[@sriniwaaskorampalli8145]

hi sri, the same thing can be achieved using foreach loop? if i need to perform same task without using srcipt componet then?

[@learnssis]

Yeah same thing can be done using foreach loop container, you can get the file name from there and if you want to check the total record counts in a flat file and do not want to use the script task, then you can use a data flow task, use a flat file source, now use a row count transformation and then instead of an oledb destination, just use a derived column transformation, this way data flow task will read all data from source but won't insert it to anywhere and total record count will be inserted to an SSIS variable inside the rowcount transformation and then in the end you can insert that value to a sql server table like how I did in the end.

[@sriniwaaskorampalli8145]

@@learnssis hi sir, do we have jobs offers on ssis if we don't know c# or .net also ?

[@learnssis]

@@sriniwaaskorampalli8145 A little bit of C# knowledge is good but not necessary to get a job in SSIS.

[@gfenno]

Could you also have used, parameter mapping in the sql task to achieve the same result? Instead of expressions?

[@learnssis]

Yes I have used that too. You can check that in my video "Execute SQL Task in SSIS". kzbin.info/www/bejne/bHKsfmauoLRjfpo If you go to 5:20 MM:SS then you will see how I have used that.

[@kitykaklyne7730]

Excellent !

[@learnssis]

Thank you.

[@ExonaQ]

i didn't understand why you used the "using" statement to read the file.

[@learnssis]

To read the file there is a class in C# which is called as System.IO this class has methods to deals with files on the file system. And to access a pre created class like System.IO we need to write a statement like below using System.IO

[@ShivamSharma-wt7nu]

can we fetch 5 excel sheets present in a folder directly from one drive to ssis

[@learnssis]

Sorry I never tried that.

[@ShwetaJadhav-e9f]

In Coustomer,txt there are only 6 records, one row is header row, then why it is counting 7 records?

[@learnssis]

it is including the header row as well because that is a line as well in the Customer.txt file. the code is just checking how many lines are available in the file. If you have header information in the file, then in the end you can subtract -1 from the total record count.

[@belaytechbtc5219]

I want to do something for a SharePoint destination from Ole db, can you help me with some ideas

[@learnssis]

There is no inbuilt components in SSIS to write to a sharepoint destination, you would need to write code in C# and place it inside script task.

[@mahmoudhassanine9905]

could you please make a vedio calling api using script task inside for each

[@learnssis]

As of now I don't have an api to test, I will try to find a public api if possible and will make a video on that.

[@venkatasureshkakumani8285]

Good

[@learnssis]

Thank you.

[@kamleshsinghG]

Thanks for sharing the video... can you please make the same example with multiple files?

[@learnssis]

OK, will try to do it in future.

[@priyanshidangi6968]

TITLE: Expression Builder ------------------------------ Cannot convert expression value to property type. Cannot convert 'System.String' to 'System.Int32'. Getting this error

[@learnssis]

Typecast the value to Int32. You can do this by typecasting the existing value like below Convert.ToInt32(Dts.Variables["myvariable"].Value)

[@priyanshidangi6968]

@@learnssis "INSERT INTO FILEINFO VALUES('"+ @[User::FilePath] +"','"+ @[User::FileName] +"',"+ (DT_WSTR,12)@[User::RecordCount] +", getdate( )" How can we ftypecast this to fix the error. I

[@priyanshidangi6968]

Sir Please Help How to resolve this error ..... I m Getting the same error everytime i m using Expreesions

[@learnssis]

@@priyanshidangi6968 Email below things to me 1. the expression 2. screenshot of ssis variables 3. screenshot of table FILEINFO columns with their data type You can email at [e-mail]

[@krishnachaitanyareddy2781]

voice low

[@learnssis]

You are right, some of my older videos voice is low, I am trying to upload new videos in proper voice.

[@gauntrealities4655]

I don't understand almost everything this dude says. Horrible accent ((

[@learnssis]

Sorry man, if you can't understand it.

[@amanahmed6057]

[@learner_SSIS]

Nice 👍

[@learnssis]

You are most welcome Naveen Raja.