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

DTS - DTSPackageLog in Data Driven Query or Data Pump Task

In an "ActiveX Script" task, I can access the DTSPackageLog object, but in ActiveX scripts embedded in the Data Driven Query or Data Pump task, the DTSPackageLog object is not available to use.

Does anyone know why?  I don't see why DTS exposes that object for some ActiveX scripts and not others.

But the real question is, is there a way I can write to the package log while I'm in a Data Driven Query or Data Pump task?
0
khooc
Asked:
khooc
  • 2
  • 2
1 Solution
 
Anthony PerkinsCommented:
>>Does anyone know why? <<
I don't see why not.  Can you show us what you are doing and what error you are getting.

>>But the real question is, is there a way I can write to the package log while I'm in a Data Driven Query or Data Pump task?<<
You do realize the Package log does not get written to until the Package finishes, right?
0
 
khoocAuthor Commented:
Hi acperkins,

To give you an idea (SQL Server 2000 DTS),

1. Create a Data Driven Query Task or Data Pump Task and double click to see its properties.
2. Go to the Transformations tab
3. Select Name, Edit -> Properties and an ActiveX script should come up
4. Type in DTSPackageLog.WriteStringToLog "Test"
5. OK, OK, OK and try to run it.

An error should come up saying that DTSPackageLog doesn't exist.
0
 
Anthony PerkinsCommented:
You are right.  DTSPackageLog can only be used with an ActiveX Script Task.
0
 
khoocAuthor Commented:
Gee... since no one has said anything, I guess DTSPackageLog is limited in that sense.

I wonder if it'll work if you set it to a DTSGlobalVariable in a previous task and then retrieve it later in the pump/query task.

Anyway the project is done now so I'm onto other bigger and better things :-)
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.

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