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

External notification of database updates

MS-SQL 2005, C# 2.0

I will have many client databases that will be updated. When they are updated I need to transfer some of that data to a central Server database somewhere on the Internet. Note, schemas do not necessarily match.

Transfering the data (Web Services, Remoting) is not a problem.

What I am looking for is a cool, correct, advisable way, for the client database to notify me of an Insert, Update or Delete. I can then initiate the connection to the Server and 'push' the data (maybe pull some back from the Server too).

Obviously Triggers may be a place to start... But I need to know 'external to the database' that an update has happened or can I send the data from within the SQL Server assembly?

Anyone have any ideas or a technique, maybe something new in SQL Server 2005 (all databases will be 2005), for acheiving this? Just so I don't go down the 'wrong' path...

There are some BLOB's involved (1-2 page PDF's), if that makes a difference.

I envisage that the process transfering the data will be a Windows Service running on each client. The connection may not always be available, so some kind of 'to do' list of outstanding data to be transfered is required.

I'm just starting on this, so any pointers would be great, I'm sure it's all been done before ;)

Thanks

Rob.

One interesting technique to consider would be using triggers and service broker. When an insert, update or delete occurs, send a message via service broker to your central server informing it of the change along with whatever data is necessary to identify it. The central server can then asynchronously receive and process the message.

Dan

Extended Stored Procedure: Get the current db of the client

Hi
Is there a way to get the current database of the client who calls my
Extended Stored Procedure?
I have written a DLL in Visual Studion 2005 for the SQL server 2003 in C/C++
using the functions srv_*.
Thanks.
HansWhat version of SQL Server?
It's a limitation of extended stored procedure programming
with SQL Server 2000. Some have tried using svr_rpcdb but it
will generally just return master as the database name. And
it's no longer supported.
-Sue
On Mon, 8 May 2006 14:41:59 +0200, "Hans Stoessel"
<hstoessel.list@.pm-medici.ch> wrote:

>Hi
>Is there a way to get the current database of the client who calls my
>Extended Stored Procedure?
>I have written a DLL in Visual Studion 2005 for the SQL server 2003 in C/C+
+
>using the functions srv_*.
>Thanks.
>Hans
>|||This never worked correctly, this is not way you can get the database
context from within an XP, easiest work around is to use a wrapper SP that
passes the db_name() or db_id() as a parameter.
In general using wrapper SP's is a good practice for doing parameter
validation, and meta data exposure since XP's do not emit the parameter
signatures.
GertD@.SQLDev.Net
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:feuv521gpm893g6hfi4aja0vpp8vguiun4@.
4ax.com...
> What version of SQL Server?
> It's a limitation of extended stored procedure programming
> with SQL Server 2000. Some have tried using svr_rpcdb but it
> will generally just return master as the database name. And
> it's no longer supported.
> -Sue
> On Mon, 8 May 2006 14:41:59 +0200, "Hans Stoessel"
> <hstoessel.list@.pm-medici.ch> wrote:
>
>|||Works for SP's, might work with XP's as well:
1. Prefix the name with "sp_"
2. Mark it as a system object with sp_MS_MarkSystemObject
This causes the SP to run under the context of the database it was called
from, not the master database where it resides. At the least, you can put
an SP wrapper in the master DB for the XP, and pass in the db_name() as a
parameter to the XP and it will have the correct database context (not
"master").
"Gert E.R. Drapers" <GertD@.SQLDev@.Net> wrote in message
news:%23ZtUJnzcGHA.3632@.TK2MSFTNGP05.phx.gbl...
> This never worked correctly, this is not way you can get the database
> context from within an XP, easiest work around is to use a wrapper SP that
> passes the db_name() or db_id() as a parameter.
> In general using wrapper SP's is a good practice for doing parameter
> validation, and meta data exposure since XP's do not emit the parameter
> signatures.
> GertD@.SQLDev.Net
>
> "Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
> news:feuv521gpm893g6hfi4aja0vpp8vguiun4@.
4ax.com...
>|||Does not matter, an XP does not have a call to retrieve the database
context.
GertD@.SQLDev.Net
"Mike C#" <xxx@.yyy.com> wrote in message news:wzR8g.505$Ut2.124@.fe09.lga...
> Works for SP's, might work with XP's as well:
> 1. Prefix the name with "sp_"
> 2. Mark it as a system object with sp_MS_MarkSystemObject
> This causes the SP to run under the context of the database it was called
> from, not the master database where it resides. At the least, you can put
> an SP wrapper in the master DB for the XP, and pass in the db_name() as a
> parameter to the XP and it will have the correct database context (not
> "master").
>
> "Gert E.R. Drapers" <GertD@.SQLDev@.Net> wrote in message
> news:%23ZtUJnzcGHA.3632@.TK2MSFTNGP05.phx.gbl...
>|||DBLIB, dbname() function.
http://msdn.microsoft.com/library/d...br />
2gtz.asp
enjoy
"Gert E.R. Drapers" <GertD@.SQLDev@.Net> wrote in message
news:u8i0W6WdGHA.4720@.TK2MSFTNGP03.phx.gbl...
> Does not matter, an XP does not have a call to retrieve the database
> context.
> GertD@.SQLDev.Net
> "Mike C#" <xxx@.yyy.com> wrote in message
> news:wzR8g.505$Ut2.124@.fe09.lga...
>|||No, because then you need to connect first! So what database do you
establish your connection to?
Please don't answer try to answer questions you do not know the answer to.
-GertD
"Mike C#" <xxx@.yyy.com> wrote in message news:Ga99g.60$Id.19@.fe10.lga...
> DBLIB, dbname() function.
> http://msdn.microsoft.com/library/d... />
z_2gtz.asp
> enjoy
> "Gert E.R. Drapers" <GertD@.SQLDev@.Net> wrote in message
> news:u8i0W6WdGHA.4720@.TK2MSFTNGP03.phx.gbl...
>|||And you plan to what? Put the same "wrapper" stored procedure in every
single database on a server?
Don't be a dick Gertrude.
"Gert E.R. Drapers" <GertD@.SQLDev@.Net> wrote in message
news:Ou6TvyjdGHA.3632@.TK2MSFTNGP05.phx.gbl...
> No, because then you need to connect first! So what database do you
> establish your connection to?
> Please don't answer try to answer questions you do not know the answer to.
> -GertD
> "Mike C#" <xxx@.yyy.com> wrote in message news:Ga99g.60$Id.19@.fe10.lga...
>|||underprocessable|||"Gert E.R. Drapers" wrote:

> No, you are incorrect; for an extended stored procedure you have to pass i
n
> the database context as a parameter if you need it, that is the only thing
> that works. Did you ever write an extended stored procedure?
I have written several, several, several extended stored procedures. In
fact, I just publicly released about 3 dozen that cover everything from AES,
Blowfish, Twofish, DES and TripleDES encryption to regular expressions to
recursively reading a local subdirectory listing.
In fact, here's a little experiment for you extended procedure maestro: Put
this regular stored procedure in the Master database:
CREATE PROCEDURE dbo.Test1
AS
SELECT db_Name()
GO
Now run it from within the Model database. Or the Northwind database. What
database name comes up? Master, that's what. According to your solution,
you need to recreate this exact same stored procedure in every single
database you own in order to get the current database context out of it.
As I said: changing the name to "sp_..." and marking it as a system object
will allow you to use JUST ONE copy of the stored procedure in Master. It
will run in the context of the CURRENT DATABASE, no matter what database you
invoke it from. But I'm sure you're well aware of that.

> Besides that it does not make sense to call the DB-Lib function dbname()
> untill you established a loopback connection over DB-Library, which would
> default to the default database for the user which is not the same as the
> database context. See the attached example which shows this behavior.
And that's all well and good. I was simply pointing out some things that
might be tried, and you pointed out that it wouldn't work in your own little
snide way.

> The srv_rpc* class methods in the OPENDS60.LIB file are obsolete since the
y
> are gateway calls and not longer supported; srv_rpcdb() only gave you a
> database context when you where a remote procedure, which is something
> different than an extended stored procedure, so that is not giving you wan
t
> you want either.
I know srv_rpcdb doesn't work, and didn't suggest it as a solution. I'm
sure whoever didn't know that will be happy to hear it from you, however.

> So Mike C#, the ONLY solution is to pass it in as a parameter!
Which is fine, and perfectly acceptable. The difference is simply this, if
you refer back to my original post: Your method requires the same stored
procedure be copied to all 28 of my databases. Alternatively I can put a
single copy in the Master database and be done with it.

> BTW: Next time you are calling somebody names you might want to check your
> facts before replying an making a fool out of yourself.
BTW: You should check your facts before you accuse someone of not having
any experience in your little domain over there before making a fool of
yourself.
http://www.sqlservercentral.com/col...oolkitpart1.asp
http://www.sqlservercentral.com/col...oolkitpart2.asp
http://www.sqlservercentral.com/col...oolkitpart3.asp
http://www.sqlservercentral.com/col...oolkitpart4.asp
Of course I'd love an opportunity to learn at the master's feet. So where
does Master Gert keep his extended procedures, that I may immerse myself in
the knowledge to be gained?sql

Extended Stored Proc & Progress notification

In my extended stored procedure, I'm trying to return rows as data is
available. The client is expecting to use this data to show progress
notification (10%, 20% etc etc).
Even with variations of the srv_describe, srv_sendrow & srv_senddone
I'm not able to get the client to display the data as it becomes
available. Instead, the rows come all together at the end of the call.
Has anyone succeeded in acheiving this? What am I doing wrong?
Any help appreciated,
Kartik
----
Here is a snippet of the code..
...
srv_describe ( This.srvproc_,
1,
"messages",
SRV_NULLTERM,
SRV_TDS_NVARCHAR, // Dest data type.
(DBINT) 512, // Dest data length.
SRV_TDS_NVARCHAR, // Source data type.
(DBINT) 512, // Source data length.
NULL );
...
...
srv_setcoldata ( This.srvproc_, 1, (BYTE*)bstrMessage.m_str );
srv_setcollen ( This.srvproc_, 1, bstrMessage.Length()*sizeof(WCHAR)
);
if ( !srv_sendrow( This.srvproc_ ) )
{
ASSERT ( 0 );
}
...
...
srv_senddone ( This.srvproc_, SRV_DONE_FINAL | SRV_DONE_COUNT, 0,
rowcount );
...Kartik,
I doubt that this is possible. what you are describing is callbacks or
events and SQL Server 2000 doesn't support this.
regards
Greg O
"Kartik Shah" <k2shah10@.hotmail.com> wrote in message
news:7f618d19.0403041544.df23472@.posting.google.com...
> In my extended stored procedure, I'm trying to return rows as data is
> available. The client is expecting to use this data to show progress
> notification (10%, 20% etc etc).
> Even with variations of the srv_describe, srv_sendrow & srv_senddone
> I'm not able to get the client to display the data as it becomes
> available. Instead, the rows come all together at the end of the call.
> Has anyone succeeded in acheiving this? What am I doing wrong?
> Any help appreciated,
> Kartik
> ----
> Here is a snippet of the code..
> ...
> srv_describe ( This.srvproc_,
> 1,
> "messages",
> SRV_NULLTERM,
> SRV_TDS_NVARCHAR, // Dest data type.
> (DBINT) 512, // Dest data length.
> SRV_TDS_NVARCHAR, // Source data type.
> (DBINT) 512, // Source data length.
> NULL );
> ...
> ...
> srv_setcoldata ( This.srvproc_, 1, (BYTE*)bstrMessage.m_str );
> srv_setcollen ( This.srvproc_, 1, bstrMessage.Length()*sizeof(WCHAR)
> );
> if ( !srv_sendrow( This.srvproc_ ) )
> {
> ASSERT ( 0 );
> }
> ...
> ...
> srv_senddone ( This.srvproc_, SRV_DONE_FINAL | SRV_DONE_COUNT, 0,
> rowcount );
> ...|||Greg,
I can receive the notification in the extended stored proc. Now to
inform the client about the notification, I had intended to send a
single row with the message. But somehow, the client seems to be
getting all the rows all at once at the end of the extended stored
procedure.
The documentation seems to indicate that the API does provide a way to
send data as it is produced.
Thanks,
Kartik
"Greg Obleshchuk" <greg-n-o-s-p-a-m-@.ag-s-o-f-t-w-a-r-e.com> wrote in message news:<#OymsAmAEHA.2292@.TK2MSFTNGP12.phx.gbl>...
> Kartik,
> I doubt that this is possible. what you are describing is callbacks or
> events and SQL Server 2000 doesn't support this.
> regards
> Greg O
>
> "Kartik Shah" <k2shah10@.hotmail.com> wrote in message
> news:7f618d19.0403041544.df23472@.posting.google.com...
> > In my extended stored procedure, I'm trying to return rows as data is
> > available. The client is expecting to use this data to show progress
> > notification (10%, 20% etc etc).
> >
> > Even with variations of the srv_describe, srv_sendrow & srv_senddone
> > I'm not able to get the client to display the data as it becomes
> > available. Instead, the rows come all together at the end of the call.
> >
> > Has anyone succeeded in acheiving this? What am I doing wrong?
> >
> > Any help appreciated,
> > Kartik
> >
> > ----
> > Here is a snippet of the code..
> >
> > ...
> > srv_describe ( This.srvproc_,
> > 1,
> > "messages",
> > SRV_NULLTERM,
> > SRV_TDS_NVARCHAR, // Dest data type.
> > (DBINT) 512, // Dest data length.
> > SRV_TDS_NVARCHAR, // Source data type.
> > (DBINT) 512, // Source data length.
> > NULL );
> > ...
> >
> > ...
> > srv_setcoldata ( This.srvproc_, 1, (BYTE*)bstrMessage.m_str );
> > srv_setcollen ( This.srvproc_, 1, bstrMessage.Length()*sizeof(WCHAR)
> > );
> > if ( !srv_sendrow( This.srvproc_ ) )
> > {
> > ASSERT ( 0 );
> > }
> > ...
> >
> > ...
> > srv_senddone ( This.srvproc_, SRV_DONE_FINAL | SRV_DONE_COUNT, 0,
> > rowcount );
> > ...

Extended Stored Proc & Progress notification

In my extended stored procedure, I'm trying to return rows as data is
available. The client is expecting to use this data to show progress
notification (10%, 20% etc etc).
Even with variations of the srv_describe, srv_sendrow & srv_senddone
I'm not able to get the client to display the data as it becomes
available. Instead, the rows come all together at the end of the call.
Has anyone succeeded in acheiving this? What am I doing wrong?
Any help appreciated,
Kartik
----
Here is a snippet of the code..
...
srv_describe ( This.srvproc_,
1,
"messages",
SRV_NULLTERM,
SRV_TDS_NVARCHAR, // Dest data type.
(DBINT) 512, // Dest data length.
SRV_TDS_NVARCHAR, // Source data type.
(DBINT) 512, // Source data length.
NULL );
...
...
srv_setcoldata ( This.srvproc_, 1, (BYTE*)bstrMessage.m_str );
srv_setcollen ( This.srvproc_, 1, bstrMessage.Length()*sizeof(WCHAR)
);
if ( !srv_sendrow( This.srvproc_ ) )
{
ASSERT ( 0 );
}
...
...
srv_senddone ( This.srvproc_, SRV_DONE_FINAL | SRV_DONE_COUNT, 0,
rowcount );
...Kartik,
I doubt that this is possible. what you are describing is callbacks or
events and SQL Server 2000 doesn't support this.
regards
Greg O
"Kartik Shah" <k2shah10@.hotmail.com> wrote in message
news:7f618d19.0403041544.df23472@.posting.google.com...
> In my extended stored procedure, I'm trying to return rows as data is
> available. The client is expecting to use this data to show progress
> notification (10%, 20% etc etc).
> Even with variations of the srv_describe, srv_sendrow & srv_senddone
> I'm not able to get the client to display the data as it becomes
> available. Instead, the rows come all together at the end of the call.
> Has anyone succeeded in acheiving this? What am I doing wrong?
> Any help appreciated,
> Kartik
> ----
> Here is a snippet of the code..
> ...
> srv_describe ( This.srvproc_,
> 1,
> "messages",
> SRV_NULLTERM,
> SRV_TDS_NVARCHAR, // Dest data type.
> (DBINT) 512, // Dest data length.
> SRV_TDS_NVARCHAR, // Source data type.
> (DBINT) 512, // Source data length.
> NULL );
> ...
> ...
> srv_setcoldata ( This.srvproc_, 1, (BYTE*)bstrMessage.m_str );
> srv_setcollen ( This.srvproc_, 1, bstrMessage.Length()*sizeof(WCHAR)
> );
> if ( !srv_sendrow( This.srvproc_ ) )
> {
> ASSERT ( 0 );
> }
> ...
> ...
> srv_senddone ( This.srvproc_, SRV_DONE_FINAL | SRV_DONE_COUNT, 0,
> rowcount );
> ...|||Greg,
I can receive the notification in the extended stored proc. Now to
inform the client about the notification, I had intended to send a
single row with the message. But somehow, the client seems to be
getting all the rows all at once at the end of the extended stored
procedure.
The documentation seems to indicate that the API does provide a way to
send data as it is produced.
Thanks,
Kartik
"Greg Obleshchuk" <greg-n-o-s-p-a-m-@.ag-s-o-f-t-w-a-r-e.com> wrote in message news:<#OymsAm
AEHA.2292@.TK2MSFTNGP12.phx.gbl>...
> Kartik,
> I doubt that this is possible. what you are describing is callbacks or
> events and SQL Server 2000 doesn't support this.
> regards
> Greg O
>
> "Kartik Shah" <k2shah10@.hotmail.com> wrote in message
> news:7f618d19.0403041544.df23472@.posting.google.com...|||Hi,
In my experience that isn't the case. The process is internal to SQL Server
(within the memory space) so you would have to jump out of your process and
return to the calling process. I see no facility that does this.
You might want to get in touch with a guy names Gert ER Drapers at
www.sqldev.net. Gert was the architect of the SQL Server Tools in SQL
Server. Gert's a good bloke and will be able to tell you if it can or can't
be done. If it can he can tell you the correct way to do it.
regards
Greg O
http://www.ag-software.com
"Kartik Shah" <k2shah10@.hotmail.com> wrote in message
news:7f618d19.0403050653.2505cc9c@.posting.google.com...
> Greg,
> I can receive the notification in the extended stored proc. Now to
> inform the client about the notification, I had intended to send a
> single row with the message. But somehow, the client seems to be
> getting all the rows all at once at the end of the extended stored
> procedure.
> The documentation seems to indicate that the API does provide a way to
> send data as it is produced.
> Thanks,
> Kartik
>
> "Greg Obleshchuk" <greg-n-o-s-p-a-m-@.ag-s-o-f-t-w-a-r-e.com> wrote in
message news:<#OymsAmAEHA.2292@.TK2MSFTNGP12.phx.gbl>...

Express installation fails with "invalid installation package"

I get an error when trying to install the SQL Native Client. It says it cannot find the installation package and to use a valid copy of 'sqlncli.msi'. I've downloaded the Express setup twice and get the same error from both of them.
I'm attempting this in a VMWare session setup for Windows 2K, Advanced Server. I am trying to test my installation and setup procedures. This is not a production setup, just install testing and documentation. I have allocated only 272MB to the VMWare session, which is why the system doesn't meet the recommended settings.
Any help would be greatly appreciated.
Below is the Summary.txt output file.
Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows 2000 Advanced Server Service Pack 4 (Build 2195)
Time : Wed May 03 09:54:23 2006

CPCWIN2KVM1 : The current system does not meet recommended hardware requirements for this SQL Server release. For detailed hardware requirements, see the readme file or SQL Server Books Online.
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_CPCWIN2KVM1_SQLSupport_1.log
--
Machine : CPCWIN2KVM1
Product : SQL Native Client
Error : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
--
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_CPCWIN2KVM1_SQLNCLI_1.log
Last Action : InstallFinalize
Error String : An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
Error Number : 1706
--
Machine : CPCWIN2KVM1
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_CPCWIN2KVM1_SqlWriter_1.log
--
Machine : CPCWIN2KVM1
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0003_CPCWIN2KVM1_MSXML6_1.log
--
Remove the Native Client in the control panel/add remove programs and rerun the installation.|||

Let us know if this resolved your issue. Feel free to mark the thread as answered if it did.

If you're still having problems I can move this thread to the Setup group to see if they have some ideas.

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

|||

I was having the same problem. I removed the Native Client in the control panel and all seems to be working fine now.

Alex

Express ... DTS or SSIS

Chris Marsh wrote:
> Is there a download or way that DTS or SSIS can work with SQL Express 2005
.
> I need to import data at a client site on a live database.
> Thanks
http://msdn2.microsoft.com/en-us/library/ms143706.aspxThanks Tracy however I am confused about something after reading the KB you
pointed me to. It states "The Import and Export Utility that is included
with SQL Server 2005 Express Edition is not the SQL Server Import and Export
Wizard". So, where do I find the Import Export Utility to see if it will
resolve my needs? I just don't see it anywhere.
Again, thank you.
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150207527.154929.271070@.u72g2000cwu.googlegroups.com...
> Chris Marsh wrote:
>
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
>|||Chris Marsh wrote:
> Thanks Tracy however I am confused about something after reading the KB yo
u
> pointed me to. It states "The Import and Export Utility that is included
> with SQL Server 2005 Express Edition is not the SQL Server Import and Expo
rt
> Wizard". So, where do I find the Import Export Utility to see if it will
> resolve my needs? I just don't see it anywhere.
> Again, thank you.
Sorry, I don't have Express installed anywhere. I did search Google
for "sqlserver express import", and turned up lots of stuff. You might
find something useful there.|||Thanks...I'm blind I just cannot find it
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150212092.326676.276420@.f6g2000cwb.googlegroups.com...
> Chris Marsh wrote:
> Sorry, I don't have Express installed anywhere. I did search Google
> for "sqlserver express import", and turned up lots of stuff. You might
> find something useful there.
>|||Is there a download or way that DTS or SSIS can work with SQL Express 2005.
I need to import data at a client site on a live database.
Thanks|||Chris Marsh wrote:
> Is there a download or way that DTS or SSIS can work with SQL Express 2005
.
> I need to import data at a client site on a live database.
> Thanks
http://msdn2.microsoft.com/en-us/library/ms143706.aspx|||Thanks Tracy however I am confused about something after reading the KB you
pointed me to. It states "The Import and Export Utility that is included
with SQL Server 2005 Express Edition is not the SQL Server Import and Export
Wizard". So, where do I find the Import Export Utility to see if it will
resolve my needs? I just don't see it anywhere.
Again, thank you.
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150207527.154929.271070@.u72g2000cwu.googlegroups.com...
> Chris Marsh wrote:
>
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
>|||Chris Marsh wrote:
> Thanks Tracy however I am confused about something after reading the KB yo
u
> pointed me to. It states "The Import and Export Utility that is included
> with SQL Server 2005 Express Edition is not the SQL Server Import and Expo
rt
> Wizard". So, where do I find the Import Export Utility to see if it will
> resolve my needs? I just don't see it anywhere.
> Again, thank you.
Sorry, I don't have Express installed anywhere. I did search Google
for "sqlserver express import", and turned up lots of stuff. You might
find something useful there.|||Thanks...I'm blind I just cannot find it
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150212092.326676.276420@.f6g2000cwb.googlegroups.com...
> Chris Marsh wrote:
> Sorry, I don't have Express installed anywhere. I did search Google
> for "sqlserver express import", and turned up lots of stuff. You might
> find something useful there.
>

Express ... DTS or SSIS

Is there a download or way that DTS or SSIS can work with SQL Express 2005.
I need to import data at a client site on a live database.
ThanksChris Marsh wrote:
> Is there a download or way that DTS or SSIS can work with SQL Express 2005.
> I need to import data at a client site on a live database.
> Thanks
http://msdn2.microsoft.com/en-us/library/ms143706.aspx|||Thanks Tracy however I am confused about something after reading the KB you
pointed me to. It states "The Import and Export Utility that is included
with SQL Server 2005 Express Edition is not the SQL Server Import and Export
Wizard". So, where do I find the Import Export Utility to see if it will
resolve my needs? I just don't see it anywhere.
Again, thank you.
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150207527.154929.271070@.u72g2000cwu.googlegroups.com...
> Chris Marsh wrote:
>> Is there a download or way that DTS or SSIS can work with SQL Express
>> 2005.
>> I need to import data at a client site on a live database.
>> Thanks
>
> http://msdn2.microsoft.com/en-us/library/ms143706.aspx
>|||Chris Marsh wrote:
> Thanks Tracy however I am confused about something after reading the KB you
> pointed me to. It states "The Import and Export Utility that is included
> with SQL Server 2005 Express Edition is not the SQL Server Import and Export
> Wizard". So, where do I find the Import Export Utility to see if it will
> resolve my needs? I just don't see it anywhere.
> Again, thank you.
Sorry, I don't have Express installed anywhere. I did search Google
for "sqlserver express import", and turned up lots of stuff. You might
find something useful there.|||Thanks...I'm blind I just cannot find it:(
"Tracy McKibben" <tracy.mckibben@.gmail.com> wrote in message
news:1150212092.326676.276420@.f6g2000cwb.googlegroups.com...
> Chris Marsh wrote:
>> Thanks Tracy however I am confused about something after reading the KB
>> you
>> pointed me to. It states "The Import and Export Utility that is included
>> with SQL Server 2005 Express Edition is not the SQL Server Import and
>> Export
>> Wizard". So, where do I find the Import Export Utility to see if it will
>> resolve my needs? I just don't see it anywhere.
>> Again, thank you.
> Sorry, I don't have Express installed anywhere. I did search Google
> for "sqlserver express import", and turned up lots of stuff. You might
> find something useful there.
>

Exporting to PDF in Java with web interface issue

Hi, thanks for taking the time to take a look at this.

As you can read from the title, I'm trying to export a report to pdf from a thick java client. My connection string is:
"http://10.0.1.36/ReportServer/?/Invoice1/Invoice&assetNbr=14
&invoiceId=061000002&rs:Command=Render:&rs:Format=PDF&rc:Toolbar=false"
(I just added the toolbar=false part, and it didn't fix the problem)

After getting the datastream I just throw it into a file and it works fine... Until I add an image to my report. I don't get any errors in my program, but when I try to open up the pdf itself I get the error: "There was an error opening this document. The file is damaged and could not be repaired."

What confuses me is that if I enter the connection string in ie it comes up and asks me what I should do with the pdf and that one has the image in it with not problems.

To summarize if I've been unclear:
Export via ie no image: good
Export via ie with image: good
Export via java no image: good
Export via java with image: error

Does anyone have an idea why this would occur? I have an Execution Account set up in Reporting Services Configuration Manager and I have IIS anonymous access set up to use my local administrator account so I don't think accessing the image is an issue. But I'm definitely no server/admin expert so if there are any such issues could be causing this don't assume I've got that set up properly.

Thanks, JeffAre you certain that you are writing the file correctly from your Java app?|||I'm pretty sure I am. The whole setup works and exports correctly when connecting to a report that doesn't have an image embedded in it.

Also, is there any way to access the reports other than the web interface from java? I've only seen implementations of this in C# and vb.net|||

You should be able to use any Java SOAP toolkit (such as JAX).

FWIW, perhaps the report w/the image is larger, and exposing some bug in your Java code? Maybe you should compare the byte count of the IE output to what you are getting w/Java.

|||My face is red, it just was that I was stopping the fileout one byte too early... Thanks a bunch for your help.

If I can ask one more favor of you, I'm not familiar with the components involved in using SOAP so if you could give me a little overview that would give me someplace to start reading about it I'd really appreciate it.|||

I've never used any of SOAP toolkits for Java... so I can't really help you out there. This showed some links which may be of interest to you:

http://search.live.com/results.aspx?q=java+SOAP+toolkit&mkt=en-US&form=QBRE

Exporting to PDF

Hello - I have a client that is exporting to PDF and the export fails. I
have seen other posts running into the same problem, something to do with PDF
6 writer. Does Microsoft have a workaround or an update to this?
Thanks in advance.Please supply more information about what you are seeing, such as, error
messages, reproduction steps, etc.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"comet61" <comet61@.discussions.microsoft.com> wrote in message
news:22E13F24-ECA7-4A08-8194-E7A1318122B6@.microsoft.com...
> Hello - I have a client that is exporting to PDF and the export fails. I
> have seen other posts running into the same problem, something to do with
> PDF
> 6 writer. Does Microsoft have a workaround or an update to this?
> Thanks in advance.|||The client is trying to download a matrix style report into a pdf. They have
Adobe 6 Professional. The report is around 150 pages and 800 Kb.
We are able to download via Adobe 6 reader, but have numerous formatting
problems within.
"Bruce Johnson [MSFT]" wrote:
> Please supply more information about what you are seeing, such as, error
> messages, reproduction steps, etc.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "comet61" <comet61@.discussions.microsoft.com> wrote in message
> news:22E13F24-ECA7-4A08-8194-E7A1318122B6@.microsoft.com...
> > Hello - I have a client that is exporting to PDF and the export fails. I
> > have seen other posts running into the same problem, something to do with
> > PDF
> > 6 writer. Does Microsoft have a workaround or an update to this?
> >
> > Thanks in advance.
>
>|||Can you send me, directly to me, some screen shots or the PDF that
demonstrates the problem.
I don't think I will be able to help you unless I can see the what is
happening.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"comet61" <comet61@.discussions.microsoft.com> wrote in message
news:7DB3BF3E-AB80-4ED7-BAA7-925ADDCFB351@.microsoft.com...
> The client is trying to download a matrix style report into a pdf. They
> have
> Adobe 6 Professional. The report is around 150 pages and 800 Kb.
> We are able to download via Adobe 6 reader, but have numerous formatting
> problems within.
> "Bruce Johnson [MSFT]" wrote:
>> Please supply more information about what you are seeing, such as, error
>> messages, reproduction steps, etc.
>> --
>> Bruce Johnson [MSFT]
>> Microsoft SQL Server Reporting Services
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "comet61" <comet61@.discussions.microsoft.com> wrote in message
>> news:22E13F24-ECA7-4A08-8194-E7A1318122B6@.microsoft.com...
>> > Hello - I have a client that is exporting to PDF and the export fails.
>> > I
>> > have seen other posts running into the same problem, something to do
>> > with
>> > PDF
>> > 6 writer. Does Microsoft have a workaround or an update to this?
>> >
>> > Thanks in advance.
>>|||I sent the file to your account. Let me know what you find out.
"Bruce Johnson [MSFT]" wrote:
> Can you send me, directly to me, some screen shots or the PDF that
> demonstrates the problem.
> I don't think I will be able to help you unless I can see the what is
> happening.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "comet61" <comet61@.discussions.microsoft.com> wrote in message
> news:7DB3BF3E-AB80-4ED7-BAA7-925ADDCFB351@.microsoft.com...
> > The client is trying to download a matrix style report into a pdf. They
> > have
> > Adobe 6 Professional. The report is around 150 pages and 800 Kb.
> >
> > We are able to download via Adobe 6 reader, but have numerous formatting
> > problems within.
> >
> > "Bruce Johnson [MSFT]" wrote:
> >
> >> Please supply more information about what you are seeing, such as, error
> >> messages, reproduction steps, etc.
> >>
> >> --
> >> Bruce Johnson [MSFT]
> >> Microsoft SQL Server Reporting Services
> >>
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "comet61" <comet61@.discussions.microsoft.com> wrote in message
> >> news:22E13F24-ECA7-4A08-8194-E7A1318122B6@.microsoft.com...
> >> > Hello - I have a client that is exporting to PDF and the export fails.
> >> > I
> >> > have seen other posts running into the same problem, something to do
> >> > with
> >> > PDF
> >> > 6 writer. Does Microsoft have a workaround or an update to this?
> >> >
> >> > Thanks in advance.
> >>
> >>
> >>
>
>|||this is a known microsoft bug is what i found out
"comet61" wrote:
> I sent the file to your account. Let me know what you find out.
> "Bruce Johnson [MSFT]" wrote:
> > Can you send me, directly to me, some screen shots or the PDF that
> > demonstrates the problem.
> > I don't think I will be able to help you unless I can see the what is
> > happening.
> >
> > --
> > Bruce Johnson [MSFT]
> > Microsoft SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "comet61" <comet61@.discussions.microsoft.com> wrote in message
> > news:7DB3BF3E-AB80-4ED7-BAA7-925ADDCFB351@.microsoft.com...
> > > The client is trying to download a matrix style report into a pdf. They
> > > have
> > > Adobe 6 Professional. The report is around 150 pages and 800 Kb.
> > >
> > > We are able to download via Adobe 6 reader, but have numerous formatting
> > > problems within.
> > >
> > > "Bruce Johnson [MSFT]" wrote:
> > >
> > >> Please supply more information about what you are seeing, such as, error
> > >> messages, reproduction steps, etc.
> > >>
> > >> --
> > >> Bruce Johnson [MSFT]
> > >> Microsoft SQL Server Reporting Services
> > >>
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >>
> > >> "comet61" <comet61@.discussions.microsoft.com> wrote in message
> > >> news:22E13F24-ECA7-4A08-8194-E7A1318122B6@.microsoft.com...
> > >> > Hello - I have a client that is exporting to PDF and the export fails.
> > >> > I
> > >> > have seen other posts running into the same problem, something to do
> > >> > with
> > >> > PDF
> > >> > 6 writer. Does Microsoft have a workaround or an update to this?
> > >> >
> > >> > Thanks in advance.
> > >>
> > >>
> > >>
> >
> >
> >

Exporting to HTML

Hi!
My client wants to send reports as emails. They don't want' PDF
attachement. HTML seem to be the best way for that.
I'm using Microsoft.Reporting.WinForms
and
LocalReport.Render
I can't seem to find any other formats then Excel or PDF. But
Microsoft reporting does reports for web as well. Is there any way to
get HTML out of local report?
Thanks!This is exactly problem I'm having:
http://msmvps.com/blogs/theproblemsolver/archive/2006/07/19/105216.aspx

Exporting to Excel Office 2000 using SQL Server Reporting Services

Hi,
Is there any workaround to make it compatible with Excel Office 2000 becuase
we have Excel Office 2000 installed on the client machine.
Please let us know if anybody has a solution for this issue.
Thank You,Install Reporting Services SP1
"Shridhar" <Shridhar@.discussions.microsoft.com> wrote in message
news:A3A5CB50-2E93-464C-9D76-3CA6EFB55212@.microsoft.com...
> Hi,
> Is there any workaround to make it compatible with Excel Office 2000
becuase
> we have Excel Office 2000 installed on the client machine.
> Please let us know if anybody has a solution for this issue.
> Thank You,
>

Exporting TEXT Field into CSV file

I have a record set I have to export on a weekly basis into a CSV file for a customer/client. One of the fields being included in the export is a TEXT field. When I export this field, the CSV file is truncating the record significantly.

Is there a way I can get the export to pass all the data in the TEXT field, or is this a limitation on the data transformation, or is it a limitation on the CSV file (because of the size/nature of the TEXT field).After taking a break, I tinkered around some more and got this to work with the DTS. Apparently a different result occurs if I use the DTS to save the TEXT field, as opposed to using the Query Analyzer and saving the results (which I was using for testing).