If you are facing problems in “Choose a destination” option while importing and exporting data using Microsoft SQL Server DTS (Data Transformation Services) Import/Export Wizard, specifically the error mentioned below then this post may be helpful for you to get it solved.
DTS Import/Export Error
Error Source: Microsoft OLD DB Provider for SQL Server
Error Description: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied
Inappropriate database drivers.
In the Data Source combo-box
Select Microsoft ODBC Driver For SQL server
Microsoft OLE DB Provider For SQL server
Unable to validate data, ASP.net error at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte buf, Byte modifier, Int32 start, Int32 length, Int32& dataLength) at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString)
This is an View state decoding error.
The basic reason of this is the difference of key while encrypting and decrypting the viewstate data. Suppose an asp.net rendered a page with key1 and saved the page state in view state, meanwhile asp.net’s key is changed to key2, now when some server side event will occur on page the viewstate will get decrypted and this error will occur as the old view state is now not valid due to a different encryption key.
It may occur when you open a page for along time and after that do some events on that.
Fix the key in your web.config file, so that only one key is used to encrypt and decrypt the viewstate data.
For more information visit: