Hi.

I have Sql Server 2000 With Sql SP3 on Win2K.

I am Importing Data from Textfiles to a table which has a column of Varchar(512)
Thru DTS Package in VB6 but DTS Truncates the Column to 256 Charcters during import.

can anyone help me as this is urgent. I have a deadline to meet.

Are you seeing this problem then

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

I know it says that this was fixed in SP2 but it may still be worth the
read.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"vins" <vins (AT) discussions (DOT) microsoft.com> wrote