• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 256
  • Last Modified:

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.GetPackageSQLServer("local)","sa","pwd",DTSSQLStgFlag_def
set objPckInfs = obkPck.EnumPackageInfos("", false, "")

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?
0
nigelrivett
Asked:
nigelrivett
  • 5
  • 2
1 Solution
 
PUMASOFTCommented:
If you have cut and paste code into this question - could it be a misspelling of obkPck.EnumPackageInfos("", false, ""), could it be obJPck.EnumPackageInfos("", false, "")


0
 
nigelrivettAuthor Commented:
Sorry - I didn't paste I retyped it all (incorrectly).
0
 
nigelrivettAuthor Commented:
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.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
PUMASOFTCommented:
It may be worth loading service packs
0
 
mironCommented:
did you try to look at

DTS.PackageIno
0
 
nigelrivettAuthor Commented:
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.
0
 
nigelrivettAuthor Commented:
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.
0
 
nigelrivettAuthor Commented:
Just to get rid of the question.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 5
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now