There are 2 servers:
Server A: Database Pervasive 32 bit vers. 9.5
Server B: Database Sql 2008 64 bit
I want to copy records from one table in Pervasive db in another table structured in the same mode in server B.
From Sql server Business Intelligence Development Studio I've created a Integration Service project. In control flow there are 2 objects:
1. Sql task that empty the destination table
2. Execute package task that call the package created from the sql tool "import/export data (32 bit)"
In debugging properties of the project the property Run64BitRuntime is set to False.
When I run the project it execute all fine but at the end an error message box advise that SSID debug host has stopped working (details: AppCrash DtsDebugHost.exe).
Someone have any suggestion?
Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.