Mark Forums Read

SSIS: Connecting to Oracle destination in Data Flow task

Go Back

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Reply

Page 5 of 5

5

#41

Old

Gerald Aichholzer

Posts: n/a

Re: SSIS: Connecting to Oracle destination in Data Flow task - 11-28-2008 , 04:51 AM

Hello Abba,

Abba wrote:

Quote:

Since I have a WHERE filter, I choose SQL command for SQL source. I cannot
choose 'Table or view' in Oracle destination as I get an error saying
"Datatype is not supported". I think its the Oracle Timestamp datatype. So I
choose "SQL command" and write:
SELECT TRXID, PRODUCT, ACCTNUM,TO_CHAR(InsertDate,'mm/dd/yyyy') as
InsertDate
FROM OracleTable

But on 'preview', its giving me the error "Failure inserting to read_only
column InsertDate'. I had to put TO_CHAR... prefix as InsertDate alone is
giving me the same "Datatype is not supported error".

this of course cannot work, because - as the error message states -
the last column is read-only because it is an expression. You can't
make an expression writable.

I've done a quick search with Google and found the following article,
which might help you:

How to convert SQL Server datetime to Oracle timestamp (or other type
with similar precision)?
http://forums.microsoft.com/MSDN/Sho...43532&SiteID=1

good luck and regards,
Gerald

Reply With Quote

#42

Old

ML

Posts: n/a

Re: SSIS: Connecting to Oracle destination in Data Flow task - 11-28-2008 , 05:11 AM

Judging from the posts in the forum thread using timestamp(3) is worth a try.

ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Reply With Quote

#43

Old

ML

Posts: n/a

Re: SSIS: Connecting to Oracle destination in Data Flow task - 11-28-2008 , 05:11 AM

Judging from the posts in the forum thread using timestamp(3) is worth a try.

ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Reply With Quote

#44

Old

ML

Posts: n/a

Re: SSIS: Connecting to Oracle destination in Data Flow task - 11-28-2008 , 05:11 AM

Judging from the posts in the forum thread using timestamp(3) is worth a try.

ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Reply With Quote

#45

Old

ML

Posts: n/a

Re: SSIS: Connecting to Oracle destination in Data Flow task - 11-28-2008 , 05:11 AM

Judging from the posts in the forum thread using timestamp(3) is worth a try.

ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Reply With Quote

#46

Old

ML

Posts: n/a

Re: SSIS: Connecting to Oracle destination in Data Flow task - 11-28-2008 , 05:11 AM

Judging from the posts in the forum thread using timestamp(3) is worth a try.

ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Reply With Quote

#47

Old

ML

Posts: n/a

Re: SSIS: Connecting to Oracle destination in Data Flow task - 11-28-2008 , 05:11 AM

Judging from the posts in the forum thread using timestamp(3) is worth a try.

ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Reply With Quote

#48

Old

ML

Posts: n/a

Re: SSIS: Connecting to Oracle destination in Data Flow task - 11-28-2008 , 05:11 AM

Judging from the posts in the forum thread using timestamp(3) is worth a try.

ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Reply With Quote

#49

Old

ML

Posts: n/a

Re: SSIS: Connecting to Oracle destination in Data Flow task - 11-28-2008 , 05:11 AM

Judging from the posts in the forum thread using timestamp(3) is worth a try.

ML

---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com/

Reply With Quote

Reply

Page 5 of 5

5

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.