Viewing 15 posts - 7,126 through 7,140 (of 11,678 total)
Maybe you'll have more luck in an Oracle forum?
May 16, 2012 at 2:43 am
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...
May 16, 2012 at 2:10 am
Eric Mamet (5/14/2012)
Now that you mention it, it's true that I can use ADO .Net connections which are far cleaner... but then I can pay a penalty price...Cheers
Eric 😉
You...
May 16, 2012 at 2:02 am
fabriziocrespi (5/16/2012)
I've succesfully call .bat file in my working directory but I need to Run As Administrator the...
May 16, 2012 at 1:55 am
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...
May 16, 2012 at 1:54 am
So you converted the package in SSDT and it works there just fine?
May 16, 2012 at 1:47 am
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...
May 16, 2012 at 1:42 am
Can you give me the link to that article?
The official documentation doesn't mention that fast load is only for SQL Server.
But, I tested it and it seems indeed...
May 16, 2012 at 1:12 am
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...
May 16, 2012 at 12:38 am
Did you use the fast load option in the OLE DB destination?
May 12, 2012 at 11:14 am
Books online or BOL are just the MSDN documentation pages.
Example for SQL Server 2012:
May 11, 2012 at 7:03 am
Viewing 15 posts - 7,126 through 7,140 (of 11,678 total)