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 |
|
Anand.A
Posting Yak Master
109 Posts |
 Posted - 2011-12-30 : 01:04:21
|
| hii am loading datas from excel to sql server and oracle by using ssis package..in that ssis package i am having lot of source and destination..my loads run successfully..but when i try to change that oracle schemalike oledb connectioni choose oracle1_db then i change that to oracle2_dbbut in my ssis package name of the table or viewi am getting oracle1_db.<table_name>so if mad changes in oracle2_db my oracle1_db.<tables> only affected how to slove this prblm in ssisanand |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-01-01 : 02:18:39
|
| why are you use schemaname.tablenameuse only tablename in select and connection properties will take care of which schema it needs to find the table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
schemaname.table_name problem