Select *

Define all varchar's as varchar(max) to be on the safe side.

Passing strings as date-parameters: where mydate='01/06/2005' -> the first of june or the sixth of january ?

sqlserver works best with the oracle oledb driver (OraOLEDB)

For newbieuser: convert '18/01/2009' to a proper datetype instead of relying on the occasional dateformat of the server. By using convert?

For penny: have you checked the distiributed transaction coordinator...

As Koen mentioned, did you install the 64-bit variant of the oracle client?

Did you reboot?

Oracle home environment variable properly set?

Didn't know about the bug, glad you mentioned it.

100 is the default fetchsize for the Oracle Client, you might increase it through the registry/provider string

Case sensitivity? (collaction/Oracle case sensitivity)

Mix of datatypes? trim(x)=:comp -> characters? :comp=0 -> number?

Why is the trim added in the last line?

You have supplier_country = receiver_country and :ccty = 0 (without...

I would expect

Declare @OrderID Int

Exec ('Call DATALIB.BP_PUSH_F(?)', @OrderID OUTPUT) AT ERP

if I read correctly (link)

The query designer in reportbuilder has some great restrictions:

no ability to use parentheses graphically (when you want to use "or" instead of "and"), unless you correct it in sql-text.

no ability...

Welkom back wolfkillj, could you fix the link to your blog? It points to the thread.

Thanks for the suggestion. Is certainly a way to achieve the goal.

Went for a scripttask in the controlflow setting and setting the result to Dts.TaskResult = (int)ScriptResults.Failure; when variable was...

Eagerly awaiting the next edition.

In case you need to run an ssis dashboard report not from the management studio, you can use a replacement by mnowill[/url].

For readonly security...

You can click on the link TAF in the above post.

I don't have experience with it but know that you can specify multiple addresses under one TNS-alias. Sometimes an oracle...

was it Oracle TAF automatic fail over using tnsnames ?

case sensitive tablenames?