Groups | Blog | Home
all groups > sql server dts > december 2006 >

sql server dts : Can't export to fixed-format text on workstation


JXStern
12/5/2006 10:51:48 PM
It has something to do with my workstation config, same package builds
and runs fine on other boxes.

Breaks when I try to build it on my workstation. Simple connection to
database, text file destination, straight-thru transform. Problem is
the destination for some reason lists no fields, and then when I click
on the button to define fields, it gpf's. Doesn't seem to matter if
the source is a table or an SP. Source does have 131 fields. I think
I did get a five-field table to export without incident.

If I build the same package on a box where it works properly, then try
to run that package on my workstation, it GPF's.

My workstation is XP Pro, I believe it is SP2 (but with IE6), running
SQLServer 2000 dev SP4, also Visual Studio 2003 and Visual Studio 2005
and SQLServer 2005 dev.

Same version text driver on another box works fine. I give it aboutt
50% odds it's a problem in or about the text driver.

I thought of trying to download a newest MDAC, but my system is such a
hodgepodge, I have no idea which one to get or what the complications
might be.

This sound familiar to anyone?

Thanks.

J.
JXStern
12/7/2006 9:07:47 PM
http://support.microsoft.com/kb/818540

"unexpectedly quits"

ha.

Sez: load SP.

I have SP3, but it may be overwritten, I'm going to try SP4 ASAP.

J.



On Tue, 05 Dec 2006 22:51:48 -0800, JXStern <JXSternChangeX2R@gte.net>
[quoted text, click to view]
JXStern
12/8/2006 7:30:12 PM
Loading SP4 did not help.

Must be one of the newer components from Visual Studio breaks it.

J.



On Thu, 07 Dec 2006 21:07:47 -0800, JXStern <JXSternChangeX2R@gte.net>
[quoted text, click to view]
AddThis Social Bookmark Button