| Groups | Blog | Home |
sql server dts : DTS truncates Column names to 64
I am trying to create a DTS package to create a table and import data from an excel spreadsheet where some of the column names are over 64 but under 100 in length but when finished creating the table and importing the data, I look at the table and it has column names truncated to 64 charaters. Is there a setting I need to make to use the max 128 limit? TIA
Thanx Allan,
but as I stated in my question below the problem is that I created a simple DTS that imports some tables from an excell spreadsheet that have column names between 80 and 100. It should alow those and not truncate them, correct? Is there some setting in SQL or the DTS package itself that will allow those names to at least go as high as the 128 limit? Thank you Jeff [quoted text, click to view] "Allan Mitchell" wrote:
> Hello MDPILWL, > > You are right the length cannot be greater than 128 > > CREATE TABLE T (aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa > int) > > > Msg 103, Level 15, State 4, Line 3 > The identifier that starts with 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' > is too long. Maximum length is 128. > > > And what is the definition of the destination table? > > Allan > > > > > I was told the max column name length for SQL 2000 was 128. > > I am trying to create a DTS package to create a table and import data > > from > > an excel spreadsheet where some of the column names are over 64 but > > under 100 > > in length but when finished creating the table and importing the data, > > I look > > at the table and it has column names truncated to 64 charaters. > > Is there a setting I need to make to use the max 128 limit? > > TIA > > Jeff > >
Hello MDPILWL,
You are right the length cannot be greater than 128 CREATE TABLE T (aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa int) Msg 103, Level 15, State 4, Line 3 The identifier that starts with 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' is too long. Maximum length is 128. And what is the definition of the destination table? Allan [quoted text, click to view] > I was told the max column name length for SQL 2000 was 128. > I am trying to create a DTS package to create a table and import data > from > an excel spreadsheet where some of the column names are over 64 but > under 100 > in length but when finished creating the table and importing the data, > I look > at the table and it has column names truncated to 64 charaters. > Is there a setting I need to make to use the max 128 limit? > TIA > Jeff
Hello MDPILWL,
And as I stated, the length of the column names will be being defined by the CREATE TABLE statement. The column names should be being created as they are in the XL Spreadsheet. I know of no setting in the XL driver that would limit the name this way and I certainly know of no setting in DTS that would do this. Have you thought about creating the tables ahead of the import? That way you KNOW what you will be getting. If you want to use the wizard then make sure to have a look at the CREATE TABLE statement being issued to SQL Server. Allan [quoted text, click to view] > Thanx Allan, but as I stated in my question below the problem is that > I created a simple DTS that imports some tables from an excell > spreadsheet that have column names between 80 and 100. It should alow > those and not truncate them, correct? > > Is there some setting in SQL or the DTS package itself that will allow > those names to at least go as high as the 128 limit? > > Thank you > Jeff > "Allan Mitchell" wrote: > >> Hello MDPILWL, >> >> You are right the length cannot be greater than 128 >> >> CREATE TABLE T >> (aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa >> aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa >> aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa >> aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa int) >> >> Msg 103, Level 15, State 4, Line 3 >> >> The identifier that starts with >> 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa >> aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' >> >> is too long. Maximum length is 128. >> >> And what is the definition of the destination table? >> >> Allan >> >>> I was told the max column name length for SQL 2000 was 128. >>> I am trying to create a DTS package to create a table and import >>> data >>> from >>> an excel spreadsheet where some of the column names are over 64 but >>> under 100 >>> in length but when finished creating the table and importing the >>> data, >>> I look >>> at the table and it has column names truncated to 64 charaters. >>> Is there a setting I need to make to use the max 128 limit? >>> TIA >>> Jeff
Hi Allan
The problem is the names of the columns are not always known and there are many of them and the idea is to automate the creation of these tables. If I were to edit or create the CREATE TABLE statement each time it would defeat the purposs of using the DTS wizard and cost much time. There surely must be a way to set the default to the max allowed!?!?! Thanx Jeff [quoted text, click to view] "Allan Mitchell" wrote:
> Hello MDPILWL, > > And as I stated, the length of the column names will be being defined by > the CREATE TABLE statement. The column names should be being created as > they are in the XL Spreadsheet. I know of no setting in the XL driver that > would limit the name this way and I certainly know of no setting in DTS that > would do this. > > Have you thought about creating the tables ahead of the import? That way > you KNOW what you will be getting. > > If you want to use the wizard then make sure to have a look at the CREATE > TABLE statement being issued to SQL Server. > > Allan > > > Thanx Allan, but as I stated in my question below the problem is that > > I created a simple DTS that imports some tables from an excell > > spreadsheet that have column names between 80 and 100. It should alow > > those and not truncate them, correct? > > > > Is there some setting in SQL or the DTS package itself that will allow > > those names to at least go as high as the 128 limit? > > > > Thank you > > Jeff > > "Allan Mitchell" wrote: > > > >> Hello MDPILWL, > >> > >> You are right the length cannot be greater than 128 > >> > >> CREATE TABLE T > >> (aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa > >> aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa > >> aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa > >> aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa int) > >> > >> Msg 103, Level 15, State 4, Line 3 > >> > >> The identifier that starts with > >> 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa > >> aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa' > >> > >> is too long. Maximum length is 128. > >> > >> And what is the definition of the destination table? > >> > >> Allan > >> > >>> I was told the max column name length for SQL 2000 was 128. > >>> I am trying to create a DTS package to create a table and import > >>> data > >>> from > >>> an excel spreadsheet where some of the column names are over 64 but > >>> under 100 > >>> in length but when finished creating the table and importing the > >>> data, > >>> I look > >>> at the table and it has column names truncated to 64 charaters. > >>> Is there a setting I need to make to use the max 128 limit? > >>> TIA > >>> Jeff > >
Don't see what you're looking for? Try a search.
|
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |