Howard C. BAchtel (6/25/2009)

---

I have a process (SSIS) that I would like a user to be able to initiate on demand, primarily from MS Access. Is there an equivalent...

Have you seen Keelio's XML Destination Component?

paul.corujo (6/22/2009)

---

Hey,

I need to export blob or text data to a csv file. The problem i am coming across is that this data sometimes contains a comma in it....

Do you expect to have worksheets other than birth_ratios, u_codes and c2c_followup ?

If not , then this is straightforward:

1. First create a workbook in Excel, which contains the 3 mentioned...

oh, you have actually expanded your original question considerably. You should get ready to limit your expectations regarding what can be accomplished with SSIS. This sounds now more like a...

Create a template .XLS file. In your loop, copy the template to a another file with the name you require for the current iteration.

This is a duplicate post. The question is being answered here.

winslet (6/18/2009)

---

Thanks for you reply CozyRoc,

But the package was created on 2005 server itself and am running this "RSExecutionLog_Update.dtsx" on my local machine.

My machine has SQL 2005 and SQL 2008...

Paul,

But that is what I suggested. You don't have to write your own class . You already have BufferedStream and FileStream (which is also buffered). Unfortunately this didn't help. There...

Is it possible to run performance counters on the server and see where all the time is spent?

I don't know what is your network hard drive, but if it is not designed to handle parallel processing, then this might be your bottleneck. I have seen SAN type...

John Rowan (6/18/2009)

---

Phil Parkin (6/17/2009)

---

You have mentioned "Script Task" and "Script Component" as if they are the interchangeable - they are not. Just for clarification, I'm assuming that you mean...

Actually you can use FileStream, which is also buffered. Here is how you can construct it:

textWriter(i, j) = New StreamWriter(New FileStream(basepath + "day" + CStr(i) + "idwcdp" + CStr(j) +...

It looks like you are trying to execute SSIS package generated with SQL 2008 on SQL 2005 or something similar.

I'm talking about this error in particular:

Package migration from version 3...

Have you tried using BufferedStream ?