error running DTS script

[abraka1]

Following error message is observed when running the DTS SCript "900 is the maximum size of index,The composite index specified is 1078 bytes". The table does not have any index defined.Please advice

 

[tlbroadbent]

Does the DTS package contain code that is creating an index or a primary key on a table? If you want to get the best answer for your question read faq183-874 and faq183-3179.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

 

[abraka1]

No DTS code creates the table from another table using SQL.There is no primary key or index on table.Many Thanks.A