Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zahidul.hassan
Starting Member
3 Posts |
 Posted - 2009-08-16 : 03:35:28
|
| INSERT_INTO_ORACLE_USING_SSIS_VERIABLEHi,I am using an SSIS to transfer some values into an Oracle table. My SSIS variables are holding those values. I am using an Execute SQL Task to insert those values to the Oracle table. But its not working.Please help me.INSERT INTO BL_SMS_REQUEST(DIRECTORY_NUMBER, SMS_TEXT, TO_BE_SEND_TIME) Values(1711080932,'GPSD Delivery:'+ (DT_WSTR, 30) @[User::DELIVERY_GPSD]',SYSDATE)I have put the above statement in following path.Execute SQL Task --> General --> SQLStatementThanks in advance.MD. ZAHIDUL HASSAN |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-16 : 04:28:37
|
Why isn't working?Syntax Error? Replace SYSDATE with GETDATE()Wrong data? Check the content of DELIVERY_GPSD variable.Other error? Please post back error message.
N 56°04'39.26"E 12°55'05.63" |
 |
|
|
zahidul.hassan
Starting Member
3 Posts |
Posted - 2009-08-16 : 05:03:58
|
| Hi Peso,Thanks for the reply, this is what i am getting while parsing.The query failed to parse. ORA-00907: missing right parenthesisMD. ZAHIDUL HASSAN |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-08-16 : 05:30:43
|
INSERT BL_SMS_REQUEST (DIRECTORY_NUMBER, SMS_TEXT, TO_BE_SEND_TIME) VALUES(1711080932, 'GPSD Delivery:' + (DT_WSTR, 30) @[User::DELIVERY_GPSD], SYSDATE)Drop the single quote after the variable.
N 56°04'39.26"E 12°55'05.63" |
|
|
|
zahidul.hassan
Starting Member
3 Posts |
Posted - 2009-08-16 : 05:49:40
|
| I have used the following query, but still getting the same error :(INSERT INTO BL_SMS_REQUEST (DIRECTORY_NUMBER, SMS_TEXT, TO_BE_SEND_TIME)VALUES(1711080932, 'GPSD Delivery:' + (DT_WSTR, 30) @[User::DELIVERY_GPSD], SYSDATE)MD. ZAHIDUL HASSAN |
|
|
|
|
|
|
|
|
INSERT_INTO_ORACLE_USING_SSIS_VERIABLE