Re: DTS Error - Data too large for specified buffer size
From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 11/23/04
- Next message: Michael Vardinghus: "Querying Oracle..."
- Previous message: SqlJunkies User: "Re: Call to a dts"
- In reply to: Scott Natwick: "Re: DTS Error - Data too large for specified buffer size"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 23 Nov 2004 20:25:36 -0000
Great to her it's working for you now
-- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.SQLDTS.com - The site for all your DTS needs. www.SQLIS.com - SQL Server 2005 Integration Services. www.Konesans.com "Scott Natwick" <nospamplease@yahoo.com> wrote in message news:8vGdnc2Papz_Cz7cRVn-ug@comcast.com... > Ok, whew, it's working now. > > I also switched from ODBC to OLE connection and it goes through. > > Thanks, > Scott > > "Scott Natwick" <nospamplease@yahoo.com> wrote in message news:SZGdnYrcA9sVET7cRVn-1w@comcast.com... >> Thanks Allan, >> >> Yes, I did see that link in an earlier post. I changed the registry setting to 0 and moved my row with the long string to the >> top of the file. >> >> However, I still get the error. I've searched and searched on google, but haven't a workaround for this problem. As indicated >> in the link you provided, it does seem to be caused by a field string greater than 255 characters. When I cut the string down to >> less than this value, it loads OK. >> >> I'm stuck. Thanks for any thoughts. >> Scott >> >> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:ewMng0Y0EHA.2624@TK2MSFTNGP11.phx.gbl... >>> Did you look at Google? >>> >>> Have a look at this >>> >>> http://support.microsoft.com/kb/281517/EN-US/ >>> >>> -- >>> >>> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) >>> www.SQLDTS.com - The site for all your DTS needs. >>> www.SQLIS.com - SQL Server 2005 Integration Services. >>> www.Konesans.com >>> >>> >>> "Scott Natwick" <nospamplease@yahoo.com> wrote in message news:_dedndPHYfsM9j7cRVn-gg@comcast.com... >>>> I'm trying to import data into my table and I'm received an error message that I've been unable to resolve. >>>> >>>> The message is: >>>> Error Source: Microsoft Transformation Services (DTS) Data Pump >>>> Error Description: Data for source column 3 ("column_name") is too large for the specified buffer size. >>>> >>>> The destination column size is 500 in the table and the data in the import file for that row and column is 280 characters. >>>> >>>> Any ideas? >>>> >>>> Thanks in advance, >>>> Scott >>>> >>>> >>> >>> >> >> > >
- Next message: Michael Vardinghus: "Querying Oracle..."
- Previous message: SqlJunkies User: "Re: Call to a dts"
- In reply to: Scott Natwick: "Re: DTS Error - Data too large for specified buffer size"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
