Convert ActiveXScript task

Question

Post reply

Convert ActiveXScript task

Viewing 11 posts - 16 through 25 (of 25 total)

You must be logged in to reply to this topic. Login to reply

jani_shirish SSC Enthusiast Points: 190 More actions · Answer 1

jani_shirish

SSC Enthusiast

Points: 190

September 21, 2010 at 11:12 am

#1225070

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)

jani_shirish SSC Enthusiast Points: 190 More actions · Answer 2

jani_shirish

SSC Enthusiast

Points: 190

September 21, 2010 at 11:18 am

#1225075

can you please elaborate what is that

COZYROC One Orange Chip Points: 28499 More actions · Answer 3

jani_shirish (9/21/2010)

can you please elaborate what is that

When you open ActiveX Script Task dialog and go to the place where you entered the script, there is a property right under named EntryMethod. You have to specify the entry function name in the script because the task cannot determine this automatically.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

jani_shirish SSC Enthusiast Points: 190 More actions · Answer 4

jani_shirish

SSC Enthusiast

Points: 190

September 21, 2010 at 11:30 am

#1225089

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

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

COZYROC One Orange Chip Points: 28499 More actions · Answer 5

jani_shirish (9/21/2010)

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

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

You have to install the DTS 2000 runtime. Check this article how to install the support.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

jani_shirish SSC Enthusiast Points: 190 More actions · Answer 6

jani_shirish

SSC Enthusiast

Points: 190

September 21, 2010 at 11:45 am

#1225104

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 want to move this to server which has SQL 2008 R2 Only

Do i need to Install DTS Runtime

Or there is another way to achive this

Please provide you thought on same.

COZYROC One Orange Chip Points: 28499 More actions · Answer 7

jani_shirish (9/21/2010)

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 want to move this to server which has SQL 2008 R2 Only

Do i need to Install DTS Runtime

Or there is another way to achive this

Please provide you thought on same.

You can implement this script using the new VB.NET script. In this way you will not need the old DTS 2000 runtime.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

jani_shirish SSC Enthusiast Points: 190 More actions · Answer 8

jani_shirish

SSC Enthusiast

Points: 190

September 21, 2010 at 12:19 pm

#1225136

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 me the changes that required in script that i have added

Thanks

Phil Parkin SSC Guru Points: 245813 More actions · Answer 9

jani_shirish (9/21/2010)

I am not good at vb

can you suggest some way to achive this

--

Time to learn, or pay someone to do it for you.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Alvin Ramard SSC-Forever Points: 41190 More actions · Answer 10

Phil Parkin (9/21/2010)

jani_shirish (9/21/2010)

I am not good at vb

can you suggest some way to achive this

--

Time to learn, or pay someone to do it for you.

I have to agree. This is getting outside the scope of my contract.

Alvin Ramard
Memphis PASS Chapter[/url]

All my SSC forum answers come with a money back guarantee. If you didn't like the answer then I'll gladly refund what you paid for it.

For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]

satriodie Newbie Points: 5 More actions · Answer 11

satriodie

Newbie

Points: 5

September 29, 2010 at 11:07 pm

#1229461

I DID INSTALL RUN TIME FOT DTS 2000 AND ALL WORK FINE...THANKS!!!!!!!!!