I want to copy Data from an Oracle Server to SQL2005. The tables are the
identical and before I start the copy job I empty the destination table.
I've played with some Data Flow option and every time i get the same error:
[SQL Server Destination [1168]] Error: An OLE DB error has ...

I installed SQL Server 2005 Enterprise Edition with a named instance, mixed
authentication.
Now I'm not able to connect to SSIS from the Management Studio on my
workstation. The error message says:

I'm running a test package which only has one component, Transfer SQL Server
Objects Task.  The server is local on my dev machine and is setup under
windows authentication.  I have 2 test databases, zTest1 and zTest2.  zTest1
has one table called customers and 2 columns and 2 ...

I'm in SSIS and am setting props for the Transfer SQL Server Objects Task
component.  I'm want to set the source and destination data source
properties so first I am creating a new data source.  the server uses
windows authentication and resides on my development machine so no ...