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 |
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
 Posted - 2008-12-05 : 17:38:55
|
| Can ssis work flow call a linked server openquery statement? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-12-05 : 17:42:58
|
Yes, but why?Add a new connection and set the properties dynamically with variables.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2008-12-05 : 17:47:31
|
| I'm trying to read the data from oracle. I created a linked server now I need to pull the data from oracle to SS.I can't use the wizard to pull the data. I'm getting this error.- Setting Source Connection (Error)MessagesError 0xc0202009: Source - CUS [1]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. (SQL Server Import and Export Wizard) Error 0xc02020e8: Source - CUS [1]: Opening a rowset for ""DWODS"."CUS"" failed. Check that the object exists in the database. (SQL Server Import and Export Wizard) Exception from HRESULT: 0xC02020E8 (Microsoft.SqlServer.DTSPipelineWrap) |
|
|
|
basicconfiguration
Constraint Violating Yak Guru
358 Posts |
Posted - 2008-12-05 : 17:59:42
|
| Fixed it I don't need a linked server. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-05 : 18:00:51
|
| You don't need linked server if you are doing with SSIS.You have 2 option:1)You can use SSIS with Oracle Source and SQL Destination and map columns and datatype .2)You can use Replication for it as well. |
|
|
|
|
|
|
ssis calling linked server