question

kkran-5951 avatar image
0 Votes"
kkran-5951 asked ZoeHui-MSFT answered

SSIS : How to identify a specific transformation being used in SSIS packages?

Hi Team - I have about 200 SSIS packages in a folder and each package has its own solution. Some of the packages are using the power pack transformation called 'ZappySys'. I need to identify which packages are using this 'ZappySys' transformation in the packages.

If I open each and every package, it takes a lot of time. Is there any easy way to identify without opening the SSIS packages?

Thanks in advance.

sql-server-generalsql-server-integration-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered

Hi @kkran-5951,

Open the package with notepad and use Ctrl+F to find the 'ZappySys'.

I could only use this way to identify a specific transformation which will also take a lot of time but is less that open with SSDT.

Hope it could give you some ideas.

Regards,

Zoe


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

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hot issues October



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.