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

Save variables to file or clipboard ? Expand / Collapse
Author
Message
Posted Tuesday, October 08, 2013 3:50 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
I have about 60-70 variables in my package. I want to keep them on a piece of paper for reference.
Is there any way I can print all those in the same way they appear inside the SSIS variables window ?
Post #1502851
Posted Wednesday, October 09, 2013 1:00 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 12,197, Visits: 9,148
Not that I know of.
You could take a screenshot of course

Or write an XML query or some .NET code that parses the XML and retrieves the variables.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1502934
Posted Wednesday, October 09, 2013 12:09 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
Koen Verbeeck (10/9/2013)
Not that I know of.
You could take a screenshot of course

Or write an XML query or some .NET code that parses the XML and retrieves the variables.


It would almost be like programming only MS Wordpad all by myself :) Not into all that now. Just doing ETL. Why doesn't Red Gate make it ? They are pretty good at the SQL server addons.
Post #1503237
Posted Wednesday, October 09, 2013 12:11 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 12,197, Visits: 9,148
etl.laptop (10/9/2013)
Why doesn't Red Gate make it ? They are pretty good at the SQL server addons.


I'll let them know




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1503241
Posted Wednesday, October 09, 2013 1:09 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, October 15, 2013 4:32 PM
Points: 63, Visits: 116
Koen Verbeeck (10/9/2013)
etl.laptop (10/9/2013)
Why doesn't Red Gate make it ? They are pretty good at the SQL server addons.


I'll let them know


And this too please - http://www.sqlservercentral.com/Forums/Topic1502861-364-1.aspx
Post #1503270
Posted Thursday, October 10, 2013 7:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:16 PM
Points: 2,812, Visits: 2,543
If you are looking at 3rd party tools, PragmaticWorks has something that may fit your need.
http://www.pragmaticworks.com/Products/BI-Documenter.aspx
Post #1503587
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse