find update script in all packages in ssis

Question

Shambhu Rai 1,411

HI Expert,

how to find update script with specific table name in list of all packages in ssis

i.e. any script with update command in all packages

3 answers

Answer 1

ZoeHui-MSFT 41,491

I don't think you could get the code without open the script task component.

So we could not get table name in list of all packages unless you open the script task and then record it which means you need to do that manually.

Regards，

Zoe Hui

If the answer is helpful, please click "Accept Answer" and upvote it.

Answer 2

Olaf Helper 47,441

Right-mouse click on the package => "View code"

You get the package as XML code, where you can search for keywords like "UPDATE".

Shambhu Rai 1,411 Reputation points

2023-06-13T06:11:33.4933333+00:00

Sir, i do not know which package update statement is writtern therefore wants search in all packages
Olaf Helper 47,441 Reputation points

2023-06-13T06:27:05.71+00:00

As I wrote, packages are nothing else then XML code.

Use a tool like Notepad++ to search in all apckage files.

Answer 3

Raksha Chourasia 75

@Shambhu Rai,
Please try using these specific steps for updating scripts:

You can go to packages:

1)Select packages and click on properties.

2)Under properties there is a tab as "script"

3)Under the script tab there is a dropdown you can search for "Update"

4)In Table, you can enter the table name where you want to update and click on "OK"