dbTalk Databases Forums  

Execute DTS 2000 Package Problem

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Execute DTS 2000 Package Problem in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
 
Posts: n/a

Default Execute DTS 2000 Package Problem - 12-14-2005 , 02:18 AM






hi,
I'm using an Execute DTS 2000 Package task in SSIS.
I can choose Structured Storage File and pick up a pcakge name, but I get
an error while setting inner variable.
===================================
Invalid class string
(Microsoft Data Transformation Services (DTS) Package)
------------------------------
Program Location:
at DTS.PackageClass.LoadFromStorageFile(String UNCFile, String Password,
String PackageID, String VersionID, String Name, Object&
pVarPersistStgOfHost)
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Pa ckageUtils.LoadDTS8Package(String
pkgSrc, String sourceUser, String sourcePwd, Int32 srcType, Boolean
bUseTrustedConnection, String packageName, String packagePassword, String
packageID, String packageVersionGUID)
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.In nerView.LoadDTS8Package()
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.In nerView.OnSelection()

I'm sure I can edit it in SQL Server CTP SEP.
What do I miss?

Any help is very appreciated.




Reply With Quote
  #2  
Old   
 
Posts: n/a

Default Re: Execute DTS 2000 Package Problem - 12-14-2005 , 02:39 AM






Sorry, It's my problem.
I forget to resister my user-designed custom DTS task.
It reminds me.
http://support.microsoft.com/kb/2889...-us&sd=gn&fr=0

++++++++++++++++++++++++++++++++++++++++++++++++++
hi,
I'm using an Execute DTS 2000 Package task in SSIS.
I can choose Structured Storage File and pick up a pcakge name, but I get
an error while setting inner variable.
===================================
Invalid class string
(Microsoft Data Transformation Services (DTS) Package)
------------------------------
Program Location:
at DTS.PackageClass.LoadFromStorageFile(String UNCFile, String Password,
String PackageID, String VersionID, String Name, Object&
pVarPersistStgOfHost)
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.Pa ckageUtils.LoadDTS8Package(String
pkgSrc, String sourceUser, String sourcePwd, Int32 srcType, Boolean
bUseTrustedConnection, String packageName, String packagePassword, String
packageID, String packageVersionGUID)
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.In nerView.LoadDTS8Package()
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.In nerView.OnSelection()

I'm sure I can edit it in SQL Server CTP SEP.
What do I miss?

Any help is very appreciated.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.