Your signature contains a link to posting best practices, yet your post does not follow them!

Are you referring to Excel when you talk about 'sheets'?

Is any data involved, or are...

If you need more sophistication in your record selection than is possible in Conditional Split, the Script Component will also do it.

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 ....