FTP Task - File represented by _does not exist.

I've done some searcing on this forum and online. I found one thread that talked about this problem, but it didn't seem to help me at all.

I have a package that downloads an xml file from a ftp server for processing. The file is named after the day that it was put on the ftp server. So, to help the situation I created a variable that gets set to the proper name before the FTP Task fires.

Now, I've been working with this SSIS task for just over 2 months and haven't seen this issue ONCE until I deployed it on the production helper server. All of my other SSIS tasks are working fine in my other Tasks.

I have set DelayValidation to true for the FTP Task, I have moved around the time the task gets run. This is what is really tricky. If I fire off the task manually (by running the batch file that runs all my tasks on the console) it works fine! I've ran it 3-4 times throughout the day manually and it works perfectly! However, whenever it is scheduled to be run in the middle of the night, it fails!

This problem has stumped me good. I can run the task manually, but when I run it scheduled, I get : File represented by "User::ftpXmlPath" does not exist.

Any help would be appreciated. Thanks!If you start the Job (not run the batch file) manually at about the same time when the manual batch file execution works, what happens - does the Job succeeds or fails? (Just to figure out the time dependency).
Does the FTP connection require authentication? One possible explanation of this problem - if the FTP requires authentication, and the authentication fails when running under Agent, the anonymous user can't see that file. Please see this KB which explains possible issues with authentication when running under Agent, and how to troubleshoot and fix them.
http://support.microsoft.com/kb/918760|||I've thought of the time difference. I think that's what's to blame. Although all my technical documents for the feed suggest that the file is posted by 1 AM. I have the process running at 4 AM.

The permissions aren't the issue. I am running all of the packages with a scheduled task batch file against the console. The sched task user is in the administrator group. I am stumped.

Thanks for the reply!

FTP Task - File represented by _does not exist.

I've done some searcing on this forum and online. I found one thread that talked about this problem, but it didn't seem to help me at all.

I have a package that downloads an xml file from a ftp server for processing. The file is named after the day that it was put on the ftp server. So, to help the situation I created a variable that gets set to the proper name before the FTP Task fires.

Now, I've been working with this SSIS task for just over 2 months and haven't seen this issue ONCE until I deployed it on the production helper server. All of my other SSIS tasks are working fine in my other Tasks.

I have set DelayValidation to true for the FTP Task, I have moved around the time the task gets run. This is what is really tricky. If I fire off the task manually (by running the batch file that runs all my tasks on the console) it works fine! I've ran it 3-4 times throughout the day manually and it works perfectly! However, whenever it is scheduled to be run in the middle of the night, it fails!

This problem has stumped me good. I can run the task manually, but when I run it scheduled, I get : File represented by "User::ftpXmlPath" does not exist.

Any help would be appreciated. Thanks!
If you start the Job (not run the batch file) manually at about the same time when the manual batch file execution works, what happens - does the Job succeeds or fails? (Just to figure out the time dependency).
Does the FTP connection require authentication? One possible explanation of this problem - if the FTP requires authentication, and the authentication fails when running under Agent, the anonymous user can't see that file. Please see this KB which explains possible issues with authentication when running under Agent, and how to troubleshoot and fix them.
http://support.microsoft.com/kb/918760|||I've thought of the time difference. I think that's what's to blame. Although all my technical documents for the feed suggest that the file is posted by 1 AM. I have the process running at 4 AM.

The permissions aren't the issue. I am running all of the packages with a scheduled task batch file against the console. The sched task user is in the administrator group. I am stumped.

Thanks for the reply!

free online crystal report classes?

Anyone know any free online CR classes? or a good tutorial site?
thankstry this URL :

http://www.businessobjects.com/support/default.asp|||thats not free, but thanks anyways.

i found this website that sells cheap training CDs, wondering anyone ever purchased from this sit before? plz give me some comments about their products.

thanks

free code

Hello, I am 13 years old and trying to create a mmorpg(massively multiplayer online role playing game) and need a database so people can register, buy weapons, kill other people, etc. The only problem is, I only know javascript and html. I was wondring if anyone had free code for MS Server 2000 that users of my game register, and it records the users username, password, etc.
Thanks so much,

-tylerhttp://lab.msdn.microsoft.com/express/sql/

And you should google data modeling techiques BEFORE youstart build the database

Or ask here

Good Luck|||http://lab.msdn.microsoft.com/express/sql/dude, he's not looking for sql server itself, he's apparently already got a database server, he's looking for application code

specifically, "that users of my game register, and it records the users username, password, etc."|||He should ask an Elf. They are supposed to be good at data modeling and get +2 on all schemas they create.

Though I hear dwarves excel at data-mining...|||well, he asked the experts

and three trolls answered ;)|||Trolls, as every game designer knows, automatically regenerate code.|||Tyler,

There are so many different ways that this task can be handled, depending upon the requirements of the application, that I don't think you are going to find a black-box solution you can succesfully drop into your program.

The good news is that tracking users is not a very complicated task, so it should not require many tables or a lot of SQL coding, depending upon how complex you want the security and user-rights to be.

And since you are only 13, you have many years to figure out what is going to work best for you.

If you decide to take on this task and have specific questions, then please post them here and we will try to help you out.

...now go finish your homework!|||tyler
pick up a copy of database design for the mere mortal.
and read how the tables and data relate to each other.
then start designing your db and ask as many questions here as you can.|||dude, he's not looking for sql server itself, he's apparently already got a database server, he's looking for application code

specifically, "that users of my game register, and it records the users username, password, etc."

Dude?

Already got a database server?

OK, so it's not crack...but what is it?

I think it's a martini Friday...|||thanks guys... though you didn't give me the code, i am glad you have responded... And i convinced my dad to create a database for me. He is a programmer...

Thanks Again

-Tyler|||Yeah dad! Go dad!

Dads are great.