I have a some problem to run SSIS package in windows 2008 R2 edition.
I have created ODBC for Pervasive SQL server and I want to copy data from Pervasive SQL to SQL server.
I have created one SSIS package and put Data Flow Task. I have used ADO .NET source datbase as ODBC provider for PSQL and
ADO .NET destination database as SQL server.
Now, When I run SSIS package, I get error says "SSIS debug host has stopped working."
Both Source and Destination task are in green color. All rows are transfered successfully from source to destination. but post execute only 50% complete.
Before I have windows 7 and SSIS package was running completely there. I know PSQL has 32 bit supported and I already set Run64BitRuntime=false.
Can anybody help me to troubleshoot this error?