I want use SSIS 2008 to transfer data between MS-SQL and Oracle. I had installed the newest ODAC on my Windows 7 Ultima 64 bit.
Now I create a new project of Integration Service and new a datasource.
I use wizard to create datasource.
In provider, I choose " Oracle Provider for OLE DB "
In Server or file name column, I typed " 184.108.40.206:1521/orcl.myDomain.com "
and specific the username and password,
when I press Test Connection button, the system told me it test connection succeeded !
but I press OK button, the system tod me " The given path's fo0rmat is not supported "
It look like the SSIS did not support this kind of name to save.
Can anybody help me ?
By the way, Can I use " SYS " to login Oracle, and how can I setip ?
View Complete Post