DTS from SQL Server to DB2

I tried to copy tables from SQL Server 2000 to DB2 UDB by using DTS
package through ODBC, but always got an error that says:

"The number of failing rows exceeds the maximum specified.
[IBM][CLI Driver] CLI0150E Driver not capable, SQLSTATE=S1C00"

However, I can copy tables inversely from DB2 to SQL Server without
problem, and I can also copy tables to other non DB2 databases through
DTS.

DB2 Client is properly installed on SQL Server side, and can access to
DB2 Database successfully.

When I run DTS package, it can talk to DB2 database, and create a target
table (i.e. no connection problem), but failed to add data into the
table.

The problem appears after we upgraded Windows 2000 Server Service Pack
from SP2 to SP4. According to the error message, it seems that DB2 CLI
Driver is not happy about something.

Can anybody shed some light on the issue?

Thanks a lot

Jian

--
Posted via Mailgate.ORG Server - http://www.Mailgate.ORGI am having a similar problem.

When using DTS designer when I click on the destination tab of the
data pump I get this error:
Error Description: Unspecified error
[IBM][CLI Driver][DB2/AIX64] SQL1131N DARI (Stored Procedure) process
has been terminated abnormally. SQLSTATE=38503

But the DB2 table comes up fine.

Then when I run the dts package I get this error:
The number of failing rows exceeds the maximum specified. [IBM][CLI
Driver] CLI0150E Driver not capable. SQLSTATE=S1C00

Does anyone have any ideas how to resolve this?

Thanks,
Sarah Larson|||I have just completed a migration to a new SQL Server and this problem
has reared its ugly head. I can continue to import data to SQL Server
from DB2, I can run an 'Execute SQL Task' to delete data from a DB2
table, but any attempt to insert fails instantly with 'The number of
failing rows exceeds the maximum amount specified.

The 'old' server was at W2K Advanced Server SP2 with SQL Server 2000
Ent at SP3 and ran exports to DB2 without issue.

The new server is W2K Advanced Server SP4 with SQL Server 2000 Ent
also at SP3.

It does seem that the W2K SP4 could be the cause of the problem and if
anyone has a solution to this issue I should be very grateful to know.

Regards

Clare Hilditch|||I had the same issue and resolved it by changing the connection type in DTS from the regular ODBC driver to IBM OLE DB Provider for DB2. Everything worked after that change.

DTS customization

Dear techs,

Hmm...I have a little problem using DTS. I made a simple DTS
package where it extracts data from my database using a Stored
Procedure and then exports it into a list. But everytime I export, it
overwrites the file ('caused by statically entering the location of
the file in Enterprise Manager) but I don't want it to do that. I want
it to do something like this:

1. After exporting the first time, I want it to label as
sample20030904.csv
2. The next time I export again, I want it to create another file and
label as sample20030905.csv

Is it possible to do something like that?

Ansonanson.zeall@.quicken.com.au (anson) wrote in message news:<7a13e84c.0309032008.7824d3be@.posting.google.com>...
> Dear techs,
> Hmm...I have a little problem using DTS. I made a simple DTS
> package where it extracts data from my database using a Stored
> Procedure and then exports it into a list. But everytime I export, it
> overwrites the file ('caused by statically entering the location of
> the file in Enterprise Manager) but I don't want it to do that. I want
> it to do something like this:
> 1. After exporting the first time, I want it to label as
> sample20030904.csv
> 2. The next time I export again, I want it to create another file and
> label as sample20030905.csv
> Is it possible to do something like that?
> Anson

One way is to use a global variable for the file name, then you set it
and assign it to the connection in an ActiveX step, or with a dynamic
properties task. This should help you get started:

http://www.sqldts.com/default.aspx?200

Simon

DTS & .NET

I have a simple DTS package that is being executed within a .Net application using the MS DTSPackage Object Library. Since I have the SQL Server 2000 desktop tools installed, the package executes with no problems, however, when another user tries to execute it, the following exception is thrown:

Retrieving the COM class factory for component with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} failed due to the following error: 80040154

I've tried including all the DTS references, rather than just the Package object reference, and that didn't help.

Thanks in advance for your help. THis is really frustrating.

Hi toneho,

are you using PackageEvents interface?

Can you provide us a sample?

|||0x80040154 is 'class not registered', i.e. DTS is not installed on this machine.
Solution - you need to install it :)

P.S. This is SSIS forum, not DTS.|||

It is my understanding that the DTS forum was changed to the SSIS forum.

So I included the DTS packageobject interop in my application - what more needs to be done to install DTS?

|||

toneho wrote:

It is my understanding that the DTS forum was changed to the SSIS forum.

So I included the DTS packageobject interop in my application - what more needs to be done to install DTS?

Try: http://groups.google.com/group/microsoft.public.sqlserver.dts/topics?lnk=srg|||Interop is just that - interop, that allows you to talk to COM object from .NET code. You need the actual COM object installed - e.g. install DTS from SQL 2000 CD :)