 | |
DTS Source Column Size Error
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
DTS Source Column Size Error -
01-28-2004
, 05:46 PM
#2
| |||
| |||
|
|
I created a DTS package that produces this error when run: "Data for source column 1 ('Text') is too large for the specified buffer size." When I looked at the column within the Transformations tab, it has a datatype of varChar(255). I believe that the problem is that the data from |
the size of this buffer for the source column so that the data can be
transferred?
Quote:
|
Thanks! |
#3
| |||
| |||
|
|
I created a DTS package that produces this error when run "Data for source column 1 ('Text') is too large for the specified buffe size. When I looked at the column within the Transformations tab, it has datatype of varChar(255). I believe that the problem is that the data fro |
the size of this buffer for the source column so that the data can b
transferred
Quote:
|
Thanks |
#4
| |||
| |||
|
|
The datasource is an excel spreadsheet. So it is Jet based. Any ideas? ----- Allan Mitchell wrote: ----- You have not told us anything about the source datasource. Is it Jet based? http://support.microsoft.com/?kbid=281517 -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. 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 "Unsure" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:8B64E94F-4E56-49C3-8702-29AC7C222082 (AT) microsoft (DOT) com... I created a DTS package that produces this error when run: "Data for source column 1 ('Text') is too large for the specified buffer size." When I looked at the column within the Transformations tab, it has a datatype of varChar(255). I believe that the problem is that the data from the source column is too large for varChar(255). Is there a way to change the size of this buffer for the source column so that the data can be transferred? Thanks! |
#5
| |||
| |||
|
|
The datasource is an excel spreadsheet. So it is Jet based. Any ideas? ----- Allan Mitchell wrote: ----- You have not told us anything about the source datasource. Is it Jet based? http://support.microsoft.com/?kbid=281517 -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. 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 "Unsure" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:8B64E94F-4E56-49C3-8702-29AC7C222082 (AT) microsoft (DOT) com... I created a DTS package that produces this error when run: "Data for source column 1 ('Text') is too large for the specified buffer size." When I looked at the column within the Transformations tab, it has a datatype of varChar(255). I believe that the problem is that the data from the source column is too large for varChar(255). Is there a way to change the size of this buffer for the source column so that the data can be transferred? Thanks! |
#6
| |||
| |||
|
|
Where is the article located? ----- Allan Mitchell wrote: ----- The article I posted presents some ideas -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. 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 "Unsure" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:542EF6E7-DA80-45CB-A92B-082C8F238E04 (AT) microsoft (DOT) com... The datasource is an excel spreadsheet. So it is Jet based. Any ideas? ----- Allan Mitchell wrote: ----- You have not told us anything about the source datasource. Is it Jet based? http://support.microsoft.com/?kbid=281517 -- -- Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) www.allisonmitchell.com - Expert SQL Server Consultancy. 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 "Unsure" <anonymous (AT) discussions (DOT) microsoft.com> wrote in message news:8B64E94F-4E56-49C3-8702-29AC7C222082 (AT) microsoft (DOT) com... I created a DTS package that produces this error when run: "Data for source column 1 ('Text') is too large for the specified buffer size." When I looked at the column within the Transformations tab, it has a datatype of varChar(255). I believe that the problem is that the data from the source column is too large for varChar(255). Is there a way to change the size of this buffer for the source column so that the data can be transferred? Thanks! |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.