February 13, 2009 at 3:16 am
Hi,
I tried to use dtsrun to execute a SQL 2000 DTS package in my SQL 2005 Enterprise Edition and got the following error :
C:\>dtsrun /S"server99" /U"user001" /P"pass001" /N"Customer Data Load" /M"xxx"
and got the following error :
........
Error Source=Microsoft VBScript runtime error
Error Description: ActiveX component can't create object: 'DTSHelper.CErrorInfo'
Any ideal ?
February 13, 2009 at 6:59 am
I don't remember what they are off the top of my head, but there are specific things you need to do before you can run DTS packages from SQL 2k5. Is this the first / only DTS package you've run from SQL 2k5?
If not, then I recommend seeing what is incompatible between your DTS package and SQL 2k5. The error says it all there: ActiveX error in your script task.
ActiveX was changed in SQL 2k5 and translates into stubs when imported into SSIS, so there's probably some sort of translation issue.
February 13, 2009 at 8:11 pm
yes, it was the first time running DTS package in my SQL 2005, do you know what things do I need to configure or install ?
February 16, 2009 at 5:28 am
Google running DTS in SQL Server 2005. Also, check this link for backward compatibility components:
I believe you have to have the backward compatibility installed prior to running DTS. I'm sure the documentation for this will have more details. BTW, the BC components are about halfway down the page.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply