Exporting Datas to Excel File

I have a server where I have installed SQL Server.I am running a Visual
Basic Software in a Client computer.I want to execute a Sql Query which
exports all the datas of a sql server table to that client machine as a
MS-Excel file.I have done that query with MS-Access, but that's not
working with SQL Server.
Please reply meHi
The best way would be to use DTS for this if you are using SQL 2000 or SSIS
if you are using SQL 2005. You can use the Import/Export Wizard to create a
package and job that will do it for you if you don't want to start from
scratch. There is plenty of information on DTS/SSIS in books online, but
there are also additional information at http://www.sqldts.com
John
"retheeshnewage@.gmail.com" wrote:

> I have a server where I have installed SQL Server.I am running a Visual
> Basic Software in a Client computer.I want to execute a Sql Query which
> exports all the datas of a sql server table to that client machine as a
> MS-Excel file.I have done that query with MS-Access, but that's not
> working with SQL Server.
> Please reply me
>

Exporting Datas to Excel File

I have a server where I have installed SQL Server.I am running a Visual
Basic Software in a Client computer.I want to execute a Sql Query which
exports all the datas of a sql server table to that client machine as a
MS-Excel file.I have done that query with MS-Access, but that's not
working with SQL Server.
Please reply me
Hi
The best way would be to use DTS for this if you are using SQL 2000 or SSIS
if you are using SQL 2005. You can use the Import/Export Wizard to create a
package and job that will do it for you if you don't want to start from
scratch. There is plenty of information on DTS/SSIS in books online, but
there are also additional information at http://www.sqldts.com
John
"retheeshnewage@.gmail.com" wrote:

> I have a server where I have installed SQL Server.I am running a Visual
> Basic Software in a Client computer.I want to execute a Sql Query which
> exports all the datas of a sql server table to that client machine as a
> MS-Excel file.I have done that query with MS-Access, but that's not
> working with SQL Server.
> Please reply me
>

Exporting a table to a file -reg

Dear Friends,
I am having Sql Server 2005 Express Edition. Also I have installed "Sql
Server Management Studio Express".
In "Sql Server Management Studio Express", how to export a table to a csv
file, or to another table?
Thanks & Regards,
Thirumalai.Hi
Use AdventureWorks
--Import to another table
SELECT * INTO Person.Address_New FROM
Person.Address
SELECT * FROM Person.Address_New
--Import to the file
exec master..xp_cmdshell 'BCP AdventureWorks.Person.Address_New OUT
c:\test1.txt -c -C850 -SSERVER\SQLSERVERDEV2005 -Usa -Ppwd'
"Thirumalai" <thirumalai@.cspl.com> wrote in message
news:eiQpaM$SGHA.4452@.TK2MSFTNGP12.phx.gbl...
> Dear Friends,
> I am having Sql Server 2005 Express Edition. Also I have installed "Sql
> Server Management Studio Express".
> In "Sql Server Management Studio Express", how to export a table to a csv
> file, or to another table?
> Thanks & Regards,
> Thirumalai.
>
>

Export/Import ASP.NET Membership data

Greetings All,
I need to export/import the ASP.NET Membership data which is installed in my database via aspnet_regsql.exe. Does anyone have the Cliff notes on how to do this?

Thanks in advance.
Since this is just a set of standard SQL Server tables, you should be able to use any SSIS tool or technique to do this. The import/export wizard in SQL Server Management Studio should work just fine.|||That's what I was hoping, but unfortunetly that is not the case.

When I run the package created with the wizard specifying only the following tables:

aspnet_Users
aspnet_Applications
aspnet_Roles
aspnet_UsersInRoles
aspnet_Membership
aspnet_SchemaVersions

I get the following output:

Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Information: 0x402090DF at Data Flow Task, Destination 1 - aspnet_Membership [132]: The final commit for the data insertion has started.
Information: 0x402090DF at Data Flow Task, Destination 3 - aspnet_SchemaVersions [274]: The final commit for the data insertion has started.
Information: 0x402090DF at Data Flow Task, Destination - aspnet_Applications [28]: The final commit for the data insertion has started.
Information: 0x402090DF at Data Flow Task, Destination 2 - aspnet_Roles [222]: The final commit for the data insertion has started.
Information: 0x402090DF at Data Flow Task, Destination 4 - aspnet_Users [334]: The final commit for the data insertion has started.
Error: 0xC0202009 at Data Flow Task, Destination 3 - aspnet_SchemaVersions [274]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of PRIMARY KEY constraint 'PK__aspnet_SchemaVer__4316F928'. Cannot insert duplicate key in object 'dbo.aspnet_SchemaVersions'.".
Error: 0xC0202009 at Data Flow Task, Destination 2 - aspnet_Roles [222]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Ro__Appli__24E777C3". The conflict occurred in database "CommonPassDB", table "dbo.aspnet_Applications", column 'ApplicationId'.".
Information: 0x402090E0 at Data Flow Task, Destination 3 - aspnet_SchemaVersions [274]: The final commit for the data insertion has ended.
Information: 0x402090E0 at Data Flow Task, Destination 2 - aspnet_Roles [222]: The final commit for the data insertion has ended.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination 2 - aspnet_Roles" (222) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination 3 - aspnet_SchemaVersions" (274) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread2" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread3" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC0202009 at Data Flow Task, Destination - aspnet_Applications [28]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "Violation of UNIQUE KEY constraint 'UQ__aspnet_Applicati__3E52440B'. Cannot insert duplicate key in object 'dbo.aspnet_Applications'.".
Error: 0xC0202009 at Data Flow Task, Destination 4 - aspnet_Users [334]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Us__Appli__25DB9BFC". The conflict occurred in database "CommonPassDB", table "dbo.aspnet_Applications", column 'ApplicationId'.".
Information: 0x402090E0 at Data Flow Task, Destination 4 - aspnet_Users [334]: The final commit for the data insertion has ended.
Information: 0x402090E0 at Data Flow Task, Destination - aspnet_Applications [28]: The final commit for the data insertion has ended.
Error: 0xC0202009 at Data Flow Task, Destination 1 - aspnet_Membership [132]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The statement has been terminated.".
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "The INSERT statement conflicted with the FOREIGN KEY constraint "FK__aspnet_Me__Appli__178D7CA5". The conflict occurred in database "CommonPassDB", table "dbo.aspnet_Applications", column 'ApplicationId'.".
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination 4 - aspnet_Users" (334) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Information: 0x402090E0 at Data Flow Task, Destination 1 - aspnet_Membership [132]: The final commit for the data insertion has ended.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination - aspnet_Applications" (28) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread4" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "Destination 1 - aspnet_Membership" (132) failed with error code 0xC0202009. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread1" has exited with error code 0xC0202009. There may be error messages posted before this with more information on why the thread has exited.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DF at Data Flow Task, Destination 5 - aspnet_UsersInRoles [387]: The final commit for the data insertion has started.
Information: 0x402090E0 at Data Flow Task, Destination 5 - aspnet_UsersInRoles [387]: The final commit for the data insertion has ended.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination - aspnet_Applications" (28)" wrote 1 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination 1 - aspnet_Membership" (132)" wrote 1 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination 2 - aspnet_Roles" (222)" wrote 1 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination 3 - aspnet_SchemaVersions" (274)" wrote 3 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination 4 - aspnet_Users" (334)" wrote 1 rows.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination 5 - aspnet_UsersInRoles" (387)" wrote 0 rows.
Task failed: Data Flow Task
SSIS package "Package1.dtsx" finished: Failure.
The program '[5340] Package1.dtsx: DTS' has exited with code 0 (0x0).

Has anyone ever tried this before?

Thanks.
|||You need to ensure that you're running the packages in the correct order, so that the foreign key constraints aren't violated.|||The wizard creates a single package containing a single Data Flow Task. Inside the Data Flow Task is a pair of OLEDB Source and Destination Data Flow Sources. How do I control the order in which the OLEDB "pairs" execute?

Must I break each one of these out into its own Data Flow Task?
|||Yes. This default configuraion is running them in parallel; you need them to run in a specific serial order based on the FKs defined in the database, which cannot be done in a single data flow.|||Ok, thanks. That did it.

I appreciate your help.

|||Thanks for the feedback - good luck!

Export Web Archive (MHTML) not working after SP1 installed

Exporting to Web Archive (MHTML) is not working anymore after I installed
SP1. When I export to Web Archive and open the file directly IE just hangs.
When I save the file to my disk and open it from there it works. All other
formats for export work fine.
Here is a line from the report file.
w3wp!chunks!fb0!09/02/2004-11:43:28:: i INFO: ###
GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
this=88b2b869-7080-4a6f-8c92-54eed686a400
Any tips would be appreciated. Thank you.Is this on all reports or just a specific report? Does it happen on all
client machines?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Fabian" <fhanggi@.hotmail.com> wrote in message
news:ejTeS4RkEHA.2664@.TK2MSFTNGP11.phx.gbl...
> Exporting to Web Archive (MHTML) is not working anymore after I installed
> SP1. When I export to Web Archive and open the file directly IE just
> hangs.
> When I save the file to my disk and open it from there it works. All other
> formats for export work fine.
> Here is a line from the report file.
> w3wp!chunks!fb0!09/02/2004-11:43:28:: i INFO: ###
> GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
> this=88b2b869-7080-4a6f-8c92-54eed686a400
> Any tips would be appreciated. Thank you.
>|||Hi Brian. It happens for all reports on all client machines.
Thank you for looking at this.
Fabian
"Brian Welcker [MSFT]" wrote:
> Is this on all reports or just a specific report? Does it happen on all
> client machines?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Fabian" <fhanggi@.hotmail.com> wrote in message
> news:ejTeS4RkEHA.2664@.TK2MSFTNGP11.phx.gbl...
> > Exporting to Web Archive (MHTML) is not working anymore after I installed
> > SP1. When I export to Web Archive and open the file directly IE just
> > hangs.
> > When I save the file to my disk and open it from there it works. All other
> > formats for export work fine.
> >
> > Here is a line from the report file.
> >
> > w3wp!chunks!fb0!09/02/2004-11:43:28:: i INFO: ###
> > GetReportChunk('RenderingInfo_MHTML', 2), chunk was not found!
> > this=88b2b869-7080-4a6f-8c92-54eed686a400
> >
> > Any tips would be appreciated. Thank you.
> >
> >
>
>

Export to PDF stopped working after XP SP2 is installed on client's machine

Hi All
We are having a problem after XP SP2 is installed on the user's machine, the
export to PDF no longer works as instead on opening the report in PDF format
inside the browser it actually tries to save the .aspx page, I think it is
something to do with MIME types.
Has anyone noticed this issue and is there a work around.
Please help
Rahulmake sure your adobe reader is installed properly. we had this problem
to, and it turned out that adobe installation had not been completed.
This was only a problem with the new adobe 6.2, 6.0 was fine.
"Rahul Agarwal" <agarwal_rahul@.hotmail.com> wrote in message news:<#R7F9aOpEHA.324@.TK2MSFTNGP11.phx.gbl>...
> Hi All
> We are having a problem after XP SP2 is installed on the user's machine, the
> export to PDF no longer works as instead on opening the report in PDF format
> inside the browser it actually tries to save the .aspx page, I think it is
> something to do with MIME types.
> Has anyone noticed this issue and is there a work around.
> Please help
> Rahul

Export to pdf issue

I have a report with 3 of 9 barcode font. When the report is rendered on pdf
format the font is not a barcode. The font is installed on the web server,
report server, and the client machine. Has anyone been able to solve this?
Thanks.I have the same exact issue with the same barcode font. When the report is
rendered as HTML, I can see the barcode fine, but the minute I export it to
PDF, I lose the barcode...
"Phill" wrote:
> I have a report with 3 of 9 barcode font. When the report is rendered on pdf
> format the font is not a barcode. The font is installed on the web server,
> report server, and the client machine. Has anyone been able to solve this?
> Thanks.|||Reporting Service does not embed font into PDF. You need other
solutons (like Crystal Reports).

Export to Excel. Version Problem

when I try to eport a report in EXCEL format it only works on client with
EXCEL XP installed. With EXCEL 2000 it dosn't work correctly.
Anyone knows if there are EXCEL version Requirements'
ThenksYes, it only works with Office XP or above and will not work in Office 2000.
Cheers
"Ale Dori" wrote:
> when I try to eport a report in EXCEL format it only works on client with
> EXCEL XP installed. With EXCEL 2000 it dosn't work correctly.
> Anyone knows if there are EXCEL version Requirements'
> Thenks|||Excel 2000 works after installing RS SP1.
"Ale Dori" <AleDori@.discussions.microsoft.com> wrote in message
news:BBCBE66F-6F04-42EB-B461-B74F0C537BB3@.microsoft.com...
> when I try to eport a report in EXCEL format it only works on client with
> EXCEL XP installed. With EXCEL 2000 it dosn't work correctly.
> Anyone knows if there are EXCEL version Requirements'
> Thenks

export to excel, file not found

With sp1 installed, when a user exports a chart to excel via url
(ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this up
as a link on the report) everything works when the user has office xp
installed, but with office 2000, the user can only use the save as feature,
and then open the excel rendered chart. If the user selects "open" from the
dialog prompt, they get an error:
C:\Documents and Settings\User\Local Settings\Temporary Internet
Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
spelling of the name ...
Is this the result of a browser setting, or server security on my end?
Thanks for any help.Have you installed Reporting Services SP1 on the server? This is required
for Office 2000 support.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"JeffW" <JeffW@.discussions.microsoft.com> wrote in message
news:396BF27F-0526-43BC-BB78-D59DDE5B6058@.microsoft.com...
> With sp1 installed, when a user exports a chart to excel via url
> (ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this
> up
> as a link on the report) everything works when the user has office xp
> installed, but with office 2000, the user can only use the save as
> feature,
> and then open the excel rendered chart. If the user selects "open" from
> the
> dialog prompt, they get an error:
> C:\Documents and Settings\User\Local Settings\Temporary Internet
> Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
> spelling of the name ...
> Is this the result of a browser setting, or server security on my end?
> Thanks for any help.|||Brian,
Thanks for your reply.
I have installed sp1 on the server, and verified that both my dev
environment and server are running version 8.00.878.00. Also, the excel
export does work, when the user chooses to save the file and then open it
(office 2000). It only fails when they try to open the exported chart
directly from the dialog that says "You are downloading the file ... Would
you like to open the file or save it to your computer ...". And it only
happens when to office 2000 or less users.
After installing sp1 on the server, I did not reboot or anything, but
confirmed that the version matched my dev environment that also has sp1.
Should I create the report from scratch or are there files/timestamps I
should be looking for on the server related to the renderer/exporter?
Thanks,
JeffW
"Brian Welcker [MSFT]" wrote:
> Have you installed Reporting Services SP1 on the server? This is required
> for Office 2000 support.
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "JeffW" <JeffW@.discussions.microsoft.com> wrote in message
> news:396BF27F-0526-43BC-BB78-D59DDE5B6058@.microsoft.com...
> > With sp1 installed, when a user exports a chart to excel via url
> > (ReportServerUrl/MyReport&rs:Command=Render&rs:Format=EXCEL ... I set this
> > up
> > as a link on the report) everything works when the user has office xp
> > installed, but with office 2000, the user can only use the save as
> > feature,
> > and then open the excel rendered chart. If the user selects "open" from
> > the
> > dialog prompt, they get an error:
> >
> > C:\Documents and Settings\User\Local Settings\Temporary Internet
> > Files\Content.IE5\KJYHDDL\Chart[1].xls Could not be found. Check the
> > spelling of the name ...
> >
> > Is this the result of a browser setting, or server security on my end?
> >
> > Thanks for any help.
>
>

Export to Excel 2000 format with Reporting services 2000 SP1

Hi,
I am clueless on how to generate the report in Excel 2000 format. i have
installed reporting services 2000 with service pack 2 in this machine. the
resultant Excel file format is in version 2003. i cant view that in Excel
2000. your feedback is highly appreciated.
Following is my code,
string report = m_ReportNameEXCEL;
string path = m_TargetReportLocation + report;
Byte[] bytes;
string format = "EXCEL";
string historyid = null;
string deviceInfo = null;
ReportServer.ParameterValue[] parameters;
DataSourceCredentials[] credentials = null;
string showhide = null;
string encoding = null;
string mimetype = null;
ParameterValue[] parameterused = null;
Warning[] warnings = null;
string[] streamIDs = null;
-
-
-
bytes = reportService.Render(
path,
format,
historyid,
deviceInfo,
parameters,
credentials,
showhide,
out encoding,
out mimetype,
out parameterused,
out warnings,
out streamIDs);
FileStream fs = File.Create(m_OutputPath + iYear.ToString()+ @."\" +
fileName);
fs.Write(bytes,0,bytes.Length);
fs.Close();
}
Thanks,
PradeepI have just looked it up in a Book. Only Excel 2002 or 2003 is supported. The
Data is rendered into MTHML with Mime Type ms-excel internally and brought to
Excel after that.
BUT: I am also using EXCEL 2000 on my machine and the exported Reports can
be opened without problems... (I have to say that I had Office 2003 on it
before, uninstalled it and installed OIffice 2000, God knows if there are any
DLLs left...?)
Maybe you are using anything inside your Report that needs a newer version?
Did you try a very simple Report?
There is the possibility to create your ow new Export formats. To do this
you have to program a File Rendering Extension. This is quite complex to
realize. You should get a good book to realize that.
Markus Poehler
netpoint-edv gmbh
"msnews.microsoft.com" wrote:
> Hi,
> I am clueless on how to generate the report in Excel 2000 format. i have
> installed reporting services 2000 with service pack 2 in this machine. the
> resultant Excel file format is in version 2003. i cant view that in Excel
> 2000. your feedback is highly appreciated.
> Following is my code,
> string report = m_ReportNameEXCEL;
> string path = m_TargetReportLocation + report;
> Byte[] bytes;
> string format = "EXCEL";
> string historyid = null;
> string deviceInfo = null;
> ReportServer.ParameterValue[] parameters;
> DataSourceCredentials[] credentials = null;
> string showhide = null;
> string encoding = null;
> string mimetype = null;
> ParameterValue[] parameterused = null;
> Warning[] warnings = null;
> string[] streamIDs = null;
> -
> -
> -
>
> bytes = reportService.Render(
> path,
> format,
> historyid,
> deviceInfo,
> parameters,
> credentials,
> showhide,
> out encoding,
> out mimetype,
> out parameterused,
> out warnings,
> out streamIDs);
>
> FileStream fs = File.Create(m_OutputPath + iYear.ToString()+ @."\" +
> fileName);
> fs.Write(bytes,0,bytes.Length);
> fs.Close();
> }
>
> Thanks,
> Pradeep
>
>|||SP1 and greater definitely creates native Excel format (that can be opened
in Excel 2000). To make sure the problem isn't your code, open up a report
in report manager and export it to Excel and see if you can open in Excel
2000. Note that when you upgrade to SP1 or SP2 it is both a report designer
upgrade and a RS server upgrade.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MarkusPoehler" <MarkusPoehler@.discussions.microsoft.com> wrote in message
news:BB9415C5-7400-4C88-9001-5964112E55EC@.microsoft.com...
>I have just looked it up in a Book. Only Excel 2002 or 2003 is supported.
>The
> Data is rendered into MTHML with Mime Type ms-excel internally and brought
> to
> Excel after that.
> BUT: I am also using EXCEL 2000 on my machine and the exported Reports can
> be opened without problems... (I have to say that I had Office 2003 on it
> before, uninstalled it and installed OIffice 2000, God knows if there are
> any
> DLLs left...?)
> Maybe you are using anything inside your Report that needs a newer
> version?
> Did you try a very simple Report?
> There is the possibility to create your ow new Export formats. To do this
> you have to program a File Rendering Extension. This is quite complex to
> realize. You should get a good book to realize that.
> Markus Poehler
> netpoint-edv gmbh
> "msnews.microsoft.com" wrote:
>> Hi,
>> I am clueless on how to generate the report in Excel 2000 format. i have
>> installed reporting services 2000 with service pack 2 in this machine.
>> the
>> resultant Excel file format is in version 2003. i cant view that in Excel
>> 2000. your feedback is highly appreciated.
>> Following is my code,
>> string report = m_ReportNameEXCEL;
>> string path = m_TargetReportLocation + report;
>> Byte[] bytes;
>> string format = "EXCEL";
>> string historyid = null;
>> string deviceInfo = null;
>> ReportServer.ParameterValue[] parameters;
>> DataSourceCredentials[] credentials = null;
>> string showhide = null;
>> string encoding = null;
>> string mimetype = null;
>> ParameterValue[] parameterused = null;
>> Warning[] warnings = null;
>> string[] streamIDs = null;
>> -
>> -
>> -
>>
>> bytes = reportService.Render(
>> path,
>> format,
>> historyid,
>> deviceInfo,
>> parameters,
>> credentials,
>> showhide,
>> out encoding,
>> out mimetype,
>> out parameterused,
>> out warnings,
>> out streamIDs);
>>
>> FileStream fs = File.Create(m_OutputPath + iYear.ToString()+ @."\" +
>> fileName);
>> fs.Write(bytes,0,bytes.Length);
>> fs.Close();
>> }
>>
>> Thanks,
>> Pradeep
>>

Export table from SQL 2000 to SQL 2005

Hi, I have just installed SQL 2005 and I started moving my tables from one server (SQL 2000) to the new one (SQL 2005). I noticed when I use the import option (SQL 2005) it does not create indexes, pk, and do not create columns as identity. In this case I decided to script all objects and create them in 2005 what should be fine. After that I use the same import to move data from 2000 to 2005 when it show the data mapping screen if I do not click on edit and check the option "Enable Identity Insert" it will fail for tables where I have identity columns. Is there a fast way to move tables from 2000 to 2005 with data ? Also, a fast way to move just data from 2000 to 2005 and do not have to check "Enable Identity Insert" for each table. Could I apply this option to all tables ? I appreciate if someone could help me. Thanks, VSThe easiest thing is to create a database backup on SQL 2000 and restore it to SQL 2005.