Export to .txt file from SQL Server table - memory err

[MrPeds]

Hi,

I am trying to export data from a SQL Server table to a .txt file - the table contains a lot of columns.

When i try to export the data i get a memory exception error and Enterprise manager closes down. The connection to SQL is via an ODBC connection (i am prototyping a package that will be used by a unix box so am pretendig the SQL server is the unix datbase).

does anybody know of any limits on the number of columns you can have in an export to text file? or know of any reasons why i should be getting this error? there is no data in the SQL table, but i am sure this should not be a problem as my other data transformations in teh package seem fine when i create them.

the error always seems to occur when i select the option "Populate from source" in the Define Columns option.

thanks in advance,

MrPeds

 

[mrdenny]

How many columns are we talking about? Odds are it's just an EM bug. Had you applied the Service Pack to the machine with EM on it?

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)

 

[MrPeds]

I've found the problem.

Its a bug in service pack 3.

Please see this article:

http://support.microsoft.com/?kbid=818540