Right now, they're using SSRS, but I was told they're have a separate report for each and every rep... Basically they're saying they can't loop through a table and...

None of the drives are mapped... but we're pulling data from an Oracle server..

I tried using my logon, sa and one other and the same thing happens...

If...

That was one of the 1st things I checked.. and it's setup right... to quit with success,...

JohnFTamburo (2/10/2014)

---

The post seems to indicate that you are running a SSIS package in a job - correct?

When you go to Job Activity monitor, right click the "completed" job and...

Lowell (3/14/2011)

---

you posted in a SQL 2000 forum...are you stuck with SQL 2000, or are you in SQL 2005 or above?

if you Are in 2005 or above, what is...

Lowell,

Thanks for the info, but it doesn't seem to work, no matter what I query because of the part of the query.

Any idea on how to get around the error:

Server:...

I'm getting the same error and I know it's a problem with SQL 20000.

Last week when I ran the DTS with the same file on SQL 7, it...