May 13, 2008 at 8:16 am
Hi guys, I have to do some migration from sql server 2k to sql server 2k5 but when I use the dts migration wizard I get an error which is the one above. I have crawling the web but with no luck :doze:
Any ideas? hope you guys can help me. Thanks in advance.
TITLE: DTS Migration Wizard Error
------------------------------
Exception of type 'Microsoft.SqlServer.Dts.MigrationWizard.HelperUtility.DTSMWException' was thrown.
Click Abort to stop the migration of the current package.
Click Retry to retry the operation.
Click Skip to skip the migration of the current task and continue with the next task.
------------------------------
BUTTONS:
&Abort
&Retry
&Skip
------------------------------
May 13, 2008 at 8:59 am
Definitely can't tell what's wrong from that. It looks like a generic error message of some sort. Is it possible to rebuild the DTS package manually as an SSIS package?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 15, 2008 at 3:37 pm
yeah that is what I have trying to do but I still can't get around an error I am getting at the moment of generating my sql command.
I am thinking that the problem is the access my sql server agent service has over the tempdb, I am guessing it has none because when I execute my sql command using query analyzer, it works perfectly fine but when I try to put it inside a a OLE DB Source, it gives me this error:
===================================
Error at DTSTask_DTSDataPumpTask_1 [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Invalid object name '#TEMP_PREV'.".
Error at DTSTask_DTSDataPumpTask_1 [OLE DB Source [1]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available.
(Microsoft Visual Studio)
===================================
Exception from HRESULT: 0xC020204A (Microsoft.SqlServer.DTSPipelineWrap)
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ReinitializeMetaData()
at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.ReinitializeMetadata()
at Microsoft.DataTransformationServices.DataFlowUI.DataFlowAdapterUI.connectionPage_SaveConnectionAttributes(Object sender, ConnectionAttributesEventArgs args)
and this is because I create a temporary table which I wanna use in my sql command :ermm:
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply