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.
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.