DTS Script Task - Runtime Error.

friscobay used Ask the Experts™

I'm trying to bulk load data from an XML file to a table on MS SQL Server.

I found a vbscript sample (Bload.vbs) on the MSDN website:

I just followed that procedure but i got an error (see the attachements).
You can check the vbscript too.

I need help to solve this runtime error with this DTS Script Task ?
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2014
That is written for SQL 2000 not SQL 2005. SQL 2005 uses SSIS instead.

You can use DTS with 2005 -- Download the Microsoft SQL Server 2000 DTS Designer Components from the link below.

Then in the SQL Server Management Studio under the Management --> Legacy --> Data Transformation Services try designing it there.

Feature Pack for Microsoft SQL Server 2005 - November 2005
You can use VBS in SQL 2005 - its just not going to be supported in future releases so it isn't recommended.
But you need to use an ActiveX script task, not a script task as you have done above.
Most Valuable Expert 2014

Can I ask why the B grade?

Glad to be of assistance. May all your days get brighter and brighter.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial