Did you check your connection manager for the destination? Sometimes it is just simple things like this. See if that is pointing to your destination correctly.

Okay in that case, you can do this.

1. In dataflow do all your part to behave like if there are any data coming.

2. But in the Control flow, do a...

I tried every way that is posibble and mine worked well. But I have the flat files on my desktop itself. Where are you getting the flat files from. Could...

I am having similar issues. Did you find a way out? Anyone to help?

You Guys could also use SSIS which is easier. But to do it you must have SSIS knowledge first! Read from the SS2K5 Integration forum here.

I totally agree with all three above. I have all of them and I know what he is talking about. But do some practice on the environment and read the...

Usually people want to have the file no matter if there is data coming or not. But I can understand your requirement.

But before that, I have another question, let...

Wow! This is a unique one. Usually I have seen people having problem when they have different filename according to date (today, tomorrow and so on) I have advise many...

I think Adam's method will work too. This way, you will at least have the job there and run it randomly as you wanted as many time as posibble.

Actually there are many ways to do this. I prefer this way. But before doing this, I have to ask you if you only get one file each day? If...

I don't really get you. What are you trying to do?How does it come to SSMS?

I have used SCD transformation previously. But then again, as you are facing problem with performance and latency, SCD is much more slower doing that. I would recommend using some...

You mean you did not have username and password at all when it said test connection success?

If you want a quick and easy way to solve this, pass it throgh Copy column or Sort transformation. Try doing this and you will understand what I mean. Usually...

I am not getting what you are trying to do. Could you please be more specific so that others would also understand better and many will reply to your question...