Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
greg631
Starting Member
4 Posts |
 Posted - 2009-06-09 : 18:05:09
|
| Hi -I am trying to use the 'Import and Export data' wizzard to move data from a Sybase 15.0.3 database to a SQL 2008 server.I am able to configure the OLEDB connection, and it tests successful, however when I click next it waits a few seconds, and then displays:'TITLE: SQL Server Import and Export Wizard------------------------------Cannot get the supported data types from the database connection "Provider=ASEOLEDB.1;Password=;Persist Security Info=True;User ID=sa;Data Source=dalet_db;Initial Catalog=dalet".------------------------------ADDITIONAL INFORMATION:Specified cast is not valid. (System.Data)------------------------------BUTTONS:OK------------------------------Thanks for ANY help!:)Greg |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2009-06-09 : 22:40:46
|
since it's sybase, you could use sybase's bcp.exe to get the data out, and SQL Server's bcp.exe to get the data in. That's what I would do.
elsasoft.org |
 |
|
|
greg631
Starting Member
4 Posts |
Posted - 2009-06-10 : 09:05:25
|
was working on that, but I've got some 'funny' characters such as " ' , and . in the fields and I wasn't sure how bcp on both ends would handle that.quote:
Originally posted by jezemine
since it's sybase, you could use sybase's bcp.exe to get the data out, and SQL Server's bcp.exe to get the data in. That's what I would do.
elsasoft.org
|
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2009-06-11 : 18:45:00
|
should handle it fine as long as you don't use any of those chars as a delimiter. For example, if your data has , in it, don't use , as a column delimiter.
elsasoft.org |
|
|
|
|
|
|
|
|
Sybase OLEDB question in SQL 2008