for that Right click database enginee

select facets

on facet select surfaceareaconfiguration at last

set xpcmdshellenabled to true

I am not good at vb

can you suggest some way to achive this

After all i am converting my data to xml and send to destination

or you can suggest...

Thanks For your help i have achive this

I have one PC with sql 2000 and is Running fine on that

Thanks A lot

I have question

I in future...

i find error

TITLE: ActiveX Script Task

------------------------------

An error occurred while adding the managed SSIS type library to the script host. Verify that the DTS 2000 runtime is installed.

------------------------------

BUTTONS:

OK

------------------------------

can you please elaborate what is that

Error at ActiveX Script Task [ActiveX Script Task]: Function not found.

Error at ActiveX Script Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

TITLE: Package Validation Error

------------------------------

Package Validation Error

ADDITIONAL INFORMATION:

Error at ActiveX Script Task [ActiveX Script Task]: Function not found.

Error at ActiveX Script Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at ActiveX Script Task [ActiveX Script Task]: Function not found.

Error at ActiveX Script Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------

BUTTONS:

OK

------------------------------

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at ActiveX Script Task [ActiveX Script Task]: Function not found.

Error at ActiveX Script Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------

BUTTONS:

OK

------------------------------

TITLE: Package Validation Error

------------------------------

Package Validation Error

------------------------------

ADDITIONAL INFORMATION:

Error at ActiveX Script Task [ActiveX Script Task]: Function not found.

Error at ActiveX Script Task: There were errors during task validation.

(Microsoft.DataTransformationServices.VsIntegration)

------------------------------

------------------------------

but by running ssis it says function not found

still i am not able to resolve it

do i need to use in script task

or what are the changes i need to do

please help me

i got error Function not found