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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 SSIS set parameter to oracle DB

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
------------------------------
Go to Top of Page
   

- Advertisement -