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?