ExternalActivator sample - documentation

Hi!

Where can I find some documentation about the ExternalActivator sample available on gotdotnet.com? I'm looking for a tutorial how the sample can be set up and used...

Thanks

Klaus Aschenbrenner
www.csharp.at
http://www.sqljunkies.com/weblog/klaus.aschenbrenner

We don't have any documentation on the External Activator sample. I've been asked more than once to provide some documentation. So I'll try to post something on my blog soon.

|||Uploaded to the codegallery.|||

Hi Rushi!

Thanks for the documentation on the ExternalActivator sample.
There are two important points to mention, which I've encountered during the setup:

*) The element <ConfigurationRecord><SQLServer> must contain the NETBIOS name of the SQL Server and not "localhost" (even when you setup the sample on your local SQL Server), because you compare this setting with the XML document <EVENT_INSTANCE> generated for the event QUEUE_ACTIVATION. If you use here "localhost", then there is no match the ExternalActivator can't activate your program

*) The element <ConfigurationRecord><ApplicationName> must contain the whole path to the executable that the ExternalActivator should start, like "c:\ExternalActivator\MyTask.exe".

Maybe you can add these two points to the documentation, because these are the points that I've learned the hard way...

Thanks

Klaus Aschenbrenner
www.csharp.at
www.sqljunkies.com/weblog/klaus.aschenbrenner

|||Done.|||

Hi Rushi!

Thanks for the update.
Can you please also describe in a few word the settings <StandardOut />, <StandardIn /> and <StandardErr />?

Thanks

Klaus Aschenbrenner
www.csharp.at
http://www.sqljunkies.com/weblog/klaus.aschenbrenner

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

Extend the sql server management studio

I'm looking for info/documentation about writing plugins for the management studio.
i'd like to extend the interface, for instance, alter the interface to allow scripting of all indexes for a table, by adding that option to the table context menu.

i'm also looking for a way to create macros in the query editor, so i can have pressing tab after writing a short word expand to a pre-selected template.

any help appreciated.

Check the following URL....

add-in to SQL Server Management Studio

http://www.codeproject.com/useritems/enisey.asp?df=100&forumid=315231&exp=0&select=1908869

|||http://blogs.msdn.com/dtjones/archive/2005/11/16/493440.aspx you can as per Dan's blog out there, I believe your best bet would be to contact Microsoft dev.team for more information.