>From de article:

> Thanks for your response.
>
> I am using SQL Server 2000. Also, the article used 2 tables from the same
> data source, while I need to compare with a different data source (different
> database too) within my Transform Data task. I thought Lookup might help,
> but didn't find sufficient documentation re: that.
>
> Thanks!
>
>
> "arnoled" wrote:
>
> > If your using sql server 2005 this should be useful
> >
> > http://www.sqldts.com/default.aspx?311
> >
> > Anyway, i didn't read the whole article but if you don't have sql
> > server 2005 you could copy the data from destination server to the
> > source server with a previous step, and then compare it.
> >
> > JA ha escrito:
> >
> > > Hello,
> > >
> > > Within the Transform Data Task, I need to query the Source data using
> > > criteria from another data source. That is, within my SQL statement's WHERE
> > > clause, I need to compare a date column from the Source with a date column in
> > > the Destination. How can I do this? Can I use the Lookup tab to accomplish
> > > this? I tried creating a Lookup value that uses a SELECT statement to get
> > > the date value from the destination column - how can I use this value in the
> > > SELECT statement that I enter into the Source tab?
> > >
> > > Thanks!
> > > -Jyotsna
> >
> >