By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

problems when trying to use the import wizard on mssql2005

mikek12004
100+
P: 200
I want to move some data from one table to another but when I press finish after specifing my parameters to the wizard (in the last step I choose 'execute now') I get this error message:
"
- Execute the transfer with the TransferProvider. (Error)
Messages
ERROR : errorCode=-1073659879 description=The connection manager "DestinationConnection" will not acquire a connection because the package OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired.
helpFile= helpContext=-1073659879 idofInterfaceWithError={8BDFE931-E9D8-4D23-9739-DA807BCDC2AC}

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

ERROR : errorCode=-1073573396 description=Failed to acquire connection "DestinationConnection". Connection may not be configured correctly or you may not have the right permissions on this connection.
helpFile= helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

ERROR : errorCode=-1073659879 description=The connection manager "DestinationConnection" will not acquire a connection because the package OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired.
helpFile= helpContext=-1073659879 idofInterfaceWithError={8BDFE931-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476
"
what is this OfflineMode property and how can I set it to true? will this solve my problem?
Feb 12 '09 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.