I am attempting to import data from a Oracle XE source into a SQL Server 2000
instance.
I have imported from Oracle 9i and 10g, using the OLE DB Provider for Oracle.
I specify the server name, XE, I get an error when I test the connection.
"Test connetion failed because of an error in in...
more >>
Hi all,
I am trying to import an csv file into SQL table, but I am having error with
float (integer), and date fields. String fields are ok. Isn't that SQL
takes care of these conversion automatically? If I have to convert data
manually, how can I do this, and what syntax?
Anyone ha...
more >>
Hi,
first of all, let me state that I'm new to SSIS. I've been successfully
using DTS for quite some time, but now want to change over to the new
version.
I was surprised to find out that I can only once assign a source column to
a destination column. Why's that? In DTS, I could easily assi...
more >>