Tuesday, March 27, 2012
Cursor is not open
I have a SQL query that open a cursor, the query running well on SQL 2000
query analyser but give me an error message "Cursor is not open" on SQL 2005
management studio.
the query running on the same database, same server (compatibilty level: SQL
2000 (80)).
any help ?
Hi
Can you post the source to be tested?
"Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
news:uUZ4gh8tHHA.4488@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I have a SQL query that open a cursor, the query running well on SQL 2000
> query analyser but give me an error message "Cursor is not open" on SQL
> 2005 management studio.
> the query running on the same database, same server (compatibilty level:
> SQL 2000 (80)).
> any help ?
>
|||select ID,AutoID
into #Duplo
from Table1,
(select ID,count(id) as T
from Table1
where StoreID= xx
group by id
having count(id)>1) as M1
where Table1.ID=M1.ID
order by Table1.ID,Table1.AutoID
declare @.PrevID int,@.ID int,@.RecautoID int
DECLARE Table1_Cursor CURSOR dynamic FOR
select ID,AutoID
from #Duplo
for update
OPEN Table1_Cursor
FETCH FIRST FROM Table1_Cursor into @.PrevID,@.RecAutoID
FETCH NEXT FROM Table1_Cursor into @.ID,@.RecAutoID
WHILE @.@.FETCH_STATUS = 0
BEGIN
if @.PrevID=@.ID
begin
delete Table1 WHERE AutoID=@.RecAutoID
FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
end
else
begin
set @.PrevID=@.ID
FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
end
END
CLOSE Table1_Cursor
DEALLOCATE Table1_Cursor
GO
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:efTJvq8tHHA.4844@.TK2MSFTNGP04.phx.gbl...
> Hi
> Can you post the source to be tested?
>
>
> "Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
> news:uUZ4gh8tHHA.4488@.TK2MSFTNGP05.phx.gbl...
>
|||Hi
I could not reproduce the problem. What if you execute first SELECT *INTO
... command and then run a cursor, do you still have an error?
"Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
news:%23tgZFy8tHHA.3400@.TK2MSFTNGP03.phx.gbl...
> select ID,AutoID
> into #Duplo
> from Table1,
> (select ID,count(id) as T
> from Table1
> where StoreID= xx
> group by id
> having count(id)>1) as M1
> where Table1.ID=M1.ID
> order by Table1.ID,Table1.AutoID
> declare @.PrevID int,@.ID int,@.RecautoID int
> DECLARE Table1_Cursor CURSOR dynamic FOR
> select ID,AutoID
> from #Duplo
> for update
> OPEN Table1_Cursor
> FETCH FIRST FROM Table1_Cursor into @.PrevID,@.RecAutoID
> FETCH NEXT FROM Table1_Cursor into @.ID,@.RecAutoID
> WHILE @.@.FETCH_STATUS = 0
> BEGIN
> if @.PrevID=@.ID
> begin
> delete Table1 WHERE AutoID=@.RecAutoID
> FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
> end
> else
> begin
> set @.PrevID=@.ID
> FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
> end
> END
> CLOSE Table1_Cursor
> DEALLOCATE Table1_Cursor
> GO
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:efTJvq8tHHA.4844@.TK2MSFTNGP04.phx.gbl...
>
|||do you mean SELECT * instead of SELECT ID,AUTOID only to be replaced or what
?
my problem is why it is working on SQL 2000 query analyzer only ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O7LSkG9tHHA.4916@.TK2MSFTNGP05.phx.gbl...
> Hi
> I could not reproduce the problem. What if you execute first SELECT *INTO
> ... command and then run a cursor, do you still have an error?
>
>
> "Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
> news:%23tgZFy8tHHA.3400@.TK2MSFTNGP03.phx.gbl...
>
|||Hi
No it is OK SELECT ID,AUTOID as well
"Mahmoud Amin" <mm.amin@.gmail.com> wrote in message
news:eKTJMY9tHHA.1768@.TK2MSFTNGP04.phx.gbl...
> do you mean SELECT * instead of SELECT ID,AUTOID only to be replaced or
> what ?
> my problem is why it is working on SQL 2000 query analyzer only ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O7LSkG9tHHA.4916@.TK2MSFTNGP05.phx.gbl...
>
Cursor is not open
I have a SQL query that open a cursor, the query running well on SQL 2000
query analyser but give me an error message "Cursor is not open" on SQL 2005
management studio.
the query running on the same database, same server (compatibilty level: SQL
2000 (80)).
any help ?Hi
Can you post the source to be tested?
"Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
news:uUZ4gh8tHHA.4488@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I have a SQL query that open a cursor, the query running well on SQL 2000
> query analyser but give me an error message "Cursor is not open" on SQL
> 2005 management studio.
> the query running on the same database, same server (compatibilty level:
> SQL 2000 (80)).
> any help ?
>|||select ID,AutoID
into #Duplo
from Table1,
(select ID,count(id) as T
from Table1
where StoreID= xx
group by id
having count(id)>1) as M1
where Table1.ID=M1.ID
order by Table1.ID,Table1.AutoID
declare @.PrevID int,@.ID int,@.RecautoID int
DECLARE Table1_Cursor CURSOR dynamic FOR
select ID,AutoID
from #Duplo
for update
OPEN Table1_Cursor
FETCH FIRST FROM Table1_Cursor into @.PrevID,@.RecAutoID
FETCH NEXT FROM Table1_Cursor into @.ID,@.RecAutoID
WHILE @.@.FETCH_STATUS = 0
BEGIN
if @.PrevID=@.ID
begin
delete Table1 WHERE AutoID=@.RecAutoID
FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
end
else
begin
set @.PrevID=@.ID
FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
end
END
CLOSE Table1_Cursor
DEALLOCATE Table1_Cursor
GO
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:efTJvq8tHHA.4844@.TK2MSFTNGP04.phx.gbl...
> Hi
> Can you post the source to be tested?
>
>
> "Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
> news:uUZ4gh8tHHA.4488@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I have a SQL query that open a cursor, the query running well on SQL 2000
>> query analyser but give me an error message "Cursor is not open" on SQL
>> 2005 management studio.
>> the query running on the same database, same server (compatibilty level:
>> SQL 2000 (80)).
>> any help ?
>|||Hi
I could not reproduce the problem. What if you execute first SELECT *INTO
... command and then run a cursor, do you still have an error?
"Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
news:%23tgZFy8tHHA.3400@.TK2MSFTNGP03.phx.gbl...
> select ID,AutoID
> into #Duplo
> from Table1,
> (select ID,count(id) as T
> from Table1
> where StoreID= xx
> group by id
> having count(id)>1) as M1
> where Table1.ID=M1.ID
> order by Table1.ID,Table1.AutoID
> declare @.PrevID int,@.ID int,@.RecautoID int
> DECLARE Table1_Cursor CURSOR dynamic FOR
> select ID,AutoID
> from #Duplo
> for update
> OPEN Table1_Cursor
> FETCH FIRST FROM Table1_Cursor into @.PrevID,@.RecAutoID
> FETCH NEXT FROM Table1_Cursor into @.ID,@.RecAutoID
> WHILE @.@.FETCH_STATUS = 0
> BEGIN
> if @.PrevID=@.ID
> begin
> delete Table1 WHERE AutoID=@.RecAutoID
> FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
> end
> else
> begin
> set @.PrevID=@.ID
> FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
> end
> END
> CLOSE Table1_Cursor
> DEALLOCATE Table1_Cursor
> GO
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:efTJvq8tHHA.4844@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Can you post the source to be tested?
>>
>>
>> "Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
>> news:uUZ4gh8tHHA.4488@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I have a SQL query that open a cursor, the query running well on SQL
>> 2000 query analyser but give me an error message "Cursor is not open" on
>> SQL 2005 management studio.
>> the query running on the same database, same server (compatibilty level:
>> SQL 2000 (80)).
>> any help ?
>>
>|||do you mean SELECT * instead of SELECT ID,AUTOID only to be replaced or what
?
my problem is why it is working on SQL 2000 query analyzer only ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O7LSkG9tHHA.4916@.TK2MSFTNGP05.phx.gbl...
> Hi
> I could not reproduce the problem. What if you execute first SELECT *INTO
> ... command and then run a cursor, do you still have an error?
>
>
> "Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
> news:%23tgZFy8tHHA.3400@.TK2MSFTNGP03.phx.gbl...
>> select ID,AutoID
>> into #Duplo
>> from Table1,
>> (select ID,count(id) as T
>> from Table1
>> where StoreID= xx
>> group by id
>> having count(id)>1) as M1
>> where Table1.ID=M1.ID
>> order by Table1.ID,Table1.AutoID
>> declare @.PrevID int,@.ID int,@.RecautoID int
>> DECLARE Table1_Cursor CURSOR dynamic FOR
>> select ID,AutoID
>> from #Duplo
>> for update
>> OPEN Table1_Cursor
>> FETCH FIRST FROM Table1_Cursor into @.PrevID,@.RecAutoID
>> FETCH NEXT FROM Table1_Cursor into @.ID,@.RecAutoID
>> WHILE @.@.FETCH_STATUS = 0
>> BEGIN
>> if @.PrevID=@.ID
>> begin
>> delete Table1 WHERE AutoID=@.RecAutoID
>> FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
>> end
>> else
>> begin
>> set @.PrevID=@.ID
>> FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
>> end
>> END
>> CLOSE Table1_Cursor
>> DEALLOCATE Table1_Cursor
>> GO
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:efTJvq8tHHA.4844@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Can you post the source to be tested?
>>
>>
>> "Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
>> news:uUZ4gh8tHHA.4488@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I have a SQL query that open a cursor, the query running well on SQL
>> 2000 query analyser but give me an error message "Cursor is not open"
>> on SQL 2005 management studio.
>> the query running on the same database, same server (compatibilty
>> level: SQL 2000 (80)).
>> any help ?
>>
>>
>|||Hi
No it is OK SELECT ID,AUTOID as well
"Mahmoud Amin" <mm.amin@.gmail.com> wrote in message
news:eKTJMY9tHHA.1768@.TK2MSFTNGP04.phx.gbl...
> do you mean SELECT * instead of SELECT ID,AUTOID only to be replaced or
> what ?
> my problem is why it is working on SQL 2000 query analyzer only ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O7LSkG9tHHA.4916@.TK2MSFTNGP05.phx.gbl...
>> Hi
>> I could not reproduce the problem. What if you execute first SELECT *INTO
>> ... command and then run a cursor, do you still have an error?
>>
>>
>> "Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
>> news:%23tgZFy8tHHA.3400@.TK2MSFTNGP03.phx.gbl...
>> select ID,AutoID
>> into #Duplo
>> from Table1,
>> (select ID,count(id) as T
>> from Table1
>> where StoreID= xx
>> group by id
>> having count(id)>1) as M1
>> where Table1.ID=M1.ID
>> order by Table1.ID,Table1.AutoID
>> declare @.PrevID int,@.ID int,@.RecautoID int
>> DECLARE Table1_Cursor CURSOR dynamic FOR
>> select ID,AutoID
>> from #Duplo
>> for update
>> OPEN Table1_Cursor
>> FETCH FIRST FROM Table1_Cursor into @.PrevID,@.RecAutoID
>> FETCH NEXT FROM Table1_Cursor into @.ID,@.RecAutoID
>> WHILE @.@.FETCH_STATUS = 0
>> BEGIN
>> if @.PrevID=@.ID
>> begin
>> delete Table1 WHERE AutoID=@.RecAutoID
>> FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
>> end
>> else
>> begin
>> set @.PrevID=@.ID
>> FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
>> end
>> END
>> CLOSE Table1_Cursor
>> DEALLOCATE Table1_Cursor
>> GO
>>
>> "Uri Dimant" <urid@.iscar.co.il> wrote in message
>> news:efTJvq8tHHA.4844@.TK2MSFTNGP04.phx.gbl...
>> Hi
>> Can you post the source to be tested?
>>
>>
>> "Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
>> news:uUZ4gh8tHHA.4488@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I have a SQL query that open a cursor, the query running well on SQL
>> 2000 query analyser but give me an error message "Cursor is not open"
>> on SQL 2005 management studio.
>> the query running on the same database, same server (compatibilty
>> level: SQL 2000 (80)).
>> any help ?
>>
>>
>>
>
Cursor is not open
I have a SQL query that open a cursor, the query running well on SQL 2000
query analyser but give me an error message "Cursor is not open" on SQL 2005
management studio.
the query running on the same database, same server (compatibilty level: SQL
2000 (80)).
any help ?Hi
Can you post the source to be tested?
"Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
news:uUZ4gh8tHHA.4488@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I have a SQL query that open a cursor, the query running well on SQL 2000
> query analyser but give me an error message "Cursor is not open" on SQL
> 2005 management studio.
> the query running on the same database, same server (compatibilty level:
> SQL 2000 (80)).
> any help ?
>|||select ID,AutoID
into #Duplo
from Table1,
(select ID,count(id) as T
from Table1
where StoreID= xx
group by id
having count(id)>1) as M1
where Table1.ID=M1.ID
order by Table1.ID,Table1.AutoID
declare @.PrevID int,@.ID int,@.RecautoID int
DECLARE Table1_Cursor CURSOR dynamic FOR
select ID,AutoID
from #Duplo
for update
OPEN Table1_Cursor
FETCH FIRST FROM Table1_Cursor into @.PrevID,@.RecAutoID
FETCH NEXT FROM Table1_Cursor into @.ID,@.RecAutoID
WHILE @.@.FETCH_STATUS = 0
BEGIN
if @.PrevID=@.ID
begin
delete Table1 WHERE AutoID=@.RecAutoID
FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
end
else
begin
set @.PrevID=@.ID
FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
end
END
CLOSE Table1_Cursor
DEALLOCATE Table1_Cursor
GO
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:efTJvq8tHHA.4844@.TK2MSFTNGP04.phx.gbl...
> Hi
> Can you post the source to be tested?
>
>
> "Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
> news:uUZ4gh8tHHA.4488@.TK2MSFTNGP05.phx.gbl...
>|||Hi
I could not reproduce the problem. What if you execute first SELECT *INTO
... command and then run a cursor, do you still have an error?
"Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
news:%23tgZFy8tHHA.3400@.TK2MSFTNGP03.phx.gbl...
> select ID,AutoID
> into #Duplo
> from Table1,
> (select ID,count(id) as T
> from Table1
> where StoreID= xx
> group by id
> having count(id)>1) as M1
> where Table1.ID=M1.ID
> order by Table1.ID,Table1.AutoID
> declare @.PrevID int,@.ID int,@.RecautoID int
> DECLARE Table1_Cursor CURSOR dynamic FOR
> select ID,AutoID
> from #Duplo
> for update
> OPEN Table1_Cursor
> FETCH FIRST FROM Table1_Cursor into @.PrevID,@.RecAutoID
> FETCH NEXT FROM Table1_Cursor into @.ID,@.RecAutoID
> WHILE @.@.FETCH_STATUS = 0
> BEGIN
> if @.PrevID=@.ID
> begin
> delete Table1 WHERE AutoID=@.RecAutoID
> FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
> end
> else
> begin
> set @.PrevID=@.ID
> FETCH next FROM Table1_Cursor into @.ID,@.RecAutoID
> end
> END
> CLOSE Table1_Cursor
> DEALLOCATE Table1_Cursor
> GO
>
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:efTJvq8tHHA.4844@.TK2MSFTNGP04.phx.gbl...
>|||do you mean SELECT * instead of SELECT ID,AUTOID only to be replaced or what
?
my problem is why it is working on SQL 2000 query analyzer only ?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:O7LSkG9tHHA.4916@.TK2MSFTNGP05.phx.gbl...
> Hi
> I could not reproduce the problem. What if you execute first SELECT *INTO
> ... command and then run a cursor, do you still have an error?
>
>
> "Mahmoud Amin" <m_amin33@.hotmail.com> wrote in message
> news:%23tgZFy8tHHA.3400@.TK2MSFTNGP03.phx.gbl...
>|||Hi
No it is OK SELECT ID,AUTOID as well
"Mahmoud Amin" <mm.amin@.gmail.com> wrote in message
news:eKTJMY9tHHA.1768@.TK2MSFTNGP04.phx.gbl...
> do you mean SELECT * instead of SELECT ID,AUTOID only to be replaced or
> what ?
> my problem is why it is working on SQL 2000 query analyzer only ?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:O7LSkG9tHHA.4916@.TK2MSFTNGP05.phx.gbl...
>
Monday, March 19, 2012
Current Activity - Host Question
--=_NextPart_000_0006_01C52627.EE921BE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
When looking at the Current Activity screen in EM, why is that the Host = computer is displayed in some cases & not present in others? For example, I have one generic report user, and in some cases I see the = server name they are connecting to the sql server from and in other = cases I don't. Doesn't appear to be any rhyme or reason. Is some = setting not properly set?
Any direction on helping me understand this will be appreciated.
--=_NextPart_000_0006_01C52627.EE921BE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
When looking at the = Current Activity screen in EM, why is that the Host computer is displayed in = some cases & not present in others?
For example, I = have one generic report user, and in some cases I see the server name they are = connecting to the sql server from and in other cases I don't. Doesn't appear = to be any rhyme or reason. Is some setting not properly = set?
Any direction on = helping me understand this will be appreciated.
--=_NextPart_000_0006_01C52627.EE921BE0--The setting is done from the client application (in the connection string). Perhaps the app doesn't
set it properly?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"JLS" <jlshoop@.hotmail.com> wrote in message news:%23CcqYHlJFHA.656@.TK2MSFTNGP14.phx.gbl...
When looking at the Current Activity screen in EM, why is that the Host computer is displayed in
some cases & not present in others?
For example, I have one generic report user, and in some cases I see the server name they are
connecting to the sql server from and in other cases I don't. Doesn't appear to be any rhyme or
reason. Is some setting not properly set?
Any direction on helping me understand this will be appreciated.|||This is a multi-part message in MIME format.
--=_NextPart_000_00AE_01C5262A.B5A21F30
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
It depends on the client. Some client libraries and versions grab the =name field automatically. Others wait for the application to populate =it. ADO.Net does populate the machine name automatically.
-- Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"JLS" <jlshoop@.hotmail.com> wrote in message =news:%23CcqYHlJFHA.656@.TK2MSFTNGP14.phx.gbl...
When looking at the Current Activity screen in EM, why is that the =Host computer is displayed in some cases & not present in others? For example, I have one generic report user, and in some cases I see =the server name they are connecting to the sql server from and in other =cases I don't. Doesn't appear to be any rhyme or reason. Is some =setting not properly set?
Any direction on helping me understand this will be appreciated.
--=_NextPart_000_00AE_01C5262A.B5A21F30
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
It depends on the client. Some =client libraries and versions grab the name field automatically. Others =wait for the application to populate it. ADO.Net does populate the machine =name automatically.
-- Geoff N. HitenMicrosoft SQL Server MVPSenior =Database AdministratorCareerbuilder.com
I support the Professional Association for SQL Serverhttp://www.sqlpass.org">www.sqlpass.org
"JLS"
When looking at the =Current Activity screen in EM, why is that the Host computer is displayed in =some cases & not present in others?
For example, I =have one generic report user, and in some cases I see the server name they are connecting to the sql server from and in other cases I don't. =Doesn't appear to be any rhyme or reason. Is some setting not properly set?
Any direction on =helping me understand this will be =appreciated.
--=_NextPart_000_00AE_01C5262A.B5A21F30--|||Geoff & Tibor,
Thank you for this information, now I know in which direction to begin.
Thanx!
Wednesday, March 7, 2012
Cube Processing Error
I am trying to Process a analysis server Cube and I am getting an error message saying
syntax error converting the varchar value A.H to column of type int.; 22018.
Can somebody tell me how to remove this error.
Thanks,
PraveenClean up the data? It is telling you that you are trying to convert a string that contains "A.H" to an int, and not even my creative interpretations of literals can manage that feat!
-PatP|||Thanks for the reply.Its solved now.
Friday, February 17, 2012
CSV file saved as an Excel file - error message
I hope someone can help me with this - I started receiving this error message in the past month or so when I open a csv report and save it as an Excel file in a folder I use on my VPN and in My Documents. It does not show up when I save it to my Desk Top.
I have Microsoft Office Student and Teacher and Office XP Professional installed on my notebook. I tried to uninstall Office XP and it would not let me. Something about a "patch could not be opened......"
The error message is as follows:
Header: .NET-BroadcastEventWindow.2.0.0.0.33c0d.0.EXCEL.EXE-Application Error
Excel error message The instruction at 0x0beab865 referenced memory at "0x00000008"
The memory could not be "read".
Click ok to terminate the program.
I hope someone could please help me with this I received 60 - 80 csv files a week and everythime I save on I get this pop up message!
Thank you!
Leslie
This is an SSIS (SQL Server Integration Services) forum. You might have better success in the Office forums: http://www.microsoft.com/office/community/en-us/default.mspx
CSV Exporting
and can not find any responses.
I have a report that has a single table with a 2 row header, a single row
detail and a single row footer. The report works fine and exports to Excel
fine. However, when I try to export to CSV I am seeing some strange
results. My 2nd row header (which includes only an expression calculating
report date range), and my report footer (which is includes summations of
the detail rows) are included in EVERY row of my exported CSV file.
This may help:
report format:
header1
header2
header3
dataa datab datac
footer1a footer1b footer1c
results in:
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
Any ideas as to why this is happening? Has anyone else experienced the same
issue?
Thanks
TerrellYou're looking for the DataElementOutput property.
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"troark" <t.roark.n0spam@.excite.com> wrote in message
news:uK9f5xOaEHA.3704@.TK2MSFTNGP09.phx.gbl...
> I posted this message last week, but I've been out of town for a few days
> and can not find any responses.
> I have a report that has a single table with a 2 row header, a single row
> detail and a single row footer. The report works fine and exports to
Excel
> fine. However, when I try to export to CSV I am seeing some strange
> results. My 2nd row header (which includes only an expression calculating
> report date range), and my report footer (which is includes summations of
> the detail rows) are included in EVERY row of my exported CSV file.
> This may help:
> report format:
> header1
> header2
> header3
> dataa datab datac
> footer1a footer1b footer1c
> results in:
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
>
> Any ideas as to why this is happening? Has anyone else experienced the
same
> issue?
> Thanks
> Terrell
>
>|||Thanks Chris! That was it.
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:ePjDoITaEHA.4068@.TK2MSFTNGP10.phx.gbl...
> You're looking for the DataElementOutput property.
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "troark" <t.roark.n0spam@.excite.com> wrote in message
> news:uK9f5xOaEHA.3704@.TK2MSFTNGP09.phx.gbl...
> > I posted this message last week, but I've been out of town for a few
days
> > and can not find any responses.
> >
> > I have a report that has a single table with a 2 row header, a single
row
> > detail and a single row footer. The report works fine and exports to
> Excel
> > fine. However, when I try to export to CSV I am seeing some strange
> > results. My 2nd row header (which includes only an expression
calculating
> > report date range), and my report footer (which is includes summations
of
> > the detail rows) are included in EVERY row of my exported CSV file.
> >
> > This may help:
> >
> > report format:
> > header1
> > header2
> > header3
> > dataa datab datac
> > footer1a footer1b footer1c
> >
> > results in:
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> > header2,footer1a,footer1b,footer1c,data(x)a,data(x)b,data(x)c
> >
> >
> > Any ideas as to why this is happening? Has anyone else experienced the
> same
> > issue?
> >
> > Thanks
> > Terrell
> >
> >
> >
>
Tuesday, February 14, 2012
CS1595: 'Sanghi.Global' is defined in multiple
error
if any one know the solution pls let me know
Compiler Error Message: *CS1595: 'Sanghi.Global' is defined in multiple
places; using definition from
'c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary
ASP. NETFiles\sanghiweb\3cb18c71\212986e7\ass
embly\dl2\0730bee1\0028ca9a_b915
c501\sanghiweb.DLL'
*Source Error:*
Line 26:
Line 27:
[System.Runtime.CompilerServices.CompilerGlobalScopeAttribute()]
Line 28: public class Global_asax : Sanghi.Global {
Line 29:
Line 30: private static bool __initialized = false;I think you posted in the wrong newsgroup.
Anyways, clear the temporary internet files and try.
"Mahesh" wrote:
> hi when i try to run my c#.net web application i m getting following
> error
> if any one know the solution pls let me know
> Compiler Error Message: *CS1595: 'Sanghi.Global' is defined in multiple
> places; using definition from
> 'c:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary
> ASP. NETFiles\sanghiweb\3cb18c71\212986e7\ass
embly\dl2\0730bee1\0028ca9a_b9
15c501\sanghiweb.DLL'
> *Source Error:*
> Line 26:
> Line 27:
> [System.Runtime.CompilerServices.CompilerGlobalScopeAttribute()]
> Line 28: public class Global_asax : Sanghi.Global {
> Line 29:
> Line 30: private static bool __initialized = false;
>