November 6, 2013 at 4:17 pm
How do you remove things like unused variables from SSIS ? I am using 2008.
November 7, 2013 at 2:21 am
What variables are you talking about? You can delete the SSIS variables you do not require for package execution from the designer by edit the dtsx file
Raunak J
November 7, 2013 at 10:07 am
Raunak Jhawar (11/7/2013)
What variables are you talking about? You can delete the SSIS variables you do not require for package execution from the designer by edit the dtsx file
Say you created some variables and then, you removed them wherever they were used. If you forgot to delete them, then it can be hard to find which one you forgot to delete. I wish ssis could highlight unused variables.
I had 5-6 such variables once and I had to check if they were being used or not before i deleted them.
November 8, 2013 at 8:27 am
It's not my favorite solution, but it should get the job done.
Right-click on your package in Solution Explorer, choose 'View Code'.
Ctrl+F, put in your variable name. Find Next.
All variables will be declared under the <DTS:Variables> node. If that same variable is not found anywhere else in the code, it's safe to assume it's not being used in the package.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply