External documentation (SQL Documenter)

I know that the BI studio can build a nice flow document that is associated with the package. Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?

Mark E. JohnsonI have an upcoming presentation and was wondering if there were any methods/features that could display all the SSIS packages, tasks, dataflows, relationships, and such in a functional diagram? Similar to what is seen in a ERD diagram. If not, are there any functions or tools that can help collage these SSIS displays (outside of screen shots)?|||We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K|||

Has a timeframe been defined yet?

Thanks Kirk.

|||

Yes, around the time that Yukon ships.
K

|||

KirkHaselden wrote:

We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K

Now that SQL Server 2005 has been released is there any news on this tool? I have been looking around for it but with no luck.

-Sune|||

The documenter is a "sample" application, not a released product, so there is no firm release schedule for it.

It's not quite ready yet. It should be quite soon, but I don't have a better estimate just now.

Donald

|||Thanks Donald. I'm looking forward.

If you need an external beta tester just let me know :o)

- Sune|||Has there been any new progress made on releasing this tool yet?|||

Did you find anything about your request?

I am looking for a SSIS Documenter too!

|||The DTS documenter was there for a while:
http://www.softrus.org/dts/

And I got a note that SSIS Documenter is coming from these guys as well.|||

Any updates on this?

|||

I found the following free tool.

http://www.bidocumenter.com/Public/Default.aspx

sql

External documentation

I know that the BI studio can build a nice flow document that is associated with the package. Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?

Mark E. JohnsonI have an upcoming presentation and was wondering if there were any methods/features that could display all the SSIS packages, tasks, dataflows, relationships, and such in a functional diagram? Similar to what is seen in a ERD diagram. If not, are there any functions or tools that can help collage these SSIS displays (outside of screen shots)?|||We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K|||

Has a timeframe been defined yet?

Thanks Kirk.

|||

Yes, around the time that Yukon ships.
K

|||

KirkHaselden wrote:

We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K

Now that SQL Server 2005 has been released is there any news on this tool? I have been looking around for it but with no luck.

-Sune|||

The documenter is a "sample" application, not a released product, so there is no firm release schedule for it.

It's not quite ready yet. It should be quite soon, but I don't have a better estimate just now.

Donald

|||Thanks Donald. I'm looking forward.

If you need an external beta tester just let me know :o)

- Sune|||Has there been any new progress made on releasing this tool yet?|||

Did you find anything about your request?

I am looking for a SSIS Documenter too!

|||The DTS documenter was there for a while:
http://www.softrus.org/dts/

And I got a note that SSIS Documenter is coming from these guys as well.|||

Any updates on this?

|||

I found the following free tool.

http://www.bidocumenter.com/Public/Default.aspx

External documentation

I know that the BI studio can build a nice flow document that is associated with the package. Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?

Mark E. JohnsonI have an upcoming presentation and was wondering if there were any methods/features that could display all the SSIS packages, tasks, dataflows, relationships, and such in a functional diagram? Similar to what is seen in a ERD diagram. If not, are there any functions or tools that can help collage these SSIS displays (outside of screen shots)?|||We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K|||

Has a timeframe been defined yet?

Thanks Kirk.

|||

Yes, around the time that Yukon ships.
K

|||

KirkHaselden wrote:

We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K

Now that SQL Server 2005 has been released is there any news on this tool? I have been looking around for it but with no luck.

-Sune|||

The documenter is a "sample" application, not a released product, so there is no firm release schedule for it.

It's not quite ready yet. It should be quite soon, but I don't have a better estimate just now.

Donald

|||Thanks Donald. I'm looking forward.

If you need an external beta tester just let me know :o)

- Sune|||Has there been any new progress made on releasing this tool yet?|||

Did you find anything about your request?

I am looking for a SSIS Documenter too!

|||The DTS documenter was there for a while:
http://www.softrus.org/dts/

And I got a note that SSIS Documenter is coming from these guys as well.|||

Any updates on this?

|||

I found the following free tool.

http://www.bidocumenter.com/Public/Default.aspx

External documentation

I know that the BI studio can build a nice flow document that is associated with the package. Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?

Mark E. JohnsonI have an upcoming presentation and was wondering if there were any methods/features that could display all the SSIS packages, tasks, dataflows, relationships, and such in a functional diagram? Similar to what is seen in a ERD diagram. If not, are there any functions or tools that can help collage these SSIS displays (outside of screen shots)?|||We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K|||

Has a timeframe been defined yet?

Thanks Kirk.

|||

Yes, around the time that Yukon ships.
K

|||

KirkHaselden wrote:

We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K

Now that SQL Server 2005 has been released is there any news on this tool? I have been looking around for it but with no luck.

-Sune|||

The documenter is a "sample" application, not a released product, so there is no firm release schedule for it.

It's not quite ready yet. It should be quite soon, but I don't have a better estimate just now.

Donald

|||Thanks Donald. I'm looking forward.

If you need an external beta tester just let me know :o)

- Sune|||Has there been any new progress made on releasing this tool yet?|||

Did you find anything about your request?

I am looking for a SSIS Documenter too!

|||The DTS documenter was there for a while:
http://www.softrus.org/dts/

And I got a note that SSIS Documenter is coming from these guys as well.|||

Any updates on this?

|||

I found the following free tool.

http://www.bidocumenter.com/Public/Default.aspx

External documentation

I know that the BI studio can build a nice flow document that is associated with the package. Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?

Mark E. JohnsonI have an upcoming presentation and was wondering if there were any methods/features that could display all the SSIS packages, tasks, dataflows, relationships, and such in a functional diagram? Similar to what is seen in a ERD diagram. If not, are there any functions or tools that can help collage these SSIS displays (outside of screen shots)?|||We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K|||

Has a timeframe been defined yet?

Thanks Kirk.

|||

Yes, around the time that Yukon ships.
K

|||

KirkHaselden wrote:

We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K

Now that SQL Server 2005 has been released is there any news on this tool? I have been looking around for it but with no luck.

-Sune|||

The documenter is a "sample" application, not a released product, so there is no firm release schedule for it.

It's not quite ready yet. It should be quite soon, but I don't have a better estimate just now.

Donald

|||Thanks Donald. I'm looking forward.

If you need an external beta tester just let me know :o)

- Sune|||Has there been any new progress made on releasing this tool yet?|||

Did you find anything about your request?

I am looking for a SSIS Documenter too!

|||The DTS documenter was there for a while:
http://www.softrus.org/dts/

And I got a note that SSIS Documenter is coming from these guys as well.|||

Any updates on this?

|||

I found the following free tool.

http://www.bidocumenter.com/Public/Default.aspx

External documentation

I know that the BI studio can build a nice flow document that is associated with the package. Is there an easy way to build a series fo documents that can be shared with other users without having them go into Visual Studio?

Mark E. JohnsonI have an upcoming presentation and was wondering if there were any methods/features that could display all the SSIS packages, tasks, dataflows, relationships, and such in a functional diagram? Similar to what is seen in a ERD diagram. If not, are there any functions or tools that can help collage these SSIS displays (outside of screen shots)?|||We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K|||

Has a timeframe been defined yet?

Thanks Kirk.

|||

Yes, around the time that Yukon ships.
K

|||

KirkHaselden wrote:

We are building a tool that will traverse IS packages, SQL Server Databases, and AS to get metadata reports. It should be available around the time we ship.
It's called the "SQL Documenter"...
Thanks,
K

Now that SQL Server 2005 has been released is there any news on this tool? I have been looking around for it but with no luck.

-Sune|||

The documenter is a "sample" application, not a released product, so there is no firm release schedule for it.

It's not quite ready yet. It should be quite soon, but I don't have a better estimate just now.

Donald

|||Thanks Donald. I'm looking forward.

If you need an external beta tester just let me know :o)

- Sune|||Has there been any new progress made on releasing this tool yet?|||

Did you find anything about your request?

I am looking for a SSIS Documenter too!

|||The DTS documenter was there for a while:
http://www.softrus.org/dts/

And I got a note that SSIS Documenter is coming from these guys as well.|||

Any updates on this?

|||

I found the following free tool.

http://www.bidocumenter.com/Public/Default.aspx

sql

Exporting to CSV add "_Value" or "_Value2" to the field name

Hi,

When I'm export a report that has been build in the "Report Builder" to csv to all fields caption added at the end of the field name the word "_Value" or "_Value2"

example:

field name in the report: EmployeeName

field in the csv : EmployeeName_Value

How can I remove this adding?

Thanks

Assaf

Assaf,

There is no easy way to change CSV heading in ReportBuilder, but you can save the report uploaded to the Report Server on a local disk, modify RDL and change names of the column headings, and upload it back to the server.

To do this, you can either search for "_Value" in the textbox names in RDL file and remove it, or add a child XML element node DataElementName in the RDL for each text box with column heading you want to modify:

<Textbox Name="Component_Value">
<DataElementOutput>Output</DataElementOutput>
<DataElementName>Component</DataElementName>
<CanGrow>true</CanGrow>
<Action>
....

The value of <DataElementName> element becomes a column heading in CSV output.

Note though that if you modify the uploaded report in ReportBuilder after you applied your changes, the changes will be lost as ReportBuilder re-generates RDL.

Thanks!