Unfortunately no joins. Their explanation:

The db server software does not have the concept of a join, therefor, the query language and translator do not attempt to support one.

So I...

I'm pulling the ID and the record mod date down onto my sql server and then adding the row number column. Now I need to issue the subsequent queries...

It's not a traditional relational database, and there are some (many) limitations in the sql translation process (read only supporting only simple select statements, no joins, no order by, IS...

Here is a sample of what my initial query is bringing in:

031134426/13/2008 12:00:00 AM

032084386/13/2008 12:00:00 AM

032117046/16/2008 12:00:00 AM

032162016/16/2008 12:00:00 AM

I add a column to (hopefully) make processing easier:

1031134426/13/2008 12:00:00 AM

2032084386/13/2008...

Yes, Thanks Brandie. The post is very much appreciated. I am working through it now, and will let you know how it goes.

Couple of notes:

- Correct, the...

Worked like a charm. Thanks, Frank!

Hi Frank,

How would your code look without the use of a proxy server?

Thanks,

Dave

Thanks, I spoke with the data provider and there were some data quality issues that were taken care of. Now my package is running smoothly again.