sql server dts: DTS adds extra character to EXCEL file -- sql server dts

DTS adds extra character to EXCEL file

kuidokylm via SQLMonster.com
3/29/2007 12:00:00 AM

sql server dts:

Hello
I'm using SQL2000 DTS services to export stored procedure result to EXCEL
file.

When I open EXCEL file, all the data is prefixed with ' character like
'AAMURUSKO
'PIHKALANKATU

How to avoid that ?

Kuido

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200703/1

RE: DTS adds extra character to EXCEL file

RLoski
3/29/2007 4:44:05 AM

On the transformation task, source tab, there is a preview button. Does the
single quote show in that?
--
Russel Loski, MCSD.Net

[quoted text, click to view]

RE: DTS adds extra character to EXCEL file

kuidokylm via SQLMonster.com
3/30/2007 12:00:00 AM

No, data that is retrieved form SP is correct

[quoted text, click to view]

--
Message posted via http://www.sqlmonster.com

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.