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?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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?
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.
Anthony PerkinsCommented:
You are right.  DTSPackageLog can only be used with an ActiveX Script Task.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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 :-)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.