Let me clarify. I had only 1 error in the package. I tweaked the sql in one area to force the single error. There were 2 emails...

I found an answer that works for my situation. Instead of using the Event Handler "OnError", I used "OnTaskFailed". Using this at the highest level of the package...

Mark,

Thanks Dude! I ran the scripts and it seems to do the job. I'll work on applying it to the table I'm working with. The business...

OK, here are some more examples. I really appreciate your help!

BIGINT Value TIME Value

80100000000:13

323500000000:53

453800000001:15

459800000001:16

579600000001:36

660400000001:50

795200000002:12

937000000002:36

961600000002:40

1006700000002:47

1087400000003:01

1814800000005:02

40544000000011:14

48623000000013:30

58680000000016:18

Unfortunately I don't know what the 519810000000 represents. The time value for this number is 01:15:38.000. I queried the data source for the same account to get...

Can anyone help out with further implications? Thanks.

To make this more readable:

cpu count 16

hyperthread

ratio 4

physical

cpu count ...

Here's what I've been able to gather about our CPU:

cpu hyperthread physicalphysical

countratio ...

I would first suggest finding out the indexed column(s) on the source table. Try to use these column(s) in your WHERE clause to filter the data.

You could also check...

SSC - thanks, but that didn't work. See my previous reply on what did work. Thanks for attempting to help.

G - thanks! In the flat file setup I entered " in the Text Qualifier box. This fixed my issue. After executing an SSIS package, the data...

I found the answer. Use the DataReader Data Flow Source. Ensure the ODBC connection on your pc or server is set up correctly to access the source data....

Thanks everyone for their replies!