Viewing 15 posts - 2,896 through 2,910 (of 5,393 total)
Koen Verbeeck (7/29/2011)
I have found the issue.
It's a combination of two things:
First of all, the driver needs to be executed out of process. So...
-- Gianluca Sartori
July 29, 2011 at 4:15 am
I feel your pain...
(NetMon + ProcMon + EventViewer + Policy Editor + Any log files you can find) is the only tools you have.
Good luck!
-- Gianluca Sartori
July 28, 2011 at 7:18 am
I have found that SSIS ignores the settings in the UDL file and requires entering ALL the connection parameters in the connection properties.
SQL Server has always been more forgiving and...
-- Gianluca Sartori
July 28, 2011 at 6:49 am
Looks like a TCP/IP connection error.
Can you trace the process with NetMon? You can add a filter for source or destination = your AS/400 machine.
If you don't see packets...
-- Gianluca Sartori
July 28, 2011 at 6:43 am
OK, thanks. So I guess you will have to stick to OLEDB (which is a good thing IMHO).
With "Windows Security" I mean the permissions to assign to the windows user...
-- Gianluca Sartori
July 28, 2011 at 1:43 am
Koen Verbeeck (7/28/2011)
However, I can rule out A through D, as I can create a successful connection and extract data from it in SSIS.
So it is...
-- Gianluca Sartori
July 28, 2011 at 1:27 am
Based on personal experience: don't use ODBC (too slow and unreliable) and go for OLEDB.
It could be something wrong in:
A) The iSeries package (have you checked that with your QSECOFR?)
B)...
-- Gianluca Sartori
July 28, 2011 at 12:53 am
More details on my blog: http://wp.me/p1gueM-4c
-- Gianluca Sartori
July 27, 2011 at 3:22 pm
Ninja's_RGR'us (7/27/2011)
Jim Murphy (7/27/2011)
Useless post just to make 500.I hate when people do this.
Do you realize I could do that every 2-3 weeks :blink:?
Unfair. This is pure bragging.
Oh, and this...
-- Gianluca Sartori
July 27, 2011 at 1:58 pm
My dear friends, I finally have the definitive answer to the question that originated this thread.
NO!
They're not getting worse! This is what they kept getting until today. Now they can...
-- Gianluca Sartori
July 27, 2011 at 8:42 am
I suspect that you're a bit confused. Let's see all your points one at a time:
I can browse to the MDF/LDF file
Fine. However, there's no need for this.
but cannot open...
-- Gianluca Sartori
July 27, 2011 at 8:30 am
Model is the template for a new database, so, if you don't like it in full recovery, change it to simple recovery.
No harm: it's your choice.
-- Gianluca Sartori
July 27, 2011 at 8:18 am
You can do it with a trigger or with a CHECK constraint WITH NOCHECK.
Be aware that:
1) CHECK constraints can't read data from another table directly, but have to use a...
-- Gianluca Sartori
July 27, 2011 at 4:06 am
GilaMonster (7/26/2011)
Grant Fritchey (7/26/2011)
Gianluca Sartori (7/26/2011)
Grant Fritchey (7/26/2011)
-- Gianluca Sartori
July 26, 2011 at 6:09 am
Grant Fritchey (7/26/2011)
-- Gianluca Sartori
July 26, 2011 at 5:59 am
Viewing 15 posts - 2,896 through 2,910 (of 5,393 total)