Web Development

Ask something
Question Locked

Enterprise Manager, DTS 2000 - Set Maximum Characters per column.

0 helpful
2 replies

by ismailc

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

Enterprise Manager, DTS 2000 - Set Maximum Characters per column.

I have a query which is okay when i run via Query Analyzer 2000 becuase I set the limit via
Query Analyzer 2000: Tools - Options - Results - set maximum characters per column

But when I create a DTS package - it does not work and cuts off the text.

Does anyone know how to set this in Enterprise Manager + DTS ?

Thank You

Regards
Ismail

2 replies

by matthew

Solution: In the DTS Designer, click Package, and then click Disconnected Edit to open the package in Disconnected Edit mode. Expand Connections, expand the text file connection object, and then expand OLEDB Properties. Finally, change the value of "Max characters per delimited column" to 8,000.

This discussion is closed to new replies.