I had the same problem and checked every conceivable log and even did profiler traces to no avail.

I finally stumbled onto a solution that at least worked for me. It...

Me too help Please.

All of a sudden the check database integrit task in maintenance plan started failing on one of our Sql servers:

Microsoft SQL Sql Server 2005- 9.00.4053.00

Some...

I have the same problem ....

All of a sudden the check database integrit task in maintenance plan started failing on one of our Sql servers:

Microsoft SQL Sql Server...

Brad,

I have had no luck but a ticket has been put in to IBM to see if there is something on the AS400 that is gumming up the works. See...

SSChasing Mays,

I get the same error when I test the connection manager in SSIS using either of the following IBM . net Providers:

.Net Providers\IBM DB2 .NET Data Provider 9.5.0 or...

SSChasing Mays,

I am trying to give the cozyRoc component will little success. I installed IBM Data Server Runtime Client as directed. I had a live web support chat with a...

John, Thanks for the fast reply. I have not really looked into any third party tool or proprietary import/export tools yet and I have to admit I have been only...

Steveb.Thanks for the quick responce,There are no transformations just a simple data flow task with a SQL server 2005 data source and a AS400 destination. I would hate to think...