I am attempting to import data from an access db using the wizard and I get the following error when the wizard attempts to save.
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Success)
- Saving (Error)
Messages
* Error 0xc0208220: Data Flow Task: Unable to save to XML.
(SQL Server Import and Export Wizard)
Does anyone have any ideas about how to correct this?
Without out more information I would have to say that the error is occurring because the path is non-existant, the account running the package does not have permissions to the path, or the file connection manager was set up to use an existing file and one is not there, or to create a file and one of that name already exists.sql
No comments:
Post a Comment