A solution could be to create a linked server to the Oracle database and create your view/procedures on the SQL server box.

Check this.

You'll find the answer here.

My first guess would be that the problem lies in the fact that your stored procedure can return two different result sets - depending on the value of @InsDown.

Since you...

You're welcome.

I also found this. Tried it on my machine and it works.

You don't have to change ValidateExternalMetadata to False on ALL source and destination components as the article recommends...

Dou you really need to implement this as one transaction?

This is how I would do it (without knowing your exact requirements :-):

create 3 sequence containers and put the process for...

This should make it work but may not be matching your requirements (in either case let me know):

I assume you use an execute SQL task for the truncate. Change the...

Do the parameters have an impact on what columns or datatypes are returned from the SP? Can you post the code of the SP?

Use dtutil

Add a text box, create an expression it it, use SUM function.

If that's not what you're looking for, please be more specific on your request.

Try putting quotes ( " ) around paths and filenames that contain spaces. Use a backslash ( \ ) to escape them in expressions e.g.

"\"" + @[Template::FolderExtractFiles] + "\""

Here is one way to solve this.

In your query, add an extra column where the amount is only kept on the first line of each order and made zero for...

http://ask.sqlservercentral.com/questions/1968/any-way-around-the-print-limit-of-nvarcharmax-in-ssms

Your're welcome.

Unless you have additional requirements, just set it to a big number e.g. 1,000,000,000.

Can you be more specific as to what are you trying to achieve i.e. what will you do with the result?

I suggest you first check if you cannot simply use...