question

Bugmesh avatar image
Bugmesh asked

Error during DTS migration

We have an older application that uses SQL Server as the backend. We are in the process of upgrading all of our databases servers to 2008R2 from 2000. We had to add a 32 bit dll to the database server to accomodate a Pervassive SQL runtime that the application uses. The ODBC connection has been created successfully as well. When creating/migrating the DTS package to SSIS(we have the 32bit set) The first step (connection) works just fine, but the second step fails with the following: `SSIS package "< Application Name >.dtsx" starting. Error: 0x0 at < Application Name >.: System.Runtime.InteropServices.COMException (0x80040427): Execution was canceled by user. ` Although it states the execution was canceled by the user, I can assure you this is not the case. From the text, it looks like it is still an issue with the pervasive runtime, but I am at a loss as to where to go from here. I would appreciate any insight and assistance.
ssissql-server-2008-r2dts
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Whe we changed the user in the ODBC connection to an older sql user, it appears our error went away and the step executed successfully. Is it possible that Pervasive is configured for sql authentication ONLY and not mixed mode?
0 Likes 0 ·

1 Answer

· Write an Answer
sqlaj 1 avatar image
sqlaj 1 answered
I am not familiar with Pervasive so I can't add anything there. I have seen many times where applications (third party tools) are not windows authentication friendly. Usually though they are older ones needing updating. Glad you got the issue figured out though.
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.