nigelrivett
asked on
DTS.PackageInfo
I am trying to access this from VB
VB6, sql server 7
and the code
dim objPck as DTS.PackageSQLServer
dim objPckInfs as DTS.PackageInfos
dim objPckInf as DTS.PackageIno
dim objDTSApp as new DTS.Application
set objPck = objDTSApp.GetPackageSQLSer
set objPckInfs = obkPck.EnumPackageInfos(""
for each objPckInf in objPckInfs
next
and also
set objPckInf = objPckInfs.next
both give the error Column does not exist when trying to set objPckInf.
objPckInfs.EOF is false
I can execute objPckInfs.next and get the column error until EOF = true (and it is iterating through the packages) in which case it will succeed - so it is probably something wrong with the cration of the PackageIno object.
Anyone else tried this?
VB6, sql server 7
and the code
dim objPck as DTS.PackageSQLServer
dim objPckInfs as DTS.PackageInfos
dim objPckInf as DTS.PackageIno
dim objDTSApp as new DTS.Application
set objPck = objDTSApp.GetPackageSQLSer
set objPckInfs = obkPck.EnumPackageInfos(""
for each objPckInf in objPckInfs
next
and also
set objPckInf = objPckInfs.next
both give the error Column does not exist when trying to set objPckInf.
objPckInfs.EOF is false
I can execute objPckInfs.next and get the column error until EOF = true (and it is iterating through the packages) in which case it will succeed - so it is probably something wrong with the cration of the PackageIno object.
Anyone else tried this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It's something wrong with my installation of sql server (or sql server in general). It works fine on v2000.
I don't even have the sp in msdb on v7 to enumerate the log recs.
I'll have a look at some other installations and see if it is just a problem with v7.
I don't even have the sp in msdb on v7 to enumerate the log recs.
I'll have a look at some other installations and see if it is just a problem with v7.
It may be worth loading service packs
did you try to look at
DTS.PackageIno
DTS.PackageIno
ASKER
Got service pack 3 - company uses sp2 so if doesn't work with that is pretty useless to me.
Can get the package names (which is all that I need) from msdb..sysdtspackages.
I am going to implement this as a stored procedure so don't mind accessing the system table but just wondered why EnumPackageInfos doesn't seem to work.
dts.packageinfo is a member of packageinfos which should be populated by enumpackageinfos.
Can get the package names (which is all that I need) from msdb..sysdtspackages.
I am going to implement this as a stored procedure so don't mind accessing the system table but just wondered why EnumPackageInfos doesn't seem to work.
dts.packageinfo is a member of packageinfos which should be populated by enumpackageinfos.
ASKER
Got a feeling that this only comes with v2 of the object library. Maybe only available with sql server v2000.
On a machine with only v7 installed it seems to be missing a lot of the objects.
In partucular PackageSQLServer.
On a machine with only v7 installed it seems to be missing a lot of the objects.
In partucular PackageSQLServer.
ASKER
Just to get rid of the question.
ASKER