January 13, 2006 at 12:58 am
Hi,
I am trying to connect to a Sybase Adaptive Server Anywhere 8.0.3 with the Import/Eport wizard for transfering a lot of tables. But I get an error message - see bottom of messge.
I manage to connect with odbc, but then I can only select one table a time, and need to write the sql for retreiving the data.
Any ideas to get this working? Somone told me tat the odbc support was better in SQL Sever 2000 version - will it work to select multiple tables there?
I am using SQL Server 2005 version 9.00.1399.06
Regards Henning
===================================
Cannot get the supported data types from the database connection "Provider=ASAProv.80;Password=;Persist Security Info=True;User ID=tibs;Data Source=NorwayHTG;Location=localhost". (SQL Server Import and Export Wizard)
===================================
Specified cast is not valid. (DTSWizard)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceInfo.LoadTypeData(OleDbConnection myDestConnection)
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceInfo.CacheDataSourceInfo(IDbConnection myConnection)
January 13, 2006 at 7:49 pm
You got further than we did... we could connect between Sybase ASA and SS 2005 only as long as they were on the same subnet. The Sybase parameter "commlinks=tcpip" had to be in the connect string to connect across subnets - and there was no provision in the tool for editing and adding the parameter. We finally changed our direction to use Sybase DirectConnect to stage the relational database (from Sybase) in SQL Server, and then we do our SSIS ETL stuff from there... SQL to SQL.
November 14, 2006 at 10:17 am
if anyone is interested I just did the same thing. We have a Sybase server and need to copy the DB to SQL 2000 and SQL 2005 next year.
Currently we have SQL Anywhere set up on a SQL 2000 server, ODBC connnection to Sybase and a DTS package to transfer the data.
For SQL 2005 I was having trouble migrating the package and I'm going to rebuild it in SSIS. 3 tasks for me. 2 execute SQL tasks and an Execute DTS 2000 task for the actuall data transfer where I spedicfy the DTS connection and what to copy. Worked with 1 table. 111 left to go.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply