catogonzalez (5/15/2009)

---

My solution would be to create a 'template' excel workbook with an empty destination sheet where I only have the columns that will be written to by SSIS. In...

Please also post how you would like the active date to look after the update has been performed. Your post shows the 'before' situation only.

This isn't easy.

The way I was thinking of doing this was to use a Script Task and use Excel.Application etc etc - but that relies on a reference to Microsoft.Office.Interop.Excel,...

You are right - set Fail package on Failure to True and you should get the result you desire.

I suggest that you read up on Package Configurations - I think that will work well for you.

This sounds like a T-SQL question to me - this is the SSIS forum.

It is difficult to answer your question without seeing some sample data. Why only 5 items -...

As Luke said, fixed-width files do not generally have delimiters - they are just wasting space.

If it's just a pipe-delimited file you need, pipe can be chosen as delimiter if...

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