A whole resultset?

CEWII

Hold on..

FTP does not work on shared folders. FTP works on the FTP protocol. shared folders work on the SMB protocol. They are NOT interchangeable.

Now within http://FTP...

Yes, that is your big challenge. I don't know of a way to catch the last row any way. Even using a script component I don't know of...

>Activate Sarcasm Mode

Sarcasm Model Activated, proceed with sarcastic conversation.

It took to Exchange 2010 to do this? I mean just off the top of my head I can name 4...

1. The flat file source will not do this automatically for you.

2. Maybe.

The real question is whether you can tell the last record from all the other records, by something...

Has the XML schema been updated?

CEWII

Luke L (3/2/2010)

---

It wasn't really meant as scaremonering, just some thoughts from someone who did a stint as a security researcher for a while. It seems to me that...

Not there.. You could potentially add a Conditional split after the Excel source on the Data-Flow and discard those rows.

CEWII

Also, you might look at this thread:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/5f045ba9-f39a-496d-8998-7ed7ae75e904

CEWII

Luke L (3/2/2010)

---

If it was easy to do and you could get even one tiny back door to a publicly hosted OWA server I'd think this would be just the...

My first question is how you are populating the system.object variable in the variables setup?

CEWII

What you need to do is add a lookup step between the source and the destination.

In SSIS 2005 you have to configure the error path to do this.. You...

You can't reference drive paths from http://FTP..

In FTP all paths are relative to your root path which should always be /

Figure out what your relative path is by using the...

I know you can access the message store from OWA, I can't find the libraries to do this though right now. I don't see what this has to be...

Ok, first issue, logging. Yo may need to look at the logging of that FTP component explicitly, you should be able to set options on it alone. I'm...