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 |
|
duncanpts
Starting Member
11 Posts |
 Posted - 2014-10-20 : 03:13:48
|
| connection success connect to oracle DB, but try to set the parameter at SSIS failed. |
|
|
duncanpts
Starting Member
11 Posts |
Posted - 2014-10-20 : 03:19:38
|
| TITLE: Microsoft Visual Studio------------------------------Parameters cannot be extracted from the SQL command. The provider might not help to parse parameter information from the command. In that case, use the "SQL command from variable" access mode, in which the entire SQL command is stored in a variable.------------------------------ADDITIONAL INFORMATION:Provider cannot derive parameter information and SetParameterInfo has not been called. (Microsoft OLE DB Provider for Oracle)------------------------------BUTTONS:OK------------------------------ |
 |
|
|
|
|
|
SSIS set parameter to oracle DB