I'd suggest checking the security logs on the server where the files are located if possible. There's got to be a message somewhere even though the Agent and package...

Ramdas likely has the correct interpretation given the Oracle forum, but even a casual search of the term shows a wide variety of "definitions".

Frankly, when I saw the topic header...

Abso-freakin-lutely an "error table" would be awesome. When you think about it, implementing error trapping and handling in SQL Server isn't *that* difficult but I can't tell you how...

In addition to opc.three's comments, you probably also need to configure a SQL Server proxy to run your SSIS package using a job. That proxy account will also need...

All in all, you're taking a really good approach to the matter.

Probably the best advice I ever heard about job/career choices is "What would you do even if you never...

I use Subversion for most things, but like Miles, there are things I do which are one-off throwaways that don't go into source control. Anything that might ever make...

Maybe this will help:

I'm really resisting the urge to yell "INCOMING!!!!!!"

I've read statements from both Inmon and Kimball that their respective takes on datawarehousing (or whatever you want to call it) are a...

"I would rather hire someone with a little less experience and technical skill who is a great communicator and people person than an expert who cannot relate to people or...

I'd refer to what Bono speaks of as "datavisim" though it doesn't have the same catchy moniker. As some have pointed out, what some call "facts" are really just...

In my mind, this is a question of granularity. There are only 181 latitudes (90 degrees north to 90 degrees south including 0) and 360 longitudes (plus or minus...

If you're looking to detect package failures, you'll want to read up on error handling and Logging in SSIS. You'll also want to look into Event Handlers and Checkpoints....

Hey, this is just little old me over here in the cheap seats of the peanut gallery, but I've seen far too many end users whose job is made harder...

Maybe it's little old me, but I was surprised at the very least at the statement: "Having knowledge about the way your business works, the way they use data, or...

There's a tendency in IT circles to use questions that have a more or less definite answer. Yes, it is important to assess a candidate's skills, but from over...