ended up deleted the connection manager for the FTP and copied it from another package and that seemed to do the trick

thanks for all the suggestions

John Mitchell-245523 (6/9/2014)

---

Could it be a firewall or routing thing? Presumably when you run it from BIDS, you're doing it from your PC, whereas with SQL Server Agent, it...

When I run the package in BIDS, I am running it under the same proxy account as the job in order to make sure things are as identical as possible.

the issue ended up being that I was using a copy of the ssis package when i was trying to troubleshoot. Any changes I made was not saving to the...

it does. It has read/write/modify permissions

The database is in full recovery mode. I have checked to see if a transaction log needed to be taken and it didn't.

ok thank you for the replies. This confirms my suspicions.

I didn't change the security level of the package. I shouldn't have to as I was just adding some tasks to the package. What I found on the...

looks like sqlevn70.dll is the culprit.

Should i download software to repair it?

i will check the event log.

There are no jobs that are failing, that's why this is even more confusing

it's the server itself that is trying to loging using the sa login and password, that's why i ran profiler

just confused...

Thank you for all the help. I realize what i need to do.

the table is called invoice_fact but when i imported it into analysis services it shows up at invoice fact.dim. is there a way i can make this show up...

then i'm not sure what i'm doing wrong. I bring the field in but when i go to process the cube it tells me it can't because there are...

These are comments on particular invoices and the same comments can be put on multiple invoices. so if you just look at the comments, there are duplicates. But...