Import/export wizard for importing tables from sybase ase12 to mssql2005

I used import/export wizard for importing tables from sybase ase12 to mssql2005. I've used .netframework provider for odbc for connection. My odbc works fine. But while using this, the first option is disabled. I can only import using sql query and not by selecting tables. I want to create an SSIS package for this, which I converted from dts to dtsx. Everything went smooth except for selection of tables. Any help is appreciated. Thanks in advance.

0 answers