DTS Script Task - Runtime Error.

friscobay
friscobay used Ask the Experts™
on
Hi,

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:
http://msdn.microsoft.com/en-us/library/aa225723(SQL.80).aspx

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 ?
vbscript-BLoad.txt
dts-script-task-runtime-error.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2014
Commented:
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
http://www.microsoft.com/downloads/details.aspx?FamilyID=d09c1d60-a13c-4479-9b91-9e8b9d835cdc&DisplayLang=en
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

Commented:
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