Exterpise Manager Select Export (ASCII,Excel,Access)?

Hi All. A client needs to send me some sample data. He has insisted he can query the table in Enterprise Manager via a simple select... "Select * from Table1"...

Now I need to get the data in some simple form (ASCII, Excel, Access, etc.) sent to me.

Can someone please provide me the info so I can pass it on for him to query a table from Enterprise Manager and "export it" to a simple file so I can receive it.

ANY THOUGHTS would be helpfull and GREATLY Appreciated!

Thanks.

BillIf this is a one timer I would go for "Tools -> Data Transformation Services -> Export Data".

// Pati|||Hey Pati... It may just be a one timer... but if the data looks good, it may be more frequent. it turns out some other process is taking records from this table, and may be removing them... Part of the reason we are trying to get some snapshots of the data.

I'm trying not to write an app until I know if we need this data.

Is it really simple to use to do the menu picks? Doesn't seem like the end user is very experienced, nor am I on Sql Server.

Thanks for the thoughts.

Bill|||If you think that you will need the same procedure again then you can save the DTS package for further use and then schedule it to run as desired.
...or then for another approach you could automate everything with scripts/scheduled jobs.

But as you're saying that you don't have much experience in SQL Server and that this might just be a one off solution then I would stick to DTS.

// Patisql

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

extending report server to support printing

Hi all
I am following the 'Deploying the Printer Delivery Sample' in order to add
printing functionality to reports.
After compiled code was put in both the reports server's and manager's bin
directories( and thier config files were
set accordingly), I can see the new printing delivery extension listed by
the server side (using the report server web service method
.ListExtensions(ExtensionTypeEnum.Delivery);).
But.. no sign for that extension when i open reports in the html viewer nor
in the subscriptions deliveries options..
I am not sure exactly where should i expect to see it if at all.. should i
create a button which will call the printing extension on click event'
I know that in the reports manager it should be listed in the subscription
deliveries options.
Another thing is that i am not sure i have added the codegroup section in
the *policy.config files correctly.
In the reports manager config file i had to remove it because it generated a
'no object reference' error..
I guess this should interfier at some point.
Thanks alot for your attention
ReaHi Rea:
Check Bryan's blog for some clarification on the codegroup placement:
http://weblogs.asp.net/bryanke/archive/2004/05/14/132110.aspx
--
Scott
http://www.OdeToCode.com/blogs/scott/
On Tue, 26 Oct 2004 16:05:50 +0200, "Rea Peleg" <rea_p@.afek.co.il>
wrote:
>Hi all
>I am following the 'Deploying the Printer Delivery Sample' in order to add
>printing functionality to reports.
>After compiled code was put in both the reports server's and manager's bin
>directories( and thier config files were
>set accordingly), I can see the new printing delivery extension listed by
>the server side (using the report server web service method
>.ListExtensions(ExtensionTypeEnum.Delivery);).
>But.. no sign for that extension when i open reports in the html viewer nor
>in the subscriptions deliveries options..
>I am not sure exactly where should i expect to see it if at all.. should i
>create a button which will call the printing extension on click event'
>I know that in the reports manager it should be listed in the subscription
>deliveries options.
>Another thing is that i am not sure i have added the codegroup section in
>the *policy.config files correctly.
>In the reports manager config file i had to remove it because it generated a
>'no object reference' error..
>I guess this should interfier at some point.
>Thanks alot for your attention
>Rea
>
>

Extended Stored Procedures

Dear all,
Does anyone knows how to write extended SPs in SQL Server 2000?
Can I get sample projects for the purpose?
Thanks in advance
VijayakumarCheck http://www.codeproject.com/database/mssqltutorial.asp.
There is also a lot of info in the Ken Hendersons book "Guru's Guide to SQL
Server Stored Procedures, XML, and HTML, The".
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Vijayakumar" <yvijayakumar@.hotmail.com.NO_SPAM> wrote in message
news:O2jUKoohEHA.3320@.TK2MSFTNGP11.phx.gbl...
> Dear all,
> Does anyone knows how to write extended SPs in SQL Server 2000?
> Can I get sample projects for the purpose?
> Thanks in advance
> Vijayakumar
>