Check out this article on horizontal tables.

http://blogs.msdn.com/b/chrishays/archive/2004/07/23/horizontaltables.aspx

Phil

We are using a network user not a local user and make sure the user has permissions to write to the folder.

Have you looked at using a document map?

Phil

You can handle commas in the data if you use a double quote as a text qualifier. In the flat file connection on the General page set Format to...

We are using WinSCP and the below blog post was very helpful.

http://www.bidn.com/blogs/KeithHyer/bidn-blog/633/winscp-from-ssis-secure-ftp-transfers

We have done this with several servers and have found the order that Oracle is installed is important. Below are some of our notes from the steps we use.

Install...

I am doing something similar to what you are trying to do using one tablix. The dataset contains 5 weeks of data. The tablix has two columns. ...