SSMA for Sybase - Table Not Load: Invalid Column Name fill_factor

I am trying to convert from Sybase 11.5 to SQL 2005 and when I refresh from database I receive the following errors. Fill_Factor is not a column in the tables in Sybase. Any thoughts on what might be going on?

Analyzing metadata...

Converting procedure Mortality.dbo.proc_exposure_1 ...

Sybase Server Object Collector error: table : company_mortality_rate_tbl

[Native Error code: 207]

[DataDirect ADO Sybase Provider] Invalid column name 'fill_factor'.

Error occurred while loading content.

Sybase Server Object Collector error: table : study

[Native Error code: 207]

[DataDirect ADO Sybase Provider] Invalid column name 'fill_factor'.

Error occurred while loading content.

Converting procedure Mortality.dbo.proc_mortality_output ...

Sybase Server Object Collector error: table : sysindexes

[Native Error code: 207]

[DataDirect ADO Sybase Provider] Invalid column name 'fill_factor'.

Error occurred while loading content.

Sybase Server Object Collector error: table : sysindexes

[Native Error code: 207]

[DataDirect ADO Sybase Provider] Invalid column name 'fill_factor'.

Error occurred while loading content.

Sybase Server Object Collector error: table : exposure_array

[Native Error code: 207]

[DataDirect ADO Sybase Provider] Invalid column name 'fill_factor'.

Error occurred while loading content.

Sybase Server Object Collector error: table : mortality_rate_table

[Native Error code: 207]

[DataDirect ADO Sybase Provider] Invalid column name 'fill_factor'.

Error occurred while loading content.

Converting procedure Mortality.dbo.proc_study_work_1 ...

Sybase Server Object Collector error: table : study_working

[Native Error code: 207]

[DataDirect ADO Sybase Provider] Invalid column name 'fill_factor'.

Error occurred while loading content.

Sybase Server Object Collector error: table : study_working

[Native Error code: 207]

[DataDirect ADO Sybase Provider] Invalid column name 'fill_factor'.

Error occurred while loading content.

October 6th, 2008 10:35pm

In SQL Server 2005 the fill_factor is spelled as FILLFACTOR.  Example:

Code Snippet
USE AdventureWorks;
GO
ALTER INDEX ALL ON Sales.SalesOrderHeader
REBUILD WITH (FILLFACTOR = 90, SORT_IN_TEMPDB = ON,              STATISTICS_NORECOMPUTE = ON);
GO

 

&nb

Free Windows Admin Tool Kit Click here and download it now
October 7th, 2008 12:33am

Hi,

Even I am getting the same error when trying to see the table structure in sybase from SSMA tool. 

Sybase Server Object Collector error: table : EFTArchive_bk2
     Invalid column name 'fill_factor'.
     Error occurred while loading content.

I am not sure how to fix this. 

This answer doesn't help me. "In SQL Server 2005 the fill_factor is spelled as FILLFACTOR." As I am getting this error sybase database itself.  

I am using SSMA to migrate data from sybase to sql. when I select the tables in sybase, I am getting above error. (Invalid column name "fill_factor") 

Could some please help me how to fix this error?

May 9th, 2014 5:39pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics