More than each new job makes me nervous, each new mystery I can't explain makes me nervous!!! Did I miss something small and stupid? Is this a...

Please let us know how it goes. I have often had a user adamant that what they provide is "good enough" so if you meet with resistance and really...

I wouldn't quite call your source a csv file!!! This is not formatted in a consumable manner.

Whomsoever it is that generates this file should provide an actual data file....

concur, not possible, what is your goal?

I also think it is either data types or truncation.

Check a couple properties, we have had this issue.

For the component that should fail the job, look at

FailPackageOnfailure (set to TRUE)

FailParentOnFailure (set to true)

MaximumErrorCount (set to 1)

I learned the...

If I understand you correctly, Yes, we do this.

I have a local connection variable that resolves this way using expression

Data Source=YOURSERVER;Initial Catalog=YOURDATABASE;Provider=SQLNCLI.1;Integrated Security=SSPI;PacketSize=32767

Expression

"Data Source=" + @[User::cfgDWServerName] +...

I don't know how to get that info but I have event handlers informing me of progress step to step that I throw into an audit table. Not sure...

are you talking about logging?

Not sure I follow you completely, but I use the Event Handler in pkgs to write logging messages to a table I created for such a purpose (we need to...

yeah, it's gonna be a lot easier to assist in troubleshooting when something actually goes wrong.

Like anything else, ya follow the trail from hopefully a helpful error message.

I think it's a driver issue. I have Excel-as-a-connection issues that we are opting to defer until server upgrades, etc., are complete.

concur on terrible idea, especially if Excel is in hands of users.

Yeah, uncheck the Column Headers and see how it goes.

If they have run successfully before, it seems to me like intermittent connection failure due to possible network latency?

If they have not run successfully before, it's a permissions issue.