Got it! I kept thinking there must be a way to do an overall COUNT of what the query was doing. Here it is:

SELECT COUNT(*) FROM (

SELECT CALL_BEGAN_DT

SOP_POOL_ID

,C622.CLNT_NB

,CALL_TYPE_CD

FROM...

I'm able to get the correct record count with the sql below. However, I get 650xxx individual rows because of the Group By clause instead of 1 row with...

Thanks a lot for the responses!

I hear ya Lowell on breaking up dates and storing separately. Unfortunately this is an old legacy system where the database isn't...

The column being used is the acct_nb which also is indexed on both source tables and the destination table. Thanks!

RP_DBA - thanks so much. This looks like it's working. I'm going to apply it to all my test cases to ensure.

The max(case when phone_stat_cd in...

RP_DBA

Here is the code I'm testing in Data Manager. Data Manager is the interface we use to the vended cache database. Directly after the code is the error...

I really appreciate the responses!

I was testing the CASE statement through a remote connection into Data Manager. Through Data Manager I query the cache database for the testing of...

Thanks for the CASE statement advice. When I run it to select from the source however, it doesn't like the ISNUMERIC. The data source is from a cache...

Yes, a valid record will have the beginning and ending date and call times populated. The beginning date and call time will be less than the ending data and...

Yes, it would make sense to have the actual call begin time. Thanks again for your help.

Call Begin Date: 12/03/2009

Call Begin Time: 11:58:20...

Our vendor was able to give us an example.

Call Begin Date: 12/03/2009

Call Begin Time: -100

Call End Date: 12/04/2009

Call End Time: 12:05:00...

Good & expected data in TIME_CALL_BEGAN field:

2009-12-15 09:30:19.000

Bad data: -09384593 (note: this is a made up number similar to what we encounter. It doesn't...

If your situation was similar to ours, we only had a table name in the source cache database with no other information. We did a simple query: SELECT...

Are you using ODBC? ODBC will need to be configured before using SSIS.

Do you see the ODBC connection in the Connection Manager? If so, when you...