18 Script Task in SSIS | Using script task in SSIS

[@thepriestofvaranasi]

Bhai your channel and videos are a blessing. Thanks a lot.

[@learnssis]

Thank you so much for appreciating. You are most welcome.

[@samama1975]

Great tutorial. Would be better if the package could be run more than once. This can be done by adding a bit more logic to the script. Thank you

[@learnssis]

Yes you are right, we can have may be part 2 of Script Task.

[@faheemiqbal3865]

Good explaination to start using script task, thanks

[@learnssis]

Thank you Faheem.

[@sujithkumarjack]

Excellent!!! domo..!!!

[@learnssis]

Thank you.

[@LakshmiSivaKarthikPadala-y9h]

Hi, I'm learning SSIS from your playlist, thank you so much for your effort. I have a doubt, this approach sees to be too tedious task. Why can't I create a txt file in folder and move the file using "File system task"?

[@learnssis]

yes you are right, we can also move the files from one folder to another using File System task. Also there is a change in below video, you don't need to give the full file path to the destination path variable, just give the archive folder location and it should be sufficient kzbin.info/www/bejne/f5PMlnd3ltmZa68

[@DeepamGhosh]

how to create dynamic connection string for connecting to different sql servers in Script task

[@learnssis]

Take a look at this page stackoverflow.com/questions/7531581/ssis-c-sharp-script-task-how-to-change-a-sql-connection-string-based-on-server Create a new Script Task before your SQL Query tasks. Use a script task to update the ConnectionString like this (assuming your connection name is "SQLConnection": Dts.Connections("SQLConnection").ConnectionString = "Data Source =" + System.Environment.MachineName.ToString() + ";Initial Catalog =myDataBase; Integrated Security =SSPI;"; In above connection string for data source you can provide some other value as well instead of using System.Environment.MachineName.ToString(), you can provide your sql server instance name. You can use chatgpt to validate and correct the C# code.

[@DeepamGhosh]

@@learnssis Thanks for the response. I am able to achieve this by creating a script task using the C# code inside it to dynamically built the connection string. Your videos are very simple and easy to understand, thanks!!

[@learnssis]

@@DeepamGhosh Glad you were able to do that. Thank you.

[@nivethamurugavel4972]

Very useful

[@learnssis]

Thank you Nivetha that you found the video useful.

[@anirudha_wellwisher]

Hello Sir I am getting error in Edit Script Task can you help me on this sir. I am using SSDT 2012. My Edit Task Option is not working when i click on Edit Task Button No window is opening Please me on this sir

[@learnssis]

It means that proper components to work with Script task are not installed on your machine. you would need to repair the Integration services on your machine.

[@anirudha_wellwisher]

@@learnssis From Which option I do this sir.. Can you please explain stepwise flow to repair Sir

[@learnssis]

​@@anirudha_wellwisher When you will try to install it, then there will be an option to repair it, thus you can do a repair. Or Do uninstall and reinstall kzbin.info/www/bejne/Zn_Sq3yMpLOsj5Y

[@anirudha_wellwisher]

@@learnssisAqil Sir I go through with your suggestion but it isn't worked for my system. What should be the Alternate solution ?

[@learnssis]

@@anirudha_wellwisher Do you have admin rights on the machine ? Did you uninstalled and reinstalled SSIS ? Can you try to open visual studio in admin mode by right clicking on it and run as administrator ?

[@eswaranche2262]

is this sql statement queries, which you using in the current vidieo

[@learnssis]

No, this is actually C# code.

[@kichuchinnu3303]

Hii if file exist in a path(folder) then create a new csv file . Any video for this concept sir by using script task

[@learnssis]

Sorry I did not get this one. Can you please elaborate in detail ?

[@kichuchinnu3303]

@@learnssis if csv file name exist in a folder then need to create a new file in the same folder

[@kichuchinnu3303]

Hope you undustnd sir please help me

[@learnssis]

​@@kichuchinnu3303 Okay got it. but what contents you want in the new file ? And how you want the new file to be named ? For example if Customer.CSV file exists then in second run we can create a file with the name Customer_1.CSV and second time it should create a file Customer_2.CSV and so on.

[@kichuchinnu3303]

@@learnssis yess exactly sir this what I want sir can you help me sir

[@antoniolupen6138]

i don´t know C#. Is it possible to execute the same task without modifying the script manually ?

[@learnssis]

Yes you can execute the same task without modifying the script.

[@priyankapothuraju2809]

like your playlist

[@learnssis]

Thank you.

[@kichuchinnu3303]

Hiiii how to change or update a file name in ssis package using script task

[@kichuchinnu3303]

Please rly it will be more helpful for me

[@learnssis]

@@kichuchinnu3303 There is just one line of code to rename a file in C# using Script task System.IO.File.Move("oldfilename", "newfilename");

[@kichuchinnu3303]

@@learnssis where should I add that please tell am new to this

[@learnssis]

@@kichuchinnu3303 Let me make a short video on this one.

[@kichuchinnu3303]

@@learnssis thank you so much.. hope will get the video by today itself bro please please 🙏

[@naveedzaman3533]

too good right on target.

[@learnssis]

Glad you liked the video.

[@pranavratnalikar]

Sir the target is throwing an exception of an invocation with a huge error code

[@learnssis]

Did you tried to debug the code ? Put a breakpoint and try to debug. Only after debug we can know the exact reason for error as it does not give the very accurate error message. Thanks.

[@sushmasushma5461]

GETTING ERROR"Error: Exception has been thrown by the target of an invocation." PLS HELP

[@learnssis]

Hi Sushma, it seems there is some issue with the code. You need to open the script and after placing a breakpoint in the code you should debug it, only then you can identify the issue. Thanks.

[@MrShaarkrat]

Hi! I use a script task to log task errors (with the event handlers). I lave lots of tasks (like 50). Is it possible to write one script, save it somewhere and tell the script task to execute this particuler script? So the day I have a modification in my error script, I don't have to do it 50 times

[@learnssis]

You can use the OnError event of SSIS package, this way you won't need to place the Script task for each task in your ssis package instead the script task will be executed for an error on any task inside the ssis package.

[@MrShaarkrat]

@@learnssis thank you for your answer. unfortunately it doesn't seem to work: The "send mail" task logs its errors in the same file that is sent as an attachment. This results in an error at runtime

[@asifshahzad5178]

Great effort. I m using SSIS 2019. When I click script task, the libraries it is adding not as in your task. How I can add dts.task? I cannot find it.

[@learnssis]

Hi, thanks for your comment. I don't see any dts.task library in the code. Why you need that library ?

[@saranyapratyusha6464]

sir,is it mandetory to learn c# for ssis?

[@learnssis]

A basic C# is good but not mandatory.

[@mahmoudhassanine9905]

I can't find script task component on my toolbox

[@learnssis]

Can you search for it ? You can search it by typing the name in search box.

[@jaitiwari241]

do we have to remember this code

[@learnssis]

No. Its good if you can just try to learn a little bit of C#.

[@dilipkumar-ck1nc]

Can u copy the code in the notepad

[@learnssis]

Okay, I have uploaded the code for it.

[@sdang003]

@@learnssis Where is it? thanks.

[@learnssis]

@@sdang003 drive.google.com/drive/folders/1znA8C7vLYMUTzPDg-MEYXwnkpCq4sEwG