IBM Universe Database

My company has an IBM Universe database that i would like to connect to via SSIS. Is this possible? If so, please point me in the right direction. I managed to find the U2 tools on the IBM website but i am a bit confused as to what i need to do.

Thanks

In order to load data to/from other data sources into SSIS, you'd need OleDB, ADO.NET or ODBC (supported via the .NET-ODBC bridge) connectors. Microsoft doesn't have a connector for UniVerse, but have you checked with IBM or its vendors?

|||IBM has ADO.NET Provider called "IBM Data Server Provider for .NET" and "IBM Database Add-ins".

Please try the above product.

Please read this article
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0711kumar/

IA64 teradata OLE-DB or ODBC

I have a 32 bit development/playbox SQL 2005 SSIS that can see and run 32 bit OLE DB drivers from Teradata. Granted I have the same issues as others where a table or a view would work and not a query or a variable query. The alternative is to use Linked Server and OPENQUERY.

But our real development box is a 64 bit IA 64 using 64 bit SQL 2005. Non of the Teradata.com drivers would work/show up in the dropdown box of the Connection Manager since they are 32 bit. One option is to use the 64 bit Teradata ODBC drivers and then use the .Net ODBC connection instead. Linked server doesn't work either because the SQL 2005 is 64 bit and it is looking for 64 bit drivers.

Has anyone have any experience with 64 bit SQL 2005 and Teradata?

Looked at other 3rd party vendors such as ETI but their documentation excludes IA 64 (Itanium).

Planning to try again using the 64 bit ODBC and .Net Adapter but I'm interested to hear if someone (MSFT & NCR) would have a real solution for 64 bit.

Thanks

Anatole

I'm replying to my own thread as I want to see who else is having the same issue using Teradata Drivers and SSIS (32 or 64 bit).

I think this is a given where the Teradata OLE-DB driver is failing when used as a SQL Stmt rather than Table/View to extract data.

The message is:

An OLE DB error has occurred. Error code: 0x80040E21.An OLE DB record is available. Source: "OLE DB Provider for Teradata" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

Has anyone found a work-around and/or contacted MS about this?

I opened a ticket with teradata/ncr but they are pointing back at SSIS and MS.

This error can occur on any box/cpu (32 bit or 64bit).

Since ODBC adaptor in SSIS converts everything into UNICODE, the only option is to use Linkedserver and OPENQUERY cmd.

I would like to hear back from MS (I know thay have teradata servers) or anyone that has either received this error and has a solution OR is also waiting on one.

Thanks

Anatole

|||

Anatole,

Take a look at :

www.openlinksw.com/

They seem to have an IA64 OLE to ODBC driver. I am not sure I even understand the issue well enough, but we had a similar issue and found them, we are still looking to see if they can solve our issue witch is with Sybase and SQL, but I thought I would just throw it out there for you since you had not gotten anyone to reply back, it might at least give you a better lead....

Hope it helps...

Steve

|||

2 other potential resources are:

www.odbcsdk.com

This is another Third Party (Open Access) that advertises a 64bit OLEDB to ODBC Data Provider (Itanium).

http://www.datadirect.com/products/odbc64/overview/index.ssp

This is another Third Party (DataDirect) that advertises a 64bit Sybase ODBC driver (Itanium)

Just trying to be helpful for people running into these types of problems....Hopefully this is helpful...

Steve

|||

Hi!

See also my similar question (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=853174&SiteID=1&mode=1).

I can't work out your suggestion using a ".net ODBC".

B.G.

IA64 teradata OLE-DB or ODBC

I have a 32 bit development/playbox SQL 2005 SSIS that can see and run 32 bit OLE DB drivers from Teradata. Granted I have the same issues as others where a table or a view would work and not a query or a variable query. The alternative is to use Linked Server and OPENQUERY.

But our real development box is a 64 bit IA 64 using 64 bit SQL 2005. Non of the Teradata.com drivers would work/show up in the dropdown box of the Connection Manager since they are 32 bit. One option is to use the 64 bit Teradata ODBC drivers and then use the .Net ODBC connection instead. Linked server doesn't work either because the SQL 2005 is 64 bit and it is looking for 64 bit drivers.

Has anyone have any experience with 64 bit SQL 2005 and Teradata?

Looked at other 3rd party vendors such as ETI but their documentation excludes IA 64 (Itanium).

Planning to try again using the 64 bit ODBC and .Net Adapter but I'm interested to hear if someone (MSFT & NCR) would have a real solution for 64 bit.

Thanks

Anatole

I'm replying to my own thread as I want to see who else is having the same issue using Teradata Drivers and SSIS (32 or 64 bit).

I think this is a given where the Teradata OLE-DB driver is failing when used as a SQL Stmt rather than Table/View to extract data.

The message is:

An OLE DB error has occurred. Error code: 0x80040E21.An OLE DB record is available. Source: "OLE DB Provider for Teradata" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done."

Has anyone found a work-around and/or contacted MS about this?

I opened a ticket with teradata/ncr but they are pointing back at SSIS and MS.

This error can occur on any box/cpu (32 bit or 64bit).

Since ODBC adaptor in SSIS converts everything into UNICODE, the only option is to use Linkedserver and OPENQUERY cmd.

I would like to hear back from MS (I know thay have teradata servers) or anyone that has either received this error and has a solution OR is also waiting on one.

Thanks

Anatole

|||

Anatole,

Take a look at :

www.openlinksw.com/

They seem to have an IA64 OLE to ODBC driver. I am not sure I even understand the issue well enough, but we had a similar issue and found them, we are still looking to see if they can solve our issue witch is with Sybase and SQL, but I thought I would just throw it out there for you since you had not gotten anyone to reply back, it might at least give you a better lead....

Hope it helps...

Steve

|||

2 other potential resources are:

www.odbcsdk.com

This is another Third Party (Open Access) that advertises a 64bit OLEDB to ODBC Data Provider (Itanium).

http://www.datadirect.com/products/odbc64/overview/index.ssp

This is another Third Party (DataDirect) that advertises a 64bit Sybase ODBC driver (Itanium)

Just trying to be helpful for people running into these types of problems....Hopefully this is helpful...

Steve

|||

Hi!

See also my similar question (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=853174&SiteID=1&mode=1).

I can't work out your suggestion using a ".net ODBC".

B.G.

sql

I want to install SSIS on a 64 bit server without SQL Server on it

I want to install SSIS on a 64 bit server without SQL Server on it.

Say I want to install the SSIS engine on one server and have it call packages stored on another servers msdb.

It this possible?

Yes. It does require a SQL license for the server with SSIS on it, as well as the server with the database engine.

I need help debuging this error message::

Hello everyone,

All weekend long I keep getting this error message when I run my SSIS package:

Error: The variable " system::localeID" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

I have search everywhere for this message without success. Could someone help to explain this and what to do to to bypass it.

Your help will be much appreciated.

Omon

What are you trying to do with that variable and where are you trying to do it? It is most likely in a Script Task or a Script Component.

If you cannot find where you are referencing it then open your .dtsx package in Notepad and search for System::LocaleID

-Jamie

|||

Thanks Jamie for the response. The issue is that I do not have any variable in my package. It is just a striaght package consisting of control flow and data flow importing data from another SQL Server Db and loading into my server. I only have OLE DB Source and Slow changing dimentions for an insert (new records) and Update for a type 1 type change.

Omon

|||

Again, I opened the .dtsx in notepad and search as you suggested but found no occurence of the System::LocaleID.

Thanks for your help

Omon

|||

That's strange. Does it tell you which task is using the variable?

-Jamie

|||

Yes. I can tell from looking at the execution result.

Error: The variable "System::LocaleID" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

Thanks again.

Omon

|||

I don't like repeating myself but it seems I sometimes have to.

Does it tell you which task is using the variable? The message above does not.

-Jamie

|||

It does not tell me which task is using the variable. The message is what I pasted below without any reference to the task. It has the message in about 5 lines repeatedly.

Error: The variable "System::LocaleID" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

Thanks

Omon

|||

Can you share your package. Paste the contents of the .dtsx file up here.

-Jamie

|||

:) I'm not the guy who made the post but I occasionally get that error thrown as well even though I don't use LocaleID explicitly in my scripts or package. However if you look in the dtsx file LocaleID is everywhere

Like this for connection managers

<DTS:ConnectionManager>

<DTS:Property DTS:Name="FileUsageType">0</DTS:Property>

<DTS:Property DTS:Name="Format">Delimited</DTS:Property>

<DTS:Property DTS:Name="LocaleID">1033</DTS:Property>

<DTS:Property DTS:Name="Unicode">0</DTS:Property>

<DTS:Property DTS:Name="HeaderRowsToSkip">0</DTS:Property>

<DTS:Property DTS:Name="HeaderRowDelimiter" xml:space="preserve">_x000D__x000A_</DTS:Property>

<DTS:Property DTS:Name="ColumnNamesInFirstDataRow">-1</DTS:Property>

<DTS:Property DTS:Name="RowDelimiter" xml:space="preserve" />

<DTS:Property DTS:Name="DataRowsToSkip">0</DTS:Property>

<DTS:Property DTS:Name="TextQualifier"><none></DTS:Property>

<DTS:Property DTS:Name="CodePage">1252</DTS:Property>

Or like this for a row count

- <component id="633" name="Count of Files already imported (informational only)" componentClassID="{DE50D3C7-41AF-4804-9247-CF1DEB147971}" description="Counts the rows in a dataset." localeId="-1" usesDispositions="false" validateExternalMetadata="True" version="0" pipelineVersion="0" contactInfo="Row Count;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0">

Basically it is sprinkled all throughout the dtsx file

Anyway... its a weird error I haven't figured out yet.

I need help debuging this error message::

Hello everyone,

All weekend long I keep getting this error message when I run my SSIS package:

Error: The variable " system::localeID" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

I have search everywhere for this message without success. Could someone help to explain this and what to do to to bypass it.

Your help will be much appreciated.

Omon

What are you trying to do with that variable and where are you trying to do it? It is most likely in a Script Task or a Script Component.

If you cannot find where you are referencing it then open your .dtsx package in Notepad and search for System::LocaleID

-Jamie

|||

Thanks Jamie for the response. The issue is that I do not have any variable in my package. It is just a striaght package consisting of control flow and data flow importing data from another SQL Server Db and loading into my server. I only have OLE DB Source and Slow changing dimentions for an insert (new records) and Update for a type 1 type change.

Omon

|||

Again, I opened the .dtsx in notepad and search as you suggested but found no occurence of the System::LocaleID.

Thanks for your help

Omon

|||

That's strange. Does it tell you which task is using the variable?

-Jamie

|||

Yes. I can tell from looking at the execution result.

Error: The variable "System::LocaleID" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

Thanks again.

Omon

|||

I don't like repeating myself but it seems I sometimes have to.

Does it tell you which task is using the variable? The message above does not.

-Jamie

|||

It does not tell me which task is using the variable. The message is what I pasted below without any reference to the task. It has the message in about 5 lines repeatedly.

Error: The variable "System::LocaleID" is already on the read list. A variable may only be added once to either the read lock list or the write lock list.

Thanks

Omon

|||

Can you share your package. Paste the contents of the .dtsx file up here.

-Jamie

|||

:) I'm not the guy who made the post but I occasionally get that error thrown as well even though I don't use LocaleID explicitly in my scripts or package. However if you look in the dtsx file LocaleID is everywhere

Like this for connection managers

<DTS:ConnectionManager>

<DTS:Property DTS:Name="FileUsageType">0</DTS:Property>

<DTS:Property DTS:Name="Format">Delimited</DTS:Property>

<DTS:Property DTS:Name="LocaleID">1033</DTS:Property>

<DTS:Property DTS:Name="Unicode">0</DTS:Property>

<DTS:Property DTS:Name="HeaderRowsToSkip">0</DTS:Property>

<DTS:Property DTS:Name="HeaderRowDelimiter" xml:space="preserve">_x000D__x000A_</DTS:Property>

<DTS:Property DTS:Name="ColumnNamesInFirstDataRow">-1</DTS:Property>

<DTS:Property DTS:Name="RowDelimiter" xml:space="preserve" />

<DTS:Property DTS:Name="DataRowsToSkip">0</DTS:Property>

<DTS:Property DTS:Name="TextQualifier"><none></DTS:Property>

<DTS:Property DTS:Name="CodePage">1252</DTS:Property>

Or like this for a row count

- <component id="633" name="Count of Files already imported (informational only)" componentClassID="{DE50D3C7-41AF-4804-9247-CF1DEB147971}" description="Counts the rows in a dataset." localeId="-1" usesDispositions="false" validateExternalMetadata="True" version="0" pipelineVersion="0" contactInfo="Row Count;Microsoft Corporation;Microsoft SqlServer v9; (C) 2005 Microsoft Corporation; All Rights Reserved; http://www.microsoft.com/sql/support;0">

Basically it is sprinkled all throughout the dtsx file

Anyway... its a weird error I haven't figured out yet.