Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 821
  • Last Modified:

SSIS Package with ODBC Source and OLE DB Source

I'm trying to do what I think is simple...
Creating a package to pull old FoxPro data and put it into a SQL table.  The insert however should only pull in "new" records. The FoxPro table has a unique key (testid).  So I thought I would have the ODBC Source and create a second source (OLE DB) which was just a query to grab the max() testid from the SQL table.  But I'm having trouble trying to figure out how to get these two seperate sources to talk to put into a single destination.  I though 'union all' would work but no matter what I do I cannot get the types (yes I created a 0 as maxtestid in the ODBC query from FoxPro) to be compatible.

Any ideas?
0
ClowWater
Asked:
ClowWater
  • 2
1 Solution
 
Brian CroweDatabase AdministratorCommented:
Use an OUTER JOIN on the two sources and only pass through records where the SQLTable.uniquekey IS NULL.
0
 
ClowWaterAuthor Commented:
BriCrowe...I tried but couldn't get it to work.

What I did to get it to work...I used a T-SQL Statment task and put max value into a user variable (thus deleting the OLEDB source).  Then used the conditional split on the ODBC source (inside data flow task) to filter out my results that I then sent to the OLEDB destination.
0
 
ClowWaterAuthor Commented:
worked
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now