Import Unidata into SQL 2005

stuaz · #1 (**permalink**) 06-27-11, 06:28

Hi,
Not sure if this is more a Unidata or a SQL question...

Basically I am trying to Import a unidata database into SQL2005.

I have converted the Unidata tables into SQL compliant tables and I can access this information via Excel as an example.

However when I go to import this data into SQL I get the following message:

Code:

TITLE: SQL Server Import and Export Wizard
------------------------------

Column information for the source and destination data could not be retrieved.


"CALLS_1_NF_SUB" -> [dbo].[CALLS_1_NF_SUB]:

	      - Cannot find column -1.


------------------------------
ADDITIONAL INFORMATION:

Cannot find column -1. (System.Data)

------------------------------
BUTTONS:

OK
------------------------------

If anyone has any tips or manuals on how to set it up so I can import Undiata Data into SQL I would appreciate it.

ARWinner · #2 (**permalink**) 06-27-11, 09:21

It is definitely not a DB2 question...

Andy

UnidataToSql · #3 (**permalink**) 02-10-12, 12:28

Have you been able to resolve this issue?

There is a new, pre-release tool that is comming that will all you to move Unidata data to any SQL database easiely.

Please contact me if moving Unidata to SQL is a problem.

Internet Services

Web Development

Digital Marketing

Consumer Tech