Please check the following task properties for your ActiveX script:

Fail Package on Failure

Force Execution Value - if true, what is Forced Execution Value

🙂 now you're making me sound like I'll need diagrams before I understand.

Just carry on as you are and I will have fun working out the bits you omit!

Ramesh (5/12/2009)

---

In this case, "CleanLine" is indeed a DT_WSTR with 4000 max. characters, but I assumed:-) that you understood that "CleanLine" needs to be reversed to TEXT data before sending...

So you have a single string:

"Foo1, Foo2, etc etc"

and you want to issue a call to a web service multiple times - once for each item in the list?

Sorry if...

So which bit are you asking for help on? Retrieving the string from an XML file (which appears to be masquerading as a CSV file) or using the retrieved string...

CozyRoc (5/11/2009)

---

Phil Parkin (5/11/2009)

---

Hi guys - I bet you thought that this was all over? :hehe:

I tried out Ramesh's code and have a follow-up question: what is the data type...

Hi guys - I bet you thought that this was all over? :hehe:

I tried out Ramesh's code and have a follow-up question: what is the data type of 'CleanLine'? Looks...

The last part of the error message actually states that the step succeeded too - it's just that there was an error in it.

Can you post the code for the...

CozyRoc & Ramesh - great work, thanks for the help.

Ramesh (5/11/2009)

---

I overcome this issue by converting the text column back to string and then doing the replace in SSIS Script component.

Here is that script:

Imports System

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class ScriptMain...

OK, I did this in a test environment to check. I have an OLEDB Source which just does a...

Thanks for the idea - tried it and:

The function REPLACE does not support the data type "DT_TEXT" for parameter number 1. The type of the parameter could not be explicitly...

Sorting a 10GB text file? I can imagine some complaints from the server ....

You should try the XML source adaptor in SSIS and see whether that can do it for you (it does not work for all XML variants).

If you are looking for...

- Create an int variable, scoped at package level, to hold the rowcount results.

- Use an Execute SQL task to run the count query and assign the result to rowcount

-...