Home » SQL Server

UniData ODBC Import

I am trying to import unidata into SQL Server 2005 Standard Edition.

I can successfully import data into MS Access.  It is simple.  I just tell Access to look at the appropriate system DSN, put in the server, database name and password, and there are all the tables to choose from.

The ODBC data source is not one of my choices in the Import/Export Wizard in SSMS.

How do I use the Import/Export Wizard to import unidata?

Thank you.



13 Answers Found


Answer 1

Hi Joel,

Did you ever figure this out?  I'm having a similar issue, a UniData db that I need to get into either Access or SQL.  I've been unable to locate an ODBC driver for Unidata.

Thanks for any insight you can provide!



Answer 2

You will always needs a ODBC driver in the machine you are running SSIS, so your desktop and probably the server later on as well.

If you can see teh driver in the Data Sources (DSN) stuff from Control Panel,l then you should be fine.

You then need to choose the correct connection manager type in SISS, that allows you to select DSN or eneter a ODBC connection string. You can use the ODBC connection type or the ADO.NET connection, where you can choose the .Net ODBC Data Provider.


Answer 3

Well, that's the problem, and what I'd asked: I can't find an ODBC driver for Unidata...

Answer 4

Sorry, I assumed you where asking in a SSIS related manner. If you do not have the driver, have you tried IBM or an IBM forum?

If possible I'd recommend using an OLE-DB provider over ODBC, the support in the MS world is better. According to the IBM site, both are available. Is there not a client install or driver install available as part of the main software media?


Answer 5

Have you contacted your UniData DBA?  The ODBC drivers are on the client CDs.  Or have you looked at, or contacted IBM?

A quick search for "unidata odbc" in Google returned a bunch of conversations regarding this topic.  I've even found reference to a UniData OLE DB driver. 

So, at this point, you're really in the wrong forum as this is no longer an SSIS issue.

You may want to revisit this thread and provide a link to the ODBC software, or to a resource that helped solve your problem.  Otherwise, there really isn't much here for this forum.  (If anything, you can try the SQL Server Data Access Forum, but again, it's not really a SQL Server issue that you are having.)

Answer 6

I don't have a unidata dba...I have a client company with a unidata database that I'm trying to convert into my firm's SQL database.  They don't have their client CD's, and I don't have a relationship with IBM that would allow me to get a copy.

I'm aware of the Google results; that's how I found this thread to begin with.  None of the results pointing to 3rd party drivers went to viable companies that still offer the driver.  Honestly, I wasn't posting here because I thought I had an SSIS issue, I was posting in response the the original poster who seemed to have an ODBC driver.  If you know of someone that offers a usable driver, that's really all I'm looking for.



Answer 7

Darren, yes, I've tried IBM as much as I'm able since I'm not an IBM customer (see my other post) but can't find a driver I can access.  I'll happily take OLE-DB or ODBC...not picky, just need to get into the data! :-)  My client doesn't have their media and say they can't get copies since the originally contracted their install from yet another company.  What I'm ultimately needing is probably a 3rd party driver or a legitimate path to an IBM one...I've just been unable to locate one.



Answer 8

Again, try an IBM forum or some other resource.  That would yield you the best results.

A call to IBM might help as well, even though you're not a customer.  Talk to their sales department or something.  The ODBC driver might be free.

Answer 9

I am trying to import unidata into MS Access. But, from where do i get the appropriate system DSN? Thanks


Answer 10

Fritz Beco wrote:
I am trying to import unidata into MS Access. But, from where do i get the appropriate system DSN? Thanks

Using SSIS?  Either way, you need to create the ODBC DSN.

Answer 11

I think the problem you are having has to deal with the fact that the ODBC driver for Unidata is 32-bit and your SQL 2005 is 64-bit.  I'm currently working through this and if I find the answer I will follow-up with the solution.


Answer 12

FWIW, I've been working w/ unidata myself from an older SQL 2000 machine.  All I can really tell you about are the configuration settings that I've had to work with to connect to an existing unidata server.

On my SQL server (which already had the unidata drivers installed, can't help you with that, although I'm now looking for newer OLE DB / .Net drivers), I've got a linked server of the type Microsoft OLE DB Provider for ODBC drivers.  When I script that, it looks like the following:

EXEC master.dbo.sp_addlinkedserver @server =N'UNIDATALINK', @provider=N'MSDASQL', @datasrc=N'EXEODBC', @catalog=N'EXCUNIODBC'



master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'UNIDATALINK',@useself=N'False',@locallogin=NULL,@rmtuser=N'<DOMAIN>\<USERNAME>',@rmtpassword='<domain password>'



On my server, in C:\Informix\UniClient\Config folder, I've had to modify the uci.config file when we migrated the unidata server to a new machine.  I think there's a UniAdmin tool or something which effectively modifies this file.  Inside that file, I have the following entry:


SERVICE = udserver
HOST = <unidata server name>

And within the server's ODBC settings, I have a System DSN named EXEODBC  (the "EXE" is part of the name of the database used in my scenario, it has no other significance) of type Informix UniData ODBC who's server name is, again, EXEUNIODBC, has a database name specified as "EXCUniODBC" that I guess matches with the actual unidata server.  It has a user(name) specified, but I don't think the one here is relevant.  In the ODBC Drivers tab, on this old sever, the driver version shows, UDTODBC.DLL dated 9/6/2001.

The linked server specified above once used a unidata-specific login of some sort, but I recently changed it to use a windows account.  Using the SQL "use existing credentials" option never worked, but entering the login manually did. 

I've been able to run queries against this linked server as follows (connecting to the SQL server, which specific local database you're connected to doesn't matter until you want to start moving the data over).

exec master..sp_tables_exN'UNIDATALINK',null,null,null,'''TABLE'''






into SomeNewSQLTable
fromOPENQUERY( UNIDATALINK ,'select * from SOMETABLE where NAME = ''fred''')




Answer 13

hi mtbnumber7

did you ever find a solution to this. I am currently trying to set up a linked server in sql server 2008 r2 to Unidata database. Trying various drivers without much luck.




Search for  UniData ODBC Import


Hi All,

Task is to fetch data from ATOMIX server into SQL Server 2005 database. I have already installed Noble Atomix drivers and have configured the DSN.

I am using the same DSN to setup a ODBC connection manager within SSIS package. The test connection is successful.

Now I am using Data Reader Source to select tables from Atomix database followed with Data conversion task into OLE DB Destination task.

There are no erros but when I try to execute the package, it will be running for ever without completion and after some time BI studio hangs.

Please advise if you have any suggestions to fix this problem.





I have an old installation of Vista on one partition, and I have just put Windows 7 on a new partition.  On the Vista side, I have a lot of ODBC data settings and definitions.  How do I export those to a file, and then import them to the ODBC data manager on the Windows 7 side?  There must be a way.





I am trying to get data from a postgre sql database in powerpivot (via the connection wizard).


If I use the commercial oledb driver there is no problem but if I use the free odbc driver I can only access the data via queries (without problems) but the visual selection returns


System.NullReferenceException: Object reference not set to an instance of an object.

   at Microsoft.AnalysisServices.Modeler.DataImportWizard.TableSelectionPage.ShowAllTablesAndViews(Object sender, EventArgs e)

   at Microsoft.AnalysisServices.Modeler.DataImportWizard.ProgressControl.timerTaskComplete_Tick(Object sender, EventArgs e)

   at System.Windows.Forms.Timer.OnTick(EventArgs e)

   at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m)

   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


can anybody help me with that?


I am trying to import unidata into SQL Server 2005 Standard Edition.

I can successfully import data into MS Access.  It is simple.  I just tell Access to look at the appropriate system DSN, put in the server, database name and password, and there are all the tables to choose from.

The ODBC data source is not one of my choices in the Import/Export Wizard in SSMS.

How do I use the Import/Export Wizard to import unidata?

Thank you.



I have created a SSIS package.

The 'Data Flow' read data from a database (per ODBC-Source) and write this data in a csv-file.

I nedd a Username (uid) and Password (pwd) for the ODBC-Connection!


SSIS-Package  | Data Flow:


1 DataReader-Source(ODBC: .NET-Provider\Odbc Data provider)

2 Derived Column Transformation

3 Data Conversion

4 Flatfile Destination (CSV-File)


The SSIS-Package is working in the Visual Studio (debug start).

I can see the Name and Password (******) in the properties from the ODBC-Connection.



Next step, I have imported the the SSIS package.

> SQL Server 2005 > Intergration Services (Filesystem)


Step 2: Create a new Jobs for this SSIS package


SQL Server Agent | Jobs (my SSIS package) | Properties | Steps | Datasource | Connection string (ODBC Connection)


The ODBC pwd is in the connection string nonexistent! I can not insert and save the pwd in the sonnection string.


Connection string: uid=DataReader;Dsn=crm_databae;dbq=TCP/IP:;codepage=1252;



Step 3: Start the Job (SQL Agent Job)


Error: Message ... Code 0xC0016016 ... Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.".  ... 'DTS:Password' ... Invalid password ...




SQL Server 2005 SP2

SQl Server BID Studio (VS 2005)




I have been trying to convert our internal webpage from asp to ASP.NET with .NET 4.0. Some of our pages pull from multiple tables/databases to comprise a single page. The original asp pages connecting to the database are LIGHTNING fast, However the new pages using the MySQL ODBC 5.1 drivers fail to come even close to the asp pages. Average load time for an ASP.NET is about 92000ms., ASP load time about 8ms.

Here is what I've tried/noticed

1. Regardless of setting ViewState,Debug to (true/false) in page or web.config makes no difference, load time stays about 6000ms per call to database

2. We have two Servers (web and main), ASP pages take about the same time (8ms) to load from each/both servers, ASP.NET pages take about 8ms(main) from one and about 12000ms(web) from the other

3. I tried to trace the ODBC driver, but to no avail (don't have admin access to force). Using the TEST button through the dialog box has about 5sec delay from (web) and instant feedback from (main)

4. Checked all the code calls to make sure that for every open there is a close, same slow result from ODBC

5. Tried to have only one open and one close call to the DB and many reads in between, same result: slow performance.

6. I have read the article about optimizing my code through the use of caching etc... I don't believe this applies to my situation.

7. I have my main DB connections/functions in a class that has its' own instance, but no more than two are opened at any given time

8. My connection string are:

          (main)  driver={MySQL ODBC 5.1 Driver};SERVER=server;DATABASE=main;uid=;pwd=;OPTION=16427;

          (web)   Driver={MySQL ODBC 5.1 Driver};Server=server;Port=port;Database=web;User=;Password=;Option=3;

9. Tried changing the flags (option) for (web) but no real noticable result


Any help would be greatly appreciated. I'm already pulling out what little hair I have left!

Thank you



I need to establish a connection between an Access 2003 database (32 bit) and an 11g 64 bit Oracle database on a server. I am running Windows 7 on a 64 bit laptop. I did a clean install of Oracle 11g for 64 bit. I have no problem accessing the Oracle database via the Oracle SQL Developer. I just have a problem from within Access. I hope someone can help me. I've been fighting this for several months. Thanks in advance!

Our database fails to import into a database project using Visual Studio 2010 Import Wizard.  

The database has 577 tables and 2648 stored procs. 

The process just stops with no error messages displayed anywhere including logging locations.

The last log entry in the import schema logs file is: 6/24/2010 10:54:18 AM Adding all files to the project...

The same database does import using Visual Studio 2008 database import wizard so I've gotten around the problem by using 2008 then converting the project to 2010; however, this behavior is unexpected in 2010 and should be addressed.

If anyone knows of anything to try or consider to get around this issue, then please let me know.



Hi all

i have text file where i can import it to excel to access or sql2000 without problem but when i import it using (sql2005 pro) i get this error message during the import

Operation stopped...

- Initializing Data Flow Task (Success)

- Initializing Connections (Success)

- Setting SQL Command (Success)

- Setting Source Connection (Success)

- Setting Destination Connection (Success)

- Validating (Success)

- Prepare for Execute (Success)

- Pre-execute (Success)


Information 0x402090dc: Data Flow Task: The processing of file "C:\Documents and Settings\Wail\Desktop\All_Alarm5.txt" has started.
(SQL Server Import and Export Wizard)

- Executing (Error)


Error 0xc02020a1: Data Flow Task: Data conversion failed. The data conversion for column "FRDNAME" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".
(SQL Server Import and Export Wizard)

Error 0xc020902a: Data Flow Task: The "output column "FRDNAME" (25)" failed because truncation occurred, and the truncation row disposition on "output column "FRDNAME" (25)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component.
(SQL Server Import and Export Wizard)

Error 0xc0202092: Data Flow Task: An error occurred while processing file "C:\Documents and Settings\Wail\Desktop\All_Alarm5.txt" on data row 9.
(SQL Server Import and Export Wizard)

Error 0xc0047038: Data Flow Task: The PrimeOutput method on component "Source - All_Alarm5_txt" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
(SQL Server Import and Export Wizard)

Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited with error code 0xC0047038.
(SQL Server Import and Export Wizard)

Error 0xc0047039: Data Flow Task: Thread "WorkThread0" received a shutdown signal and is terminating. The user requested a shutdown, or an error in another thread is causing the pipeline to shutdown.
(SQL Server Import and Export Wizard)

Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with error code 0xC0047039.
(SQL Server Import and Export Wizard)

- Copying to [DXB_Data].[dbo].[All_Alarm5] (Stopped)

- Post-execute (Success)


Information 0x402090dd: Data Flow Task: The processing of file "C:\Documents and Settings\Wail\Desktop\All_Alarm5.txt" has ended.
(SQL Server Import and Export Wizard)

Information 0x402090df: Data Flow Task: The final commit for the data insertion has started.
(SQL Server Import and Export Wizard)

Information 0x402090e0: Data Flow Task: The final commit for the data insertion has ended.
(SQL Server Import and Export Wizard)

- Cleanup (Success)


Information 0x4004300b: Data Flow Task: "component "Destination - All_Alarm5" (64)" wrote 0 rows.
(SQL Server Import and Export Wizard)



**** from the error message (Executing)  error number 2 and 3 it shows that the error is comming from the (column FRDNAME) and row number 9 ...

this cells contains the following text:  ;Ruwais5 B60_Baynounah_R_H_Camp_PH rack1 shelf1 db4g 0;
where the ";" is the delimiter

moreover when i remove this row other problem comes in diffirent location with the following text: ;((AvailabilityStatus,failed ,),(OperationalState,disabled ,));
where the ";" is the delimiter

**** from the error message (Executing)  error number 1
there is somthing called ( code page ) this can be modified from the wizard it self and there are many options to choose. i tryed many of them but without solution

i hope that i will find solution for my problem

thank you



i created a csv file with infomation of appointment,all the columns are OK execpt the "organzier"(partytylist) and "status" (status). i dont acheive it because this 2 colume, is it possible to import these using import wizard?

and i found there can only be one user in the field of organzier, but why it is not lookup type...



Hi all,


I exported a custom entity from our crm & i deleted it.
I then went to import that same customization & it said import successful, but when i go to the entities i get the following error message:
    An error has occured
    Try this action again.....

Am i missing a step somewhere?
I didn't make any changes to the exported customization file.



MPG is the most popular video format, no matter used on Mac or Windows, but not every video player can play all kinds of .MPG files, for example, QuickTime can play MPEG-1 and MPEG-4 files, but not for MPEG-2 video, Windows Media Player can only play MPEG-1 files. If QuickTime can't play the .MPG files, let alone iMovie imports MPG .

However, we can use the powerful Movie Converter for Mac as an MPG to iMovie Converter software. Just install Movie Converter for Mac, and run one of the two programs - Video Converter for Mac to convert MPG to iMovie on Mac OS. Following the below tutorial, you can easily import MPG to iMovie after the conversion.

Tutorial: How to import MPG to iMovie for Mac OSX?


Good Day! everyone

I am facing a problem while importing a schema in another schema. Here is detail of my scenario.

I build a solution where i was using a schema named "Contact". Then I created a new solution which was using a schema named "Customer". I need contact schmea of first solution in this Customer schema as a child record so I imported it in customer schema using XSD Import option. It all worked fine.

Then some days later, I was creating another solution which has a third schema named "Relations". Now I need Customer schema as child record of it. When I tried to import Cutsomer schema in it. It throws error for Contact  schema namesapce that it is not found. I also tried it by adding reference of both projects in this third project but problem remain same.

Here is the error description.

"The 'http://BizSchema1.Contact:Contacts' element is not declared."

Anyone, Help  for resolving this issue


Hi there,

I have finished learning OOP. Now I want to build the fully executable files. To start with I found a project folder on a website which contains all the source code files (header and main). It also included executable file so I ran it and played the game. Now I want to put the whole project on VC++ and do bit of tweaking. What I did is as follows:

Creating a New project and in solution explorer, pasted the main file under source file. Opened the main file and found the header file (#include SDL/SDL.h) was underlined in red.

I downloaded sdl library and placed the SDL folder which contained all the header files in the game folder. I changed the include files path in VC++ directories to look into the game folder. I reopened the main file and all the read lines were gone.

From the project explorer, I right clicked the main and compiled it. It compiled successfully.

To ensure the main is read fully by the compiler, I added before the final return 0 command, cout<<"compiled successfully". But everytime I tried the window will pop up saying that VS restarting. I tried it many times and same thing happened.

After trying to change code and failing several times I clicked the green arrow to run and build it(previously I only compiled it and compilation was always successful).  On clicking run button compiler returned"

LINK : fatal error LNK1561: entry point must be defined"

I searched through forums and found linker is not finding the entry point main function. But there is a main function in this main file.

I dont have a clue how I would succeed in building this project on VC++ and do some tweaking and create a new executable game. Please help.

Many thanks in advance.


[quicktime mts import] Import SD700 mts files to Final Cut Pro for editing
Panasonic HDC-SD700 is a slimmest and compact camcorder among the Panasonic's new 700 series in 2010. The SD700 does not include built-in memory, but offers SDXC/SDHC/SD Memory Card slot for storing videos and pictures. The price of HDC-SD700 is much lower than that of HDC-TM700 and HDC-HS700, but includes the same recording quality for 1080i and 1080p videos.
With the new recording mode for 1080/60p 28mbps, the AVCHD files could not play very well on Apple computers like iMac, MacBook Pro. To get Panasonic HDC-SD700 1080/60p 28mbps .mts video footage compatible to QuickTime Player on iMac, it is recommended that you use Aunsoft MTS/M2TS Converter for Mac to transcode the non-AVCHD compliant 1080/60p 28mbps files to Apple QuickTime files like MOV and MP4.

Follow the steps below, and you may enjoy the HD videos on Mac computer with QuickTime Player.
Step 1. Load Panasonic SD700 videos to Aunsoft MTS/M2TS Converter for Mac.
Use card reader to transfer videos to Apple hard drive, if you want to save the original video footage. Run Aunsoft MTS/M2TS Converter for Mac and click the "Add" button to load the 1080/60p 28mbps .mts videos for conversion. You may also directly drag and drop the .mts files from folder to the Mac Panasonic AVCHD converter interface.
Step 2. Choose HD MOV format.
Click the "Format" option, and choose HD Video > H.264 HD Video(*.mov) as output format. The Mac Panasonic HDC-SD700 AVCHD converter will transcode 1080p 28mbps MTS to MOV in 1920x1080. You may also choose H.264 HD Video (*.mp4) as output format for the converter to convert MTS to MP4 for QuickTime Player.

Step 3. Convert Panasonic HDC-SD700 60p MTS to MP4/MOV.
Click the convert button under the preview window, and the conversion from 10801/60p 28mbps MTS to MP4/MOV for QuickTime Player will start immediately. The output format depends on the profile you choose in step 2.
After the conversion is done, QuickTime Player on iMac would recognize the HD MOV or HD MP4 videos and play the recorded videos without any problem. Just enjoy the videos for the adventures.
The Mac Panasonic AVCHD converter also works for another two models of the 700 series: HDC-TM700 and HDC-HS700. If you are using other Panasonic camcorders like HDC-HS250, HDC-SD60, DMC-ZS7/TZ10, just find your camcorder model at the Panasonic column.

I searched for similar issues and couldn't find anything so thought I'd post this...


There is some strange behaviour exhibited by our installation of CRM 4.0 when we export and import a workflow that adds attachments to emails.


I have a Workflow which add attachments (forms) to emails created in the same workflow.  The workflow logic determines if a specific form attachment should be added to an email or not. This is done via an update record step in the workflow. Up to 6 attachments can be added to the two emails that are created by the workflow.


The strange behaviour is exhibited when this workflow is exported and them imported to a different environment, say from Dev to Test

If the workflow does not exist in the target environment then it is created as you would expect by the import – But any step in the imported workflow that adds an attachment  no longer includes the attachment.  You have to manually edit the workflow step, and tell it which attachment you are trying to add.

If the workflow does exist then the behaviour becomes even odder.

Any new step that adds attachments also does not include which attachment is to be added (as per above).  You need to manually edit the update email step to re-add the attachment you want.
Any existing step that adds attachments remains unchanged, even if there is a change in the attachment.  You need to manually edit the update email step to remove attachments no longer required and add in any new attachments (or updated ones) that are required.  Note that an updated attachment requires you to remove the old version manually and re-add the new version.

 Has anyone else experienced this before and did they manage to solve it, or is it a bug with CRM 4.0?




-- Pete





Is it possible to import an incrementing file in SSIS using a different file name each day?
For example – on Monday I want to import “file1” on Tuesday I want to import “file” and so on.

This is so I can set a package up in SQL server to run everyday using a different file.

If not, are they are similar work arounds?





So far, I've set up Project Server 2010.  I do have admin privileges.  Create a test project (several actually) with several task all assigned to me and a few others in the office.

We have each entered timesheets for weeks within the start and finish dates of the tasks assigned to us.  The time sheet data has actual hours worked for one or two of the tasks.  Timesheets are saved and sent.  Then we have each gone to the My Tasks area, checked the box in front of the task for which time was entered and clicked the import button.

When the import screen appears, no tasks are visible or displayed for any of the weeks with associated timesheets!




Thank you,




We have upgraded MOSS 2007 database to SP2010 successfully. Now I want to import my MOSS Aplication Definition, for this whay is the best way or if someone can provide some good article or any step by step article.




We have a number of current projects that we want to import to project server 2010.  Some of those projects have past completed tasks that have resources assigned that are no longer with the company.  When I import the projects, I don't have anything to map those resources to, so I leave "Action on Import" to "Keep Local with Base Calendar"; however, project creates a resource in the enterprise resource pool anyway.  I just want to leave those old resources as local resources in the schedule and not create them on the server.  Is there anything I can do to stop the server from creating resources I don't want?  Why would it do this?  What's the point of having the "Keep Local with Base Calendar" option if it's going to ignore the "Keep Local" part?

Thanks - DKL


<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Sharepoint   |   Azure