Sorry, WCF services are out of my comfort zone.

Maybe you'll have more luck in an Oracle forum?

Indeed a strange problem.

Uncached lookups are of course very slow, but I don't really see a reason why the package should hang.

Did you try a cache connection?

How is the server...

You...

fabriziocrespi (5/16/2012)

---

Thank you for your reply, yes, I've made a step ahead (I hope;-)).

I've succesfully call .bat file in my working directory but I need to Run As Administrator the...

Phil suggested a .NET script, not a SQL script.

However, if the data is in one cell, it should load (with CHAR(10) and CHAR(13) values in it).

Did you try to load...

So you converted the package in SSDT and it works there just fine?

Regarding package execution:

it depends where you store the package. I would suggest you store them in SQL Server, so you can levarage SQL Server security. If you execute the packages...

Very nice question, thanks!

Great question, thanks.

Nice question, thanks.

Can you give me the link to that article?

The official documentation doesn't mention that fast load is only for SQL Server.

OLE DB Destination

But, I tested it and it seems indeed...

It's indeed possible that connection 1 is validated too soon, giving you unwanted error messages. I've seen a similar thread before.

Why don't you configure connection 1 with an environment variable...

Did you use the fast load option in the OLE DB destination?

Books online or BOL are just the MSDN documentation pages.

Example for SQL Server 2012:

Books Online for SQL Server 2012