月度存档: 八月 2011

Oracle REMAP_TABLE in data pump

作者: 日期: 2011 年 08 月 21 日 没有评论 | 2,026 views

I tried to use REMAP_TABLE in Oracle 10.2.0.5, but it doesn’t work at all. finally I found out there is a bug and this parameter doesn’t work, check here for detail,
http://yangtingkun.itpub.net/post/468/473037

To make sure that we can use this, we can also refer the step in this link,

http://yangtingkun.itpub.net/post/468/473311

 

SSIS Service default instance

作者: 日期: 2011 年 08 月 21 日 没有评论 | 1,680 views

you can find that default instance of SSIS here,

%ProgramFiles%\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml

this file is XML format.

also make sure that your service account of your instance (the job in which the SSIS package is called) can access the default instance of the SSIS if your SSIS package is stored in MSDB.