Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSIS - Remove unused variables and such from SSIS ? Expand / Collapse
Author
Message
Posted Wednesday, November 06, 2013 4:17 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:32 PM
Points: 182, Visits: 479
How do you remove things like unused variables from SSIS ? I am using 2008.
Post #1512030
Posted Thursday, November 07, 2013 2:21 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, April 17, 2014 4:39 AM
Points: 1,042, Visits: 1,829
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

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1512153
Posted Thursday, November 07, 2013 10:07 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 2:32 PM
Points: 182, Visits: 479
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.
Post #1512360
Posted Friday, November 08, 2013 8:27 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 7:38 AM
Points: 4, Visits: 57
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.
Post #1512700
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse