Groups | Blog | Home
all groups > sql server dts > december 2005 >

sql server dts : Execute DTS 2000 Package Problem


<1900>
12/14/2005 4:18:46 PM
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.PackageUtils.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.InnerView.LoadDTS8Package()
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.InnerView.OnSelection()

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

Any help is very appreciated.


<1900>
12/14/2005 4:39:13 PM
Sorry, It's my problem.
I forget to resister my user-designed custom DTS task.
It reminds me.
http://support.microsoft.com/kb/288910/en-us?ln=en-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.PackageUtils.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.InnerView.LoadDTS8Package()
at
Microsoft.SqlServer.Dts.Tasks.Exec80PackageTask.InnerView.OnSelection()

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

Any help is very appreciated.



AddThis Social Bookmark Button