How can I structure this in SSIS?

Tags:
SQL Server 2005
SSIS
Within SSIS, I need to do the following:
  1. Select the max(to_date) + 1 from a table in SQL Server.
  2. Pass this value to a view where clause statement; this view is an Oracle view that needs this date value so I can get the new data from Oracle and load it into this same table in Step 1.
How can I do this - I am fairly new to SSIS and I am not sure how to structure this. Thanks for your help.

Answer Wiki

Thanks. We'll let you know when a new response is added.

You’ll want to setup an SSIS variable with the scope of Package. Then add in a SQL Query task to return the statement that you want. Then using the record set which is returned drop than into the SSIS variable. Then use the SSIS variable to in the select statement as part of the data pump task which copies the records from the Oracle database to the SQL Server.

This blog post shows some basics of how to map data back to an SSIS variable. I don’t have any other URLs handy with more specific info on what you are trying to do. If my blog post doesn’t provide enough inside, just let me know and I’ll dig up some additional info for you.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following