Problem with SQL server - Excel

Hi to all! I am working with SQL server 2000 and up until today, I used to import data in the Server using an Excel Spreadsheet, and the wizard. Last time today, that I tried to do that, I got the following message:

" The instruction at "0x02e21b80" referenced memory at "0x02e21b80". The memory could not be "read".

Any help, would be much appreciated! I am stuck here, and the most akward thing, is that up until today, I kept on importing data from Excel, with the same process with no problem...

Anyway, I thank everyone in advance, just for taking the time to read this thread! :DThe error you describe is a very common error that really is saying "something went wrong and I don't have a clue what to do about it". It probably won't fix if you try again, and it will probably not work if you try to restart your computer (but it might, it has happened to me). I'm assuming that this problem is related to your workstation in some way, removed dll's, uninstalled program that messed up something you needed or something similar.
To rule out possibilities, I would try to do the same thing from another computer. If that works, I'd try to reinstall Excel, and if it didn't work, I'd check out the access privileges the account uses that makes the database connection. Just some tips ... ;)|||Thanks a lot! I'll try doing these things and see what happens!

You' ve offered great help to me, cause I'm in a state of confusion at the moment and I wasn't able to think clearly!

Thanks! :)

Problem with sorting in exported Excel document

Hello. I am using Reporting Services 2000 and Microsoft Excel 2003 running on
Windows XP Professional. I have a report that contains sales information that
I am exporting to Excel. The first two lines of the report contain title
information. They span all columns of the report. For example, the first line
(let's call it Food Sales Information) spans 15 columns. After the first two
lines of title information, there is a line containing the names of the
columns. After that, I have a lot of lines containing the sales data. I
export this to Excel. When I click in one of the numeric columns and click
the "A->Z" (sort ascending) button, I get the following error:
"This operation requires the merged cells to be identically sized."
Clciking Show Help gives me the following detail:
"This error only appears if you attempted to sort a range of previously
merged cells, but not all cells in the sort range were merged or are not of
the same size.
To avoid this behavior, unmerge all the merged cells in the range, or merge
all the cells in the range to be the same as the largest merged cell
grouping."
I believe this error to be caused the the two header rows. When I delete the
two header rows from the exported Excel document, I do not get the error.
Is there any way around this problem? Can I get the data to sort in Excel
without removing the header? Thanks in advance for the help.For those of you with this problem in the future who find this post
through google, Teo pointed me to a blog with this very issue
addressed. The bottom line is exporting to Excel from RS2000 leaves a
lot to be desired. Here is the blog with a work-around for this
problem:
http://blogs.msdn.com/chrisbal/archive/2006/07/08/659545.aspx

Problem With RS2000 Export To Excel

We're using RS2000 and there are some reports that are having problems exporting to Excel after having been rendered.

The reports have no more than 30,000 rows, but are about 150 columns wide. The reports run (execute and redner) very quickly in Reporting Services, but when exporting, the "blank rendering window" (the one with the URL: "http://ServerName.Reportserver?ReportName&rs%3aCommand=Render&rs%3AFormat=EXCEL) is open for about half an hour, and the w3wp process pummels our 8 proc box (CPU between 50 and 90% for that time) and memory goes past 1.5 GIG (of the total 8 GIG) usage.

Sometimes we'll get a message asking the user to log in after about 10-15 minutes, after which it fails, other times it makes it to the dialog box asking if you want to open or save the spreadsheet. If it makes it to this dialog, it's OK, if not, it fails on the export. The resulting spreadsheets are only between 25 - 32 MG, not very big at all.

Are there any settings we can tweak to speed this up, or at the very least, be sure it always makes it to the Open/Save dialog?

Thanks in advance.

Anyone? This is quite a problem. Are there any setting changes to IIS or RS2000 that could help, here?

|||One last bump before I give up...any advice welcome.|||

I would suggest trying your scenario on RS 2005 SP2 and comparing the results. We did quite a bit of work in this area. You can download a trial version of SQL Server 2005 at http://www.microsoft.com/sql.

Thank you.

problem with retreving a excel data through excel source component.

Hello,

I have a problem with retreving a excel data through excel source component.

I have source component as Excel Source which will connect to my .xls sheet.

To retrieve the values from the sheet i am using a query as,

"SELECT F14,F3 FROM [Charac Defn & Assgnment$]"

The column F14 is not formatted so that the format of the cell is "General" I have a different type of values in the F14 column such as "PE","PES",15,20,20.00,8888.9999 etc..

While i click on preview button of Excel source it shows only the text values and not the int or decimal values, its returning NULL for those cells. I tried to use convert function, its throwing an error as

TITLE: Microsoft Visual Studio

There was an error displaying the preview.

ADDITIONAL INFORMATION:

Undefined function 'Convert' in expression. (Microsoft JET Database Engine)

Is there any other function to change the format of the cell or i need to some thing else

Please help me how to solve this issue.

Why don't you try formatting the cell as text in excel and then change the data type if needed in the data flow.

|||

Or try to save the file as csv file, then use flat file source to import the csv file into your ssis package.

|||

Dhivya.S wrote:

Hello,

I have a problem with retreving a excel data through excel source component.

I have source component as Excel Source which will connect to my .xls sheet.

To retrieve the values from the sheet i am using a query as,

"SELECT F14,F3 FROM [Charac Defn & Assgnment$]"

The column F14 is not formatted so that the format of the cell is "General" I have a different type of values in the F14 column such as "PE","PES",15,20,20.00,8888.9999 etc..

While i click on preview button of Excel source it shows only the text values and not the int or decimal values, its returning NULL for those cells. I tried to use convert function, its throwing an error as

TITLE: Microsoft Visual Studio

There was an error displaying the preview.

ADDITIONAL INFORMATION:

Undefined function 'Convert' in expression. (Microsoft JET Database Engine)

Is there any other function to change the format of the cell or i need to some thing else

Please help me how to solve this issue.

Hi Dhivya,

SSIS considers the majority type among your values. Since you must be having more number of string data in the column F14, it is considering it as a varchar column and thus ignoring the numeric data.

Do you really want the data to be uploaded into the destination table like this?

In this case, a single quotation (') needs to be prefixed to each numeric value so that it is considered as a string.

Please do that and it should work now.

Regards,

B@.ns