CODEWITHSUNDEEP
sql-serverssis
Abraham Josef
Abraham Josef

Reputation: 653

Multiple select statements in OLEDB source ssis

Using SQL Server Integration Service (SSIS) 2008, I created OLEDB Source and filled the SQL Command Filed with the following query:

select A,B,C from Table1;
select D,E,F from Table2;

but I have the invalid character error when press the preview button but the query runs perfect on Oracle SQL Developer

Upvotes: 1

Views: 1085

Answers (1)

Andrey Morozov
Andrey Morozov

Reputation: 7979

Just change your command to

select A,B,TO_CHAR(C) as C from Table1
union all
select D,E,TO_CHAR(F) as F from Table2;
  • where C and F fields have different datatypes

Upvotes: 1

Related Questions