| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mssql >> SQL Server 2005 shu ju zhuan huan fu wu she ji wen ti ji jin
 

SQL Server 2005 shu ju zhuan huan fu wu she ji wen ti ji jin

2008-07-10 05:54:04 编辑來源:互联网 评论
 
本文为【SQL Server 2005数据转换服务设计问题集锦】的拼音翻译版
  wei shen me chuan shu ji qian ge biao de shu ju shi xiang dao hui shi bai ?
  dang qian de xiang dao ti xi jie gou hui chuang jian yi ge DTS ruan jian bao shu ju liu yi chuan shu shu ju 。 dan ru guo yao chu li ji qian ge biao , ze hui yu dao ke shen suo xing xian zhi 。 wo men ren wei zhe shi he li de , yin wei ruan jian bao she ji ren yuan bu tai ke neng zai yi ge shu ju liu zhong shi yong ji qian ge yuan he ji qian ge mu biao 。Beta 3 zhong ke neng hui zhen dui ci wen ti jin xing yi xie gai jin 。
  wei shen me wo bu neng zai dao ru / dao chu xiang dao zhong fu zhi dui xiang ?
  dao ru / dao chu xiang dao shi wei le rang yong hu fang bian di jiang shu ju yi ru he yi chu SQL Server er she ji de 。 zai fu wu qi zhi jian fu zhi shu ju ku dui xiang shi ji shang shu yu guan li cao zuo er bu shi shu ju yi dong cao zuo , ji shi shi ji shang yi dong le shu ju 。
  yong hu ke yi shi yong SQL Server“ guan li ” gong zuo qu zhong de “ fu zhi shu ju ku xiang dao ” lai fu zhi shu ju ku dui xiang , er qie gai xiang dao shi zhuan men yong yu fu zhi shu ju ku dui xiang de 。
  ling yi fang mian ,DTS dao ru / dao chu xiang dao jian hua le dian xing de DTS cao zuo —— cong ge zhong shu ju yuan ( bao kuo wen ben wen jian 、 dian zi biao ge he OLEDB shu ju yuan ) jia zai shu ju 。
  wei shen me wo bu neng zai SQL Server Management Studio zhong she ji ruan jian bao ?
  SQL Server Management Studio shi yi ge huan jing , yong yu guan li yi bu shu ruan jian bao de cun chu he zhi xing 。 ta ti gong le zhuan men yong lai she ji ruan jian bao de te shu gong neng , bao kuo yu DTS fu wu de ji cheng yi ji mei ju yuan cheng fu wu qi shang de ruan jian bao de neng li 。 dan ta bu shi yi ge she ji huan jing 。
  Business Intelligence Design Studio cai shi yong yu she ji ruan jian bao 、 zai jie jue fang an he xiang mu zhong zu zhi ruan jian bao 、 tiao shi ruan jian bao bing guan li duo yong hu xiang mu de yuan he ban ben kong zhi de huan jing 。
  suo yi , zai SQL Server 2005 zhong , yong hu fen bie zai liang ge du li de zhuan men hua huan jing zhong she ji he guan li ruan jian bao 。
  shen me shi shu ju yuan he shu ju yuan shi tu ? ta men zai wo de ruan jian bao zhong ru he yu lian jie xiang guan ?
  shu ju yuan he shu ju yuan shi tu bu shi DTS ruan jian bao zhong de dui xiang , er shi cun chu zai Business Intelligence Development Studio de shu ju zhuan huan xiang mu zhong de dan du dui xiang 。 you yu ta men wei yu xiang mu zhong er bu shi wei yu DTS ruan jian bao zhong , yin ci ke yi zai DTS ruan jian bao zhi jian gong xiang , cong er yuan xu wei ming xing jia gou ding yi shu ju yuan shi tu bing you jia zai ming xing jia gou de mei ge ruan jian bao yi zhi di shi yong gai shi tu 。
  shu ju yuan ding yi le ru he lian jie dao OLEDB huo ADO.NET shu ju ku 。 ta men bao han lian jie zi fu chuan yi ji qi ta mou xie shu xing , bao kuo lian jie de you hao ming cheng he miao shu zi duan 。
  shu ju yuan shi tu shi shu ju yuan suo zhi xiang de guan xi jia gou de zi ji 。 ke yi yong ming ming cha xun 、 ji suan lie 、 xu ni guan xi he you hao ming cheng xiang xi miao shu zhe xie shi tu 。 li ru , zai shi yong da xing jia gou shi , nin ke neng zhi xiang shi yong shu ju yuan zhong de yi xiao bu fen biao 。 zhe zhong qing kuang xia , jiu ke yi shi yong shu ju yuan shi tu lai ding yi zhe yang yi ge zi ji 。
  shu ju yuan he shu ju yuan shi tu shu yu she ji shi dui xiang , zhi neng zai BI Development Studio xiang mu zhong shi yong 。 zai she ji shi , shu ju yuan ke you xiang mu zhong de yi ge huo duo ge DTS ruan jian bao shi yong , dan zai yun xing shi , yi bu shu de DTS ruan jian bao jiang wu fa fang wen zhe xie she ji shi dui xiang 。DTS ruan jian bao bao han duo ge lian jie , zhe shi ruan jian bao she ji qi neng gou guan li yu shu ju ku 、 wen jian deng de lian jie 。 zai she ji shi , lian jie ke yi yin yong shu ju yuan huo shu ju yuan shi tu , dan zai yun xing shi ,DTS lian jie jiang shi suo you bi xu de yuan shu ju neng gou du li shi yong 。 zhe yang , yong hu ke yi she ji neng gou gong xiang shu ju yuan yin yong he shu ju yuan shi tu de bu tong ruan jian bao , ran hou du li yun xing bing dan du bu shu mei ge ruan jian bao 。
  ru guo DTS lian jie yin yong le shu ju yuan , na me shi yong gai DTS lian jie de dui xiang jiu ke yi shi yong ye shi yong gai shu ju yuan de ren he shu ju yuan shi tu 。 zhe yang ,DTS ruan jian bao jiu ke yi hen rong yi di zhi yin yong da xing jia gou de yi ge xiao zi ji 。
  zui hou ,DTS lian jie bi shu ju yuan geng tong yong , yin wei ta men ke yi lian jie dao wen ben wen jian 、HTTP lian jie 、FTP lian jie yi ji xu yao lian jie zi fu chuan de qi ta hen duo qing xing , er bu zhi shi lian jie dao OLEDB he ADO.NET guan li de ti gong cheng xu 。
  wei shen me mei you Microsoft Excel huo Microsoft Access shu ju yuan ?
  yao dao ru Excel he Access shu ju wen jian , ke yi shi yong jing guo shi dang pei zhi de OLEDB lian jie guan li qi 。 huan ke yi hen qing song di shi yong DTS dao ru / dao chu xiang dao , gai xiang dao jiang wei nin chuang jian lian jie guan li qi 。
  wei shen me mo ren qing kuang xia zai shu ju liu zhong bu shi yong “ kuai su fen xi ” xuan xiang ?
  “ kuai su fen xi ” xuan xiang shi zai shi dang de qing kuang xia cai neng shi yong de xuan xiang 。 ta bu zhi chi te ding yu qu yu she zhi de fen xi huo “ nian - yue - ri ” yi wai de ri qi ge shi 。 ta zhi dui you xian de shu ju ge shi you yong , dui yu zhe xie ge shi lai shuo , ci xuan xiang de fen xi su du ke neng bi mo ren de biao zhun fen xi fang shi geng kuai 。 yin ci , yong hu bi xu ji yu zi ji de shu ju ge shi xian shi xuan ze ci xuan xiang 。
  wei shen me WMI shu ju ren wu he shi jian ren wu shi xiang hu du li de ?
  xi tong guan li shu ju ke yong yu ying xiang DTS kong zhi liu 。 li ru , yun xing ETL liu zhi qian , ke yi jian cha SQL Server shi fou zheng zai yun xing 、 ji suan ji shang shi fou you ke yong de C: qu dong qi huo zhe shi fou you zu gou de ke yong ci pan kong jian 。WMI shu ju ren wu yong lai jian suo ci lei xi tong shu ju 。
  xi tong guan li shi jian ke yong yu zai DTS kong zhi liu zhong zhi xing shi shi cao zuo 。 li ru , jin dang nei cun shi yong liang xia jiang dao 50% yi xia shi cai yun xing ETL liu , huo zhe jin dang wen jian xi tong shang you ke yong de xin yuan wen jian shi cai qi dong shu ju liu 。WMI shi jian ren wu yuan xu ding yi he chu li ci lei xi tong shi jian 。
  er qie , zhe liang zhong ren wu zai suo ti gong de gong neng fang mian ye ji ben shang shi bu tong de 。 zai ben fa xing ban zhong , wo men ke yi geng zhu dong di gen ju ren wu ti gong de gong neng dui ren wu jin xing chai fen , yi chuang jian geng you zhen dui xing de ruan jian bao 。 zhe zhong chai fen de ling yi ge li zi shi wen jian xi tong ren wu he FTP ren wu 。 zai DTS 2000 zhong , zhe liang ge ren wu ti gong de gong neng bei zu he dao yi ge ren wu zhong , dan zai ben fa xing ban zhong , zhe liang ge ren wu bei chai fen kai lai , cong er shi yong hu geng rong yi chuang jian 、 li jie he zhi chi ruan jian bao 。
  wei shen me biao da shi yu yan ji bu shi SQL ye bu shi Visual Basic?
  yin wei SQL he Visual Basic dou bu neng man zu DTS shu ju liu de yao qiu 。 li ru , wo men xiang zhi chi yi zu yun suan fu , bi ru yong yu chu li hen duo qing kuang xia zuo wei biao ji shi yong de wei yan ma de an wei yun suan fu 。 ci wai , wei le geng hao di li yong nei cun ( cong er huo de zui jia xing neng ),DTS shu ju liu dui shu ju lei xing you zhe yan ge de xian zhi , zhe ye fan yang zai biao da shi yu fa zhong 。
  DTS biao da shi yu fa shi nin neng gou she ji chu tong guo fu duo de zi fu chuan he shu ju lei xing chu li er huo de gao xing neng de shu ju liu 。 ru guo biao da shi yu yan bu zhi chi nin xu yao de mou xie han shu , huo zhe nin geng xi huan shi yong Visual Basic yu fa , na me nin ke yi shi yong jiao ben zu jian , jiao ben zu jian yuan xu nin zai shu ju liu zhong shi yong Visual Basic .NET。
  wei shen me you xie han shu bu zai biao da shi yu yan zhong ?
  you yu zi yuan xian zhi , wu fa shi xian mu qian ke cong SQL Server TSQL zhong zhao dao de mei ge han shu 。 she zhi di yi pi han shu shi wo men zeng zi xun guo ke hu he kai fa ren yuan , wo men hui ren zhen kao lv shou dao de ce shi ban fan kui xin xi , wei yi hou de ce shi ban he zui zhong ban ben zuo hao zhun bei 。
  
  wei shen me bi xu zai yuan shi pei qi , er bu shi zai shi yong zu jian ( li ru he bing ) zhong pei zhi pai xu shun xu ?
  xing de shun xu shi zai yuan shi pei qi zhong she zhi de , bing qie wu fa tong guo da duo shu xia you zhuan huan jin xing geng gai ( pai xu ke neng shi yi ge li wai )。 neng gou shi bie yuan shu ju shun xu de yuan shi pei qi wu xu yong hu bang zhu ji ke she zhi ci xin xi , dan zai da duo shu qing kuang xia , ti gong gei yuan zu jian de yuan shu ju bu chong fen , shi yuan zu jian wu fa she zhi shu chu lie pai xu xin xi , yin ci yong hu xu yao zi xing wan cheng ci cao zuo 。
  wei shen me bi xu zai ruan jian bao zhong suo ding bian liang ?
  dang shi yu gai jin bing fa xing bing qie zhe yang ke yi ti gao xing neng he ke shen suo xing shi ,DTS yun xing shi jiang shi yong duo ge xian cheng lai wan cheng zhi xing 。 wei le bi mian duo ge xian cheng tong shi shi tu fang wen yi ge bian liang , bi xu wei nin de cao zuo suo ding bian liang , cong er shi dui bian liang de suo you fang wen dou shi “ an quan de ”; ru guo bu zhe yang zuo , ke neng hui dao zhi ruan jian bao chu xian ge zhong xiang ying , cong “ you shi bu gong zuo ” dao fan hui wan quan bu zheng que de jie guo 。 ji shi ruan jian bao shi wan quan xian xing de , zhe ye ke neng shi yi ge wen ti : li ru , ru guo yong hu yao geng gai xun huan zhong de bing fa she zhi 。
  wei shen me fen li shu chu lu jing shi mei you xiang zu jian fa chu tong zhi ?
  DTS she ji qi yong hu ying dang neng gou shan chu lu jing ran hou chong xin fu zhe lu jing , zhe yang cai bu hui po huai ruan jian bao huo geng gai ruan jian bao de xing wei 。 tong guo ti gong OnOutputPathDetached fang fa , wo men yuan xu xing wei bu dang de zu jian bu zun shou ci gui ze 。 wei le man zu xi wang ti gong duo ge shu chu de zu jian zuo zhe de xu yao ,DTS dui xiang mo xing ti gong le yi ge ming wei DeleteOutputOnPathDetached de shu chu shu xing , ru guo jiang ci shu xing she zhi wei true, dang lu jing bei fen li shi , shu chu jiang zi dong bei shan chu 。
  shi yong yu DTS de xin de Windows fu wu yuan xu cao zuo yuan cha kan bing ting zhi te ding fu wu qi shang yun xing de DTS ruan jian bao 。 ci fu wu zai SQL Management Studio zhong ti gong 。 zhu yi : xu yao shou xian qi dong DTS fu wu , yin wei mo ren qing kuang xia ta shi bei jin yong de 。
  wei shen me zai Mgt Studio zhong wu fa zai DTS fu wu qi xia kan dao zheng zai yun xing de ruan jian bao ?
  mo ren qing kuang xia DTS fu wu shi bei jin yong de 。 zhe shi gu yi she ji de , mu de shi wei le shi xi tong guan li yuan ke yi kong zhi he shi yun xing gai fu wu 。 yao qi dong DTS fu wu , qing you jian dan ji “ wo de dian nao ” bing xuan ze “ guan li ”( cong “ kai shi ” an niu huo cong zhuo mian shang yun ke ), ran hou zai “ ji suan ji guan li ” chuang kou zhong shuang ji “ fu wu he ying yong cheng xu ”, ran hou dan ji “ fu wu ”, ji ke kan jian zai you ce lie chu de suo you Windows fu wu 。 zai lie biao zhong zhao dao “DTS fu wu qi ”, you jian dan ji bing xuan ze “ qi dong ”。( ru guo nin xi wang zai mei ci qi dong ji suan ji shi zi dong qi dong gai fu wu , huan ke yi shuang ji gai fu wu yi da kai ta de shu xing , jiang “ qi dong lei xing ” geng gai wei “ zi dong ”。)
  wei shen me mo ren qing kuang xia ruan jian bao ri zhi ji lu bu zai wei yu xi tong shu ju ku MSDB zhong ?
  SQL 2005 DTS wei zai ri zhi zhong ji lu you guan shu ju ku de xin xi tian jia le hen duo xin xuan xiang 。 zhe yuan xu nin wei mei ge ruan jian bao ding yi yi ge huo duo ge bu tong lei xing de ri zhi ti gong cheng xu 。 ri zhi ti gong cheng xu lei xing bao kuo wen ben wen jian 、SQL Server、Windows shi jian ri zhi deng deng 。 zai nin de ruan jian bao zhong , tong guo zhuan dao “DTS” cai dan bing xuan ze “ ri zhi ji lu ”, ke yi tian jia ri zhi ti gong cheng xu 。
  wei shen me zai yuan shi pei qi zhong kan bu dao XML wen dang jia gou de bian hua ?
  XML wen dang jia gou de bian hua jiang ji da di ying xiang shu ju liu de yuan shu ju 。 zhe yao qiu yong hu xian shi geng gai jia gou bing zai geng gai shi kao lv dao yuan shu ju de bian hua 。
  wei shen me wo zai qian yi yin yong DTSGlobalVariables fu shu xing de ruan jian bao shi hui yu dao wen ti ?
  DTS 2005 zhong fa sheng geng gai de fan wei yao qiu wan quan chong xie dui xiang mo xing 。 zuo wei qian yi dao SQL Server 2005 DTS de jie guo , yin yong tong guo DTSGlobalVariables fu shu xing fang wen de SQL Server 2000 DTS dui xiang de ActiveX jiao ben jiang bu zai you xiao 。
  wei shen me wo zai qian yi shu ju beng ren wu shi hui yu dao wen ti ?
  DTS 2005 shu ju liu ren wu qu dai le DTS 2000 shu ju zhuan huan ren wu , shi gong neng you le hen da de gai jin 。 dan zhe yang de jie guo shi ,2000 he 2005 suo ti gong de gong neng zhi jian mei you ming que de dui ying 。 wei le que bao yi qian de shu ju zhuan huan ren wu neng gou ji xu zheng que cao zuo , mei you jiang ta men wan quan qian yi dao SQL Server 2005。 qian yi xiang dao dang qian jiang zhe yang de ren wu bao zhuang zai zhuan yong de SQL Server 2000 ruan jian bao zhong , bing cong zhi xing SQL Server 2000 DTS ruan jian bao ren wu tiao yong ta 。
  wei shen me wo bu neng qian yi dong tai shu xing ren wu ?
  yin wei ci ren wu zhi jie yi lai yu bu zai ti gong de DTS 2000 dui xiang mo xing , qian yi xiang dao dang qian wei ci ren wu ti gong de zhi chi hen you xian 。 ci ren wu de shi li bei jiao ben ren wu qu dai , jiao ben ren wu zhong bao han miao shu zeng you ci ren wu she zhi de shu xing de zhu shi 。 yao hui fu yi qian de gong neng , bi xu jin xing shou dong xiu gai 。
  wei shen me quan ju bian liang zai ActiveX jiao ben ren wu zhong bu ke yong ?
  Beta 2 bu zhi chi fang wen quan ju bian liang 。
  wei shen me bu zai DTS zhong bao kuo shu ju zhuan huan ren wu he shu ju qu dong de cha xun ren wu ?
  SQL Server 2005 bao kuo de shu ju liu ren wu qu dai le zhe liang ge SQL 2000 ren wu 。 shu ju liu ren wu dui shu ju yuan 、 mu biao he zhuan huan de shu liang mei you xian zhi , er zai SQL 2000 zhong , yong hu dui mei ge ren wu zhi neng shi yong yi ge shu ju yuan 、 yi ge mu biao he yi ge zhuan huan 。 zhi chi zhe xiang kuo zhan gong neng suo xu de xin dui xiang mo xing wu fa rong na zhe liang ge gong neng bu tai qiang de ren wu 。
  wei shen me DTS bu zai shi ke hu duan ke zai fen fa de ?
  DTS yi bei chong xie , cong SQL Server 2000 zhong you yong de shi yong cheng xu bian cheng le SQL Server 2005 zhong gong neng feng fu de ying yong cheng xu he ping tai 。 zhe zhong bian hua tong shi dai lai wei DTS yong hu ti gong fu wu he zhi chi de ze ren , zhe xie fu wu he zhi chi zui hao tong guo guan li he xu ke yu qi ta SQL fu wu qi ying yong cheng xu lei si de DTS yin qing gong neng lai chu li 。 yin ci , sui ran yong hu ke yi shi yong bu shu xiang dao qing song bu shu ruan jian bao , dan ta men bi xu zai xu yao yun xing ruan jian bao de mei tai ji suan ji shang yun xing SQL Server 2005 an zhuang cheng xu bing an zhuang DTS。 zhe bu jin you zhu yu que bao yong hu / ji suan ji shi yong zheng que ban ben de DTS ke zhi xing cheng xu , huan you zhu yu gai ruan jian yi hou de geng xin 。
  wei shen me DTS bu zhi chi ji yu MSI de bu shu ?
  ji yu MSI de bu shu ju you wan quan du li an zhuang de you dian , dan ta xu yao zai fen fa DTS er jin zhi wen jian 。 ru guo xu yao mou ge chong yao de an quan xiu bu cheng xu , na me yi tuo guan fang shi jiang xiu bu cheng xu ying yong dao mei ge bu shu mu biao shi bu ke neng de 。 dang qian de bu shu shi yong cheng xu yao qiu mu biao fu wu qi shang yi an zhuang DTS, yin wei zhe dui guan li yuan lai shuo cai shi geng you yong de mo xing 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
wei shen me chuan shu ji qian ge biao de shu ju shi xiang dao hui shi bai ? dang qian de xiang dao ti xi jie gou hui chuang jian yi ge DTS ruan jian bao shu ju liu yi chuan shu shu ju 。 dan ru guo yao chu li ji qian ge biao , ze hui yu dao ke shen suo xing xian zhi 。 wo men ren wei zhe shi he li de , yin wei ruan jian bao she ji ren yuan bu tai ke neng zai yi ge shu ju liu zhong shi yong ji qian ge yuan he ji qian ge mu biao 。Beta 3 zhong ke neng hui zhen dui ci wen ti jin xing yi xie gai jin 。 wei shen me wo bu neng zai dao ru / dao chu xiang dao zhong fu zhi dui xiang ? dao ru / dao chu xiang dao shi wei le rang yong hu fang bian di jiang shu ju yi ru he yi chu SQL Server er she ji de 。 zai fu wu qi zhi jian fu zhi shu ju ku dui xiang shi ji shang shu yu guan li cao zuo er bu shi shu ju yi dong cao zuo , ji shi shi ji shang yi dong le shu ju 。 yong hu ke yi shi yong SQL Server“ guan li ” gong zuo qu zhong de “ fu zhi shu ju ku xiang dao ” lai fu zhi shu ju ku dui xiang , er qie gai xiang dao shi zhuan men yong yu fu zhi shu ju ku dui xiang de 。 ling yi fang mian ,DTS dao ru / dao chu xiang dao jian hua le dian xing de DTS cao zuo —— cong ge zhong shu ju yuan ( bao kuo wen ben wen jian 、 dian zi biao ge he OLEDB shu ju yuan ) jia zai shu ju 。 wei shen me wo bu neng zai SQL Server Management Studio zhong she ji ruan jian bao ? SQL Server Management Studio shi yi ge huan jing , yong yu guan li yi bu shu ruan jian bao de cun chu he zhi xing 。 ta ti gong le zhuan men yong lai she ji ruan jian bao de te shu gong neng , bao kuo yu DTS fu wu de ji cheng yi ji mei ju yuan cheng fu wu qi shang de ruan jian bao de neng li 。 dan ta bu shi yi ge she ji huan jing 。 Business Intelligence Design Studio cai shi yong yu she ji ruan jian bao 、 zai jie jue fang an he xiang mu zhong zu zhi ruan jian bao 、 tiao shi ruan jian bao bing guan li duo yong hu xiang mu de yuan he ban ben kong zhi de huan jing 。 suo yi , zai SQL Server 2005 zhong , yong hu fen bie zai liang ge du li de zhuan men hua huan jing zhong she ji he guan li ruan jian bao 。 shen me shi shu ju yuan he shu ju yuan shi tu ? ta men zai wo de ruan jian bao zhong ru he yu lian jie xiang guan ? shu ju yuan he shu ju yuan shi tu bu shi DTS ruan jian bao zhong de dui xiang , er shi cun chu zai Business Intelligence Development Studio de shu ju zhuan huan xiang mu zhong de dan du dui xiang 。 you yu ta men wei yu xiang mu zhong er bu shi wei yu DTS ruan jian bao zhong , yin ci ke yi zai DTS ruan jian bao zhi jian gong xiang , cong er yuan xu wei ming xing jia gou ding yi shu ju yuan shi tu bing you jia zai ming xing jia gou de mei ge ruan jian bao yi zhi di shi yong gai shi tu 。 shu ju yuan ding yi le ru he lian jie dao OLEDB huo ADO.NET shu ju ku 。 ta men bao han lian jie zi fu chuan yi ji qi ta mou xie shu xing , bao kuo lian jie de you hao ming cheng he miao shu zi duan 。 shu ju yuan shi tu shi shu ju yuan suo zhi xiang de guan xi jia gou de zi ji 。 ke yi yong ming ming cha xun 、 ji suan lie 、 xu ni guan xi he you hao ming cheng xiang xi miao shu zhe xie shi tu 。 li ru , zai shi yong da xing jia gou shi , nin ke neng zhi xiang shi yong shu ju yuan zhong de yi xiao bu fen biao 。 zhe zhong qing kuang xia , jiu ke yi shi yong shu ju yuan shi tu lai ding yi zhe yang yi ge zi ji 。 shu ju yuan he shu ju yuan shi tu shu yu she ji shi dui xiang , zhi neng zai BI Development Studio xiang mu zhong shi yong 。 zai she ji shi , shu ju yuan ke you xiang mu zhong de yi ge huo duo ge DTS ruan jian bao shi yong , dan zai yun xing shi , yi bu shu de DTS ruan jian bao jiang wu fa fang wen zhe xie she ji shi dui xiang 。DTS ruan jian bao bao han duo ge lian jie , zhe shi ruan jian bao she ji qi neng gou guan li yu shu ju ku 、 wen jian deng de lian jie 。 zai she ji shi , lian jie ke yi yin yong shu ju yuan huo shu ju yuan shi tu , dan zai yun xing shi ,DTS lian jie jiang shi suo you bi xu de yuan shu ju neng gou du li shi yong 。 zhe yang , yong hu ke yi she ji neng gou gong xiang shu ju yuan yin yong he shu ju yuan shi tu de bu tong ruan jian bao , ran hou du li yun xing bing dan du bu shu mei ge ruan jian bao 。 ru guo DTS lian jie yin yong le shu ju yuan , na me shi yong gai DTS lian jie de dui xiang jiu ke yi shi yong ye shi yong gai shu ju yuan de ren he shu ju yuan shi tu 。 zhe yang ,DTS ruan jian bao jiu ke yi hen rong yi di zhi yin yong da xing jia gou de yi ge xiao zi ji 。 zui hou ,DTS lian jie bi shu ju yuan geng tong yong , yin wei ta men ke yi lian jie dao wen ben wen jian 、HTTP lian jie 、FTP lian jie yi ji xu yao lian jie zi fu chuan de qi ta hen duo qing xing , er bu zhi shi lian jie dao OLEDB he ADO.NET guan li de ti gong cheng xu 。 wei shen me mei you Microsoft Excel huo Microsoft Access shu ju yuan ? yao dao ru Excel he Access shu ju wen jian , ke yi shi yong jing guo shi dang pei zhi de OLEDB lian jie guan li qi 。 huan ke yi hen qing song di shi yong DTS dao ru / dao chu xiang dao , gai xiang dao jiang wei nin chuang jian lian jie guan li qi 。 wei shen me mo ren qing kuang xia zai shu ju liu zhong bu shi yong “ kuai su fen xi ” xuan xiang ? “ kuai su fen xi ” xuan xiang shi zai shi dang de qing kuang xia cai neng shi yong de xuan xiang 。 ta bu zhi chi te ding yu qu yu she zhi de fen xi huo “ nian - yue - ri ” yi wai de ri qi ge shi 。 ta zhi dui you xian de shu ju ge shi you yong , dui yu zhe xie ge shi lai shuo , ci xuan xiang de fen xi su du ke neng bi mo ren de biao zhun fen xi fang shi geng kuai 。 yin ci , yong hu bi xu ji yu zi ji de shu ju ge shi xian shi xuan ze ci xuan xiang 。 wei shen me WMI shu ju ren wu he shi jian ren wu shi xiang hu du li de ? xi tong guan li shu ju ke yong yu ying xiang DTS kong zhi liu 。 li ru , yun xing ETL liu zhi qian , ke yi jian cha SQL Server shi fou zheng zai yun xing 、 ji suan ji shang shi fou you ke yong de C: qu dong qi huo zhe shi fou you zu gou de ke yong ci pan kong jian 。WMI shu ju ren wu yong lai jian suo ci lei xi tong shu ju 。 xi tong guan li shi jian ke yong yu zai DTS kong zhi liu zhong zhi xing shi shi cao zuo 。 li ru , jin dang nei cun shi yong liang xia jiang dao 50% yi xia shi cai yun xing ETL liu , huo zhe jin dang wen jian xi tong shang you ke yong de xin yuan wen jian shi cai qi dong shu ju liu 。WMI shi jian ren wu yuan xu ding yi he chu li ci lei xi tong shi jian 。 er qie , zhe liang zhong ren wu zai suo ti gong de gong neng fang mian ye ji ben shang shi bu tong de 。 zai ben fa xing ban zhong , wo men ke yi geng zhu dong di gen ju ren wu ti gong de gong neng dui ren wu jin xing chai fen , yi chuang jian geng you zhen dui xing de ruan jian bao 。 zhe zhong chai fen de ling yi ge li zi shi wen jian xi tong ren wu he FTP ren wu 。 zai DTS 2000 zhong , zhe liang ge ren wu ti gong de gong neng bei zu he dao yi ge ren wu zhong , dan zai ben fa xing ban zhong , zhe liang ge ren wu bei chai fen kai lai , cong er shi yong hu geng rong yi chuang jian 、 li jie he zhi chi ruan jian bao 。 wei shen me biao da shi yu yan ji bu shi SQL ye bu shi Visual Basic? yin wei SQL he Visual Basic dou bu neng man zu DTS shu ju liu de yao qiu 。 li ru , wo men xiang zhi chi yi zu yun suan fu , bi ru yong yu chu li hen duo qing kuang xia zuo wei biao ji shi yong de wei yan ma de an wei yun suan fu 。 ci wai , wei le geng hao di li yong nei cun ( cong er huo de zui jia xing neng ),DTS shu ju liu dui shu ju lei xing you zhe yan ge de xian zhi , zhe ye fan yang zai biao da shi yu fa zhong 。 DTS biao da shi yu fa shi nin neng gou she ji chu tong guo fu duo de zi fu chuan he shu ju lei xing chu li er huo de gao xing neng de shu ju liu 。 ru guo biao da shi yu yan bu zhi chi nin xu yao de mou xie han shu , huo zhe nin geng xi huan shi yong Visual Basic yu fa , na me nin ke yi shi yong jiao ben zu jian , jiao ben zu jian yuan xu nin zai shu ju liu zhong shi yong Visual Basic .NET。 wei shen me you xie han shu bu zai biao da shi yu yan zhong ? you yu zi yuan xian zhi , wu fa shi xian mu qian ke cong SQL Server TSQL zhong zhao dao de mei ge han shu 。 she zhi di yi pi han shu shi wo men zeng zi xun guo ke hu he kai fa ren yuan , wo men hui ren zhen kao lv shou dao de ce shi ban fan kui xin xi , wei yi hou de ce shi ban he zui zhong ban ben zuo hao zhun bei 。 wei shen me bi xu zai yuan shi pei qi , er bu shi zai shi yong zu jian ( li ru he bing ) zhong pei zhi pai xu shun xu ? xing de shun xu shi zai yuan shi pei qi zhong she zhi de , bing qie wu fa tong guo da duo shu xia you zhuan huan jin xing geng gai ( pai xu ke neng shi yi ge li wai )。 neng gou shi bie yuan shu ju shun xu de yuan shi pei qi wu xu yong hu bang zhu ji ke she zhi ci xin xi , dan zai da duo shu qing kuang xia , ti gong gei yuan zu jian de yuan shu ju bu chong fen , shi yuan zu jian wu fa she zhi shu chu lie pai xu xin xi , yin ci yong hu xu yao zi xing wan cheng ci cao zuo 。 wei shen me bi xu zai ruan jian bao zhong suo ding bian liang ? dang shi yu gai jin bing fa xing bing qie zhe yang ke yi ti gao xing neng he ke shen suo xing shi ,DTS yun xing shi jiang shi yong duo ge xian cheng lai wan cheng zhi xing 。 wei le bi mian duo ge xian cheng tong shi shi tu fang wen yi ge bian liang , bi xu wei nin de cao zuo suo ding bian liang , cong er shi dui bian liang de suo you fang wen dou shi “ an quan de ”; ru guo bu zhe yang zuo , ke neng hui dao zhi ruan jian bao chu xian ge zhong xiang ying , cong “ you shi bu gong zuo ” dao fan hui wan quan bu zheng que de jie guo 。 ji shi ruan jian bao shi wan quan xian xing de , zhe ye ke neng shi yi ge wen ti : li ru , ru guo yong hu yao geng gai xun huan zhong de bing fa she zhi 。 wei shen me fen li shu chu lu jing shi mei you xiang zu jian fa chu tong zhi ? DTS she ji qi yong hu ying dang neng gou shan chu lu jing ran hou chong xin fu zhe lu jing , zhe yang cai bu hui po huai ruan jian bao huo geng gai ruan jian bao de xing wei 。 tong guo ti gong OnOutputPathDetached fang fa , wo men yuan xu xing wei bu dang de zu jian bu zun shou ci gui ze 。 wei le man zu xi wang ti gong duo ge shu chu de zu jian zuo zhe de xu yao ,DTS dui xiang mo xing ti gong le yi ge ming wei DeleteOutputOnPathDetached de shu chu shu xing , ru guo jiang ci shu xing she zhi wei true, dang lu jing bei fen li shi , shu chu jiang zi dong bei shan chu 。 shi yong yu DTS de xin de Windows fu wu yuan xu cao zuo yuan cha kan bing ting zhi te ding fu wu qi shang yun xing de DTS ruan jian bao 。 ci fu wu zai SQL Management Studio zhong ti gong 。 zhu yi : xu yao shou xian qi dong DTS fu wu , yin wei mo ren qing kuang xia ta shi bei jin yong de 。 wei shen me zai Mgt Studio zhong wu fa zai DTS fu wu qi xia kan dao zheng zai yun xing de ruan jian bao ? mo ren qing kuang xia DTS fu wu shi bei jin yong de 。 zhe shi gu yi she ji de , mu de shi wei le shi xi tong guan li yuan ke yi kong zhi he shi yun xing gai fu wu 。 yao qi dong DTS fu wu , qing you jian dan ji “ wo de dian nao ” bing xuan ze “ guan li ”( cong “ kai shi ” an niu huo cong zhuo mian shang yun ke ), ran hou zai “ ji suan ji guan li ” chuang kou zhong shuang ji “ fu wu he ying yong cheng xu ”, ran hou dan ji “ fu wu ”, ji ke kan jian zai you ce lie chu de suo you Windows fu wu 。 zai lie biao zhong zhao dao “DTS fu wu qi ”, you jian dan ji bing xuan ze “ qi dong ”。( ru guo nin xi wang zai mei ci qi dong ji suan ji shi zi dong qi dong gai fu wu , huan ke yi shuang ji gai fu wu yi da kai ta de shu xing , jiang “ qi dong lei xing ” geng gai wei “ zi dong ”。) wei shen me mo ren qing kuang xia ruan jian bao ri zhi ji lu bu zai wei yu xi tong shu ju ku MSDB zhong ? SQL 2005 DTS wei zai ri zhi zhong ji lu you guan shu ju ku de xin xi tian jia le hen duo xin xuan xiang 。 zhe yuan xu nin wei mei ge ruan jian bao ding yi yi ge huo duo ge bu tong lei xing de ri zhi ti gong cheng xu 。 ri zhi ti gong cheng xu lei xing bao kuo wen ben wen jian 、SQL Server、Windows shi jian ri zhi deng deng 。 zai nin de ruan jian bao zhong , tong guo zhuan dao “DTS” cai dan bing xuan ze “ ri zhi ji lu ”, ke yi tian jia ri zhi ti gong cheng xu 。 wei shen me zai yuan shi pei qi zhong kan bu dao XML wen dang jia gou de bian hua ? XML wen dang jia gou de bian hua jiang ji da di ying xiang shu ju liu de yuan shu ju 。 zhe yao qiu yong hu xian shi geng gai jia gou bing zai geng gai shi kao lv dao yuan shu ju de bian hua 。 wei shen me wo zai qian yi yin yong DTSGlobalVariables fu shu xing de ruan jian bao shi hui yu dao wen ti ? DTS 2005 zhong fa sheng geng gai de fan wei yao qiu wan quan chong xie dui xiang mo xing 。 zuo wei qian yi dao SQL Server 2005 DTS de jie guo , yin yong tong guo DTSGlobalVariables fu shu xing fang wen de SQL Server 2000 DTS dui xiang de ActiveX jiao ben jiang bu zai you xiao 。 wei shen me wo zai qian yi shu ju beng ren wu shi hui yu dao wen ti ? DTS 2005 shu ju liu ren wu qu dai le DTS 2000 shu ju zhuan huan ren wu , shi gong neng you le hen da de gai jin 。 dan zhe yang de jie guo shi ,2000 he 2005 suo ti gong de gong neng zhi jian mei you ming que de dui ying 。 wei le que bao yi qian de shu ju zhuan huan ren wu neng gou ji xu zheng que cao zuo , mei you jiang ta men wan quan qian yi dao SQL Server 2005。 qian yi xiang dao dang qian jiang zhe yang de ren wu bao zhuang zai zhuan yong de SQL Server 2000 ruan jian bao zhong , bing cong zhi xing SQL Server 2000 DTS ruan jian bao ren wu tiao yong ta 。 wei shen me wo bu neng qian yi dong tai shu xing ren wu ? yin wei ci ren wu zhi jie yi lai yu bu zai ti gong de DTS 2000 dui xiang mo xing , qian yi xiang dao dang qian wei ci ren wu ti gong de zhi chi hen you xian 。 ci ren wu de shi li bei jiao ben ren wu qu dai , jiao ben ren wu zhong bao han miao shu zeng you ci ren wu she zhi de shu xing de zhu shi 。 yao hui fu yi qian de gong neng , bi xu jin xing shou dong xiu gai 。 wei shen me quan ju bian liang zai ActiveX jiao ben ren wu zhong bu ke yong ? Beta 2 bu zhi chi fang wen quan ju bian liang 。 wei shen me bu zai DTS zhong bao kuo shu ju zhuan huan ren wu he shu ju qu dong de cha xun ren wu ? SQL Server 2005 bao kuo de shu ju liu ren wu qu dai le zhe liang ge SQL 2000 ren wu 。 shu ju liu ren wu dui shu ju yuan 、 mu biao he zhuan huan de shu liang mei you xian zhi , er zai SQL 2000 zhong , yong hu dui mei ge ren wu zhi neng shi yong yi ge shu ju yuan 、 yi ge mu biao he yi ge zhuan huan 。 zhi chi zhe xiang kuo zhan gong neng suo xu de xin dui xiang mo xing wu fa rong na zhe liang ge gong neng bu tai qiang de ren wu 。 wei shen me DTS bu zai shi ke hu duan ke zai fen fa de ? DTS yi bei chong xie , cong SQL Server 2000 zhong you yong de shi yong cheng xu bian cheng le SQL Server 2005 zhong gong neng feng fu de ying yong cheng xu he ping tai 。 zhe zhong bian hua tong shi dai lai wei DTS yong hu ti gong fu wu he zhi chi de ze ren , zhe xie fu wu he zhi chi zui hao tong guo guan li he xu ke yu qi ta SQL fu wu qi ying yong cheng xu lei si de DTS yin qing gong neng lai chu li 。 yin ci , sui ran yong hu ke yi shi yong bu shu xiang dao qing song bu shu ruan jian bao , dan ta men bi xu zai xu yao yun xing ruan jian bao de mei tai ji suan ji shang yun xing SQL Server 2005 an zhuang cheng xu bing an zhuang DTS。 zhe bu jin you zhu yu que bao yong hu / ji suan ji shi yong zheng que ban ben de DTS ke zhi xing cheng xu , huan you zhu yu gai ruan jian yi hou de geng xin 。 wei shen me DTS bu zhi chi ji yu MSI de bu shu ? ji yu MSI de bu shu ju you wan quan du li an zhuang de you dian , dan ta xu yao zai fen fa DTS er jin zhi wen jian 。 ru guo xu yao mou ge chong yao de an quan xiu bu cheng xu , na me yi tuo guan fang shi jiang xiu bu cheng xu ying yong dao mei ge bu shu mu biao shi bu ke neng de 。 dang qian de bu shu shi yong cheng xu yao qiu mu biao fu wu qi shang yi an zhuang DTS, yin wei zhe dui guan li yuan lai shuo cai shi geng you yong de mo xing 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
上海柏雅居酒店模拍
清晨美丽的风景
梦清园的靓丽女生
妖艳的食人花(7)
且行且攝------"色"影大連
【做股票的朋友看过来-华尔街的铜牛】
端午节后闲逛
捐款赈灾吴川行 花絮
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有