I have developed a SQL MSDE based application that uses quite a few DTS packages. Now we want to use SQL Express 2005 is it possible that the same DTS packages will run on SQL Express 2005 still Thanks Karen
Allan When you say Export & Import do you mean - BCP. Thanks Karen
Karen Have a look here http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx AFAIK Express will only have IMPORT/EXPORT functionality. Allan [quoted text, click to view] "karenmiddleol@yahoo.com" <karenmiddleol@yahoo.com> wrote in message news:1126953456.491952.260920@g44g2000cwa.googlegroups.com: > I have developed a SQL MSDE based application that uses quite a few DTS > packages. > > Now we want to use SQL Express 2005 is it possible that the same DTS > packages will run on SQL Express 2005 still > > Thanks > Karen
BCP has nothing to do with DTS as it was available long before DTS was conceived. By IMPORT/EXPORT I mean the Import/Export wizard. Allan [quoted text, click to view] "karenmiddleol@yahoo.com" <karenmiddleol@yahoo.com> wrote in message news:1126958686.067778.64870@g44g2000cwa.googlegroups.com: > Allan > > When you say Export & Import do you mean - BCP. > > Thanks > Karen
I thought the IMPORT/EXPORT wizard was based on DTS. Karen
Based on DTS in what way? Have a look at the data sources available, have a look at the dialogs, have a look at the locations for saving available. Whilst it does the same job as the old DTS Import/Export wizard I would still say it has been rewritten. Allan [quoted text, click to view] "karenmiddleol@yahoo.com" <karenmiddleol@yahoo.com> wrote in message news:1127011523.636348.168140@g47g2000cwa.googlegroups.com: > I thought the IMPORT/EXPORT wizard was based on DTS. > > Karen
What was the outcome of your findings? I have developed an application that converts hundreds of company databases to SQL Server. it works fine on a machine that I have SQL Server 2000 and SQL 2005 installed on but I am getting the dreaded "ActiveX couln't load the library" error when trying to run the application on a box that has only SQL Express installed. I found several resources that told me what DLLs and RLLs I needed but the directories don't line up and I can't register the DLLs which is a real pain. [quoted text, click to view] <karenmiddleol@yahoo.com> wrote in message news:1126953456.491952.260920@g44g2000cwa.googlegroups.com... >I have developed a SQL MSDE based application that uses quite a few DTS > packages. > > Now we want to use SQL Express 2005 is it possible that the same DTS > packages will run on SQL Express 2005 still > > Thanks > Karen >
SQL Server 2005 Express edition does not support DTS. But I hope there's a way to do it. The DTS version of SQL Server 2000 can run stand-alone, so without SQL Server installed. It needs just a few DLL's. What I'm going to do (I haven't done it yet) is to run a 2000 DTS on a 2005 Express. I hope it will work !! :) Have someone already tried it? I'll let you know how it's my experience on it ;) Josep. "Allan Mitchell" <allan@no-spam.sqldts.com> escribió en el mensaje news:uyNxTW3uFHA.3000@TK2MSFTNGP12.phx.gbl... [quoted text, click to view] > Karen > > Have a look here > > http://www.microsoft.com/sql/2005/productinfo/sql2005features.mspx > > > > AFAIK Express will only have IMPORT/EXPORT functionality. > > Allan > > "karenmiddleol@yahoo.com" <karenmiddleol@yahoo.com> wrote in message > news:1126953456.491952.260920@g44g2000cwa.googlegroups.com: > >> I have developed a SQL MSDE based application that uses quite a few DTS >> packages. >> >> Now we want to use SQL Express 2005 is it possible that the same DTS >> packages will run on SQL Express 2005 still >> >> Thanks >> Karen >
I haven't tried it yet, but here http://www.sqldts.com/default.aspx?225 explains really good what you need to use DTS2000. My worries is that maybe you couldn't do it if you already have a SQL 2005 Express installed. Have you tried to use this DLL in a computer without any SQL Server instal·led? Josep. "RSH" <way_beyond_oops@yahoo.com> escribió en el mensaje news:%23t917uevFHA.3588@tk2msftngp13.phx.gbl... [quoted text, click to view] > What was the outcome of your findings? > > I have developed an application that converts hundreds of company > databases to SQL Server. it works fine on a machine that I have SQL > Server 2000 and SQL 2005 installed on but I am getting the dreaded > "ActiveX couln't load the library" error when trying to run the > application on a box that has only SQL Express installed. > > I found several resources that told me what DLLs and RLLs I needed but the > directories don't line up and I can't register the DLLs which is a real > pain. > > > <karenmiddleol@yahoo.com> wrote in message > news:1126953456.491952.260920@g44g2000cwa.googlegroups.com... >>I have developed a SQL MSDE based application that uses quite a few DTS >> packages. >> >> Now we want to use SQL Express 2005 is it possible that the same DTS >> packages will run on SQL Express 2005 still >> >> Thanks >> Karen >> > >
I do not have the Express BOL installed but in my BOL it is here ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/a104407e-2026-4c42-80ff-d44f30d598cb.htm Have you found the wizard? http://sqljunkies.com/WebLog/knight_reign/archive/category/460.aspx Allan [quoted text, click to view] "Tim Boyer" <thboyer@terranova.co.nz> wrote in message news:uXI$9FK6FHA.1020@TK2MSFTNGP15.phx.gbl: > Allan > where is the "SQL Express" Import/Export wizard documented or indeed > where/how is this function invoked? > there is no mention of Import/Export in the express "Books online" > regards Tim > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > news:%23%23CP9WCvFHA.3124@TK2MSFTNGP12.phx.gbl... > > > Based on DTS in what way? Have a look at the data sources available, > have > > a look at the dialogs, have a look at the locations for saving > available. > > Whilst it does the same job as the old DTS Import/Export wizard I > would > > still say it has been rewritten. > > > > > > > > Allan > > > > > > > > "karenmiddleol@yahoo.com" <karenmiddleol@yahoo.com> wrote in message > > news:1127011523.636348.168140@g47g2000cwa.googlegroups.com: > > > > >> I thought the IMPORT/EXPORT wizard was based on DTS. > >> > >> Karen > > >
Allan where is the "SQL Express" Import/Export wizard documented or indeed where/how is this function invoked? there is no mention of Import/Export in the express "Books online" regards Tim [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:%23%23CP9WCvFHA.3124@TK2MSFTNGP12.phx.gbl... > Based on DTS in what way? Have a look at the data sources available, have > a look at the dialogs, have a look at the locations for saving available. > Whilst it does the same job as the old DTS Import/Export wizard I would > still say it has been rewritten. > > > > Allan > > > > "karenmiddleol@yahoo.com" <karenmiddleol@yahoo.com> wrote in message > news:1127011523.636348.168140@g47g2000cwa.googlegroups.com: > >> I thought the IMPORT/EXPORT wizard was based on DTS. >> >> Karen >
Thanks Allan I suspect that the Import/Export utility may have been removed from the release version of SQL Express because there is no Microsoft SQL Server\90\DTS directory I wonder what was meant in the document "SQL Server 2005 Features Comparison" (Published: November 7, 2005) http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx which explicity says under the section "Integration and Interoperability" that the Express Edition supports "Import/Export" (the same as Workgroup, Standard and Enterprise) regards Tim [quoted text, click to view] "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message news:OMLdydO6FHA.1140@tk2msftngp13.phx.gbl... >I do not have the Express BOL installed but in my BOL it is here > > ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/a104407e-2026-4c42-80ff-d44f30d598cb.htm > > Have you found the wizard? > > http://sqljunkies.com/WebLog/knight_reign/archive/category/460.aspx > > Allan > > > > "Tim Boyer" <thboyer@terranova.co.nz> wrote in message > news:uXI$9FK6FHA.1020@TK2MSFTNGP15.phx.gbl: > >> Allan >> where is the "SQL Express" Import/Export wizard documented or indeed >> where/how is this function invoked? >> there is no mention of Import/Export in the express "Books online" >> regards Tim >> >> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message >> news:%23%23CP9WCvFHA.3124@TK2MSFTNGP12.phx.gbl... >> >> > Based on DTS in what way? Have a look at the data sources available, >> have >> > a look at the dialogs, have a look at the locations for saving >> available. >> > Whilst it does the same job as the old DTS Import/Export wizard I >> would >> > still say it has been rewritten. >> > >> > >> > >> > Allan >> > >> > >> > >> > "karenmiddleol@yahoo.com" <karenmiddleol@yahoo.com> wrote in message >> > news:1127011523.636348.168140@g47g2000cwa.googlegroups.com: >> > >> >> >> I thought the IMPORT/EXPORT wizard was based on DTS. >> >> >> >> Karen >> >> > >
I do not have Express installed but have read the same doc as you and find it strange that you cannot see the wizard. Have you tried looking for the executable name? Allan [quoted text, click to view] "Tim Boyer" <thboyer@terranova.co.nz> wrote in message news:ucYimjX6FHA.2616@TK2MSFTNGP15.phx.gbl: > Thanks Allan > I suspect that the Import/Export utility may have been removed from the > release version of SQL Express > because there is no Microsoft SQL Server\90\DTS directory > > I wonder what was meant in the document "SQL Server 2005 Features > Comparison" (Published: November 7, > 2005) > http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx > which explicity says under the section "Integration and > Interoperability" > that the Express Edition supports "Import/Export" (the same as > Workgroup, > Standard and Enterprise) > > regards Tim > > "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > news:OMLdydO6FHA.1140@tk2msftngp13.phx.gbl... > > >I do not have the Express BOL installed but in my BOL it is here > > > > > ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/extran9/html/a104407e-2026-4c42-80 > ff-d44f30d598cb.htm > > > > Have you found the wizard? > > > > http://sqljunkies.com/WebLog/knight_reign/archive/category/460.aspx > > > > Allan > > > > > > > > "Tim Boyer" <thboyer@terranova.co.nz> wrote in message > > news:uXI$9FK6FHA.1020@TK2MSFTNGP15.phx.gbl: > > > > >> Allan > >> where is the "SQL Express" Import/Export wizard documented or indeed > >> where/how is this function invoked? > >> there is no mention of Import/Export in the express "Books online" > >> regards Tim > >> > >> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message > >> news:%23%23CP9WCvFHA.3124@TK2MSFTNGP12.phx.gbl... > >> > > >> > Based on DTS in what way? Have a look at the data sources > available, > > >> have > > >> > a look at the dialogs, have a look at the locations for saving > > >> available. > > >> > Whilst it does the same job as the old DTS Import/Export wizard I > > >> would > > >> > still say it has been rewritten. > >> > > >> > > >> > > >> > Allan > >> > > >> > > >> > > >> > "karenmiddleol@yahoo.com" <karenmiddleol@yahoo.com> wrote in > message > >> > news:1127011523.636348.168140@g47g2000cwa.googlegroups.com: > >> > > >> > > >> >> I thought the IMPORT/EXPORT wizard was based on DTS. > >> >> > >> >> Karen > >> > >> > > > >
Allan this is the list of all the exe and dlls in the SQL Express program directories Regards Tim Directory of C:\Program Files\Microsoft SQL Server\90\COM 14/10/05 11:31 p.m. 68,824 DISTRIB.exe 14/10/05 11:45 p.m. 317,656 replmerg.exe 14/10/05 11:53 p.m. 84,696 tablediff.exe 14/10/05 11:31 p.m. 42,712 AXSCPHST90.DLL 14/10/05 11:37 p.m. 35,032 instapi.dll 14/10/05 11:42 p.m. 30,424 mergetxt.dll 14/10/05 11:42 p.m. 47,832 Microsoft.SqlServer.Replication.BusinessLogicSupport.dll 14/10/05 11:45 p.m. 197,848 msgprox.dll 14/10/05 11:46 p.m. 638,680 rdistcom.dll 14/10/05 11:45 p.m. 112,856 replerrx.dll 14/10/05 11:45 p.m. 271,064 replisapi.dll 14/10/05 11:46 p.m. 547,032 replprov.dll 14/10/05 11:46 p.m. 782,040 replrec.dll 14/10/05 11:46 p.m. 403,672 replsub.dll 14/10/05 11:45 p.m. 99,544 replsync.dll 14/10/05 11:50 p.m. 174,296 spresolv.dll 14/10/05 11:50 p.m. 145,624 sqldistx.dll 14/10/05 11:50 p.m. 192,728 sqlmergx.dll 14/10/05 11:49 p.m. 19,160 sqlresld90.dll 14/10/05 11:53 p.m. 88,792 sqlwep.dll 14/10/05 11:53 p.m. 40,664 ssradd.dll 14/10/05 11:53 p.m. 41,176 ssravg.dll 14/10/05 11:53 p.m. 27,352 ssrdown.dll 14/10/05 11:52 p.m. 39,128 ssrmax.dll 14/10/05 11:52 p.m. 39,128 ssrmin.dll 14/10/05 11:53 p.m. 28,376 ssrpub.dll 14/10/05 11:53 p.m. 27,352 ssrup.dll 14/10/05 11:53 p.m. 192,728 xmlsub.dll Directory of C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies 14/10/05 11:43 p.m. 133,848 Microsoft.ExceptionMessageBox.dll 14/10/05 11:43 p.m. 150,232 Microsoft.SqlServer.ConnectionInfo.dll 14/10/05 11:43 p.m. 68,312 Microsoft.SqlServer.RegSvrEnum.dll 14/10/05 11:44 p.m. 1,607,896 Microsoft.SqlServer.Replication.dll 14/10/05 11:43 p.m. 555,736 Microsoft.SqlServer.Rmo.dll 14/10/05 11:45 p.m. 39,640 Microsoft.SqlServer.ServiceBrokerEnum.dll 14/10/05 11:46 p.m. 1,559,256 Microsoft.SqlServer.Smo.dll 14/10/05 11:45 p.m. 223,960 Microsoft.SqlServer.SmoEnum.dll 14/10/05 11:46 p.m. 895,704 Microsoft.SqlServer.SqlEnum.dll 14/10/05 11:45 p.m. 20,184 Microsoft.SqlServer.SString.dll 14/10/05 11:46 p.m. 43,736 Microsoft.SqlServer.WmiEnum.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap 14/10/05 03:32 a.m. 213,208 ARPWrapper.exe 14/10/05 03:51 a.m. 2,068,184 setup.exe 14/10/05 03:53 a.m. 26,328 UACmd.exe 14/10/05 03:33 a.m. 1,045,720 DbgHelp.dll 14/10/05 03:42 a.m. 80,600 Microsoft.SqlServer.AnalysisServices.UpgradeAdvisor.dll 14/10/05 03:43 a.m. 56,024 Microsoft.SqlServer.BestPracticesAnalyzer.UpgradeAdvisor.dll 14/10/05 03:43 a.m. 187,096 Microsoft.SqlServer.DTS.UpgradeAdvisor.dll 14/10/05 03:42 a.m. 76,504 Microsoft.SqlServer.NotificationServices.UpgradeAdvisor.dll 14/10/05 03:45 a.m. 20,184 Microsoft.SqlServer.SString.dll 14/10/05 03:45 a.m. 35,544 Microsoft.SqlServer.UpgradeAdvisor.UaEngine.dll 14/10/05 03:46 a.m. 43,736 Microsoft.SqlServer.UpgradeAdvisor.UaInterface.dll 14/10/05 03:50 a.m. 46,296 SqlBoot.dll 14/10/05 03:51 a.m. 670,424 sqlcu.dll 14/10/05 03:53 a.m. 1,295,576 sqlspars.dll 14/10/05 03:53 a.m. 1,150,168 sqlsval.dll 14/10/05 03:53 a.m. 167,128 xmlrw.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA 14/10/05 12:19 a.m. 34,816 bpacmd.exe 14/10/05 03:31 a.m. 47,832 BpaCmdX.dll 14/10/05 03:46 a.m. 355,032 msvcr71.dll 14/10/05 03:51 a.m. 695,000 SQLBPA.dll 14/10/05 03:51 a.m. 821,976 SQLDATA.dll 14/10/05 03:53 a.m. 596,696 SQLSORT.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin 14/10/05 03:31 a.m. 51,928 BPAClient.dll 14/10/05 03:31 a.m. 51,928 bpacommon.dll 14/10/05 03:32 a.m. 199,384 BPAServer.dll 14/10/05 03:31 a.m. 20,696 BPLib.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\ASPNETUSERENCRYPTED\bin 14/10/05 03:32 a.m. 76,504 bpa.ASPNETUSERENCRYPTED.dll 1 File(s) 76,504 bytes Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\DBUNWRITABLE_UPGBLKR\bin 14/10/05 03:31 a.m. 64,216 bpa.DBUNWRITABLE_UPGBLKR.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\DUPLICATEINDEX_UPGBLKR\bin 14/10/05 03:31 a.m. 68,312 bpa.DUPLICATEINDEX_UPGBLKR.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\DUPLICATESID\bin 14/10/05 03:31 a.m. 64,216 bpa.DUPLICATESID.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\LOGINNAMEASSERVERROLE\bin 14/10/05 03:31 a.m. 64,216 bpa.LOGINNAMEASSERVERROLE.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\RESERVEDATABASEID\bin 14/10/05 03:32 a.m. 64,216 bpa.RESERVEDATABASEID.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\RSCUSTOMASSEMBLIES\bin 14/10/05 03:32 a.m. 84,696 bpa.RSCUSTOMASSEMBLIES.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\RSCUSTOMSECURITY\bin 14/10/05 03:31 a.m. 68,312 bpa.RSCUSTOMSECURITY.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\RSDEFAULTIIS\bin 14/10/05 03:32 a.m. 80,600 bpa.RSDEFAULTIIS.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\RSDEFAULTIISYUKON\bin 14/10/05 03:32 a.m. 80,600 bpa.RSDEFAULTIISYUKON.dll Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\Repository\YUK1_UPGBLKR\bin 14/10/05 03:32 a.m. 64,216 bpa.YUK1_UPGBLKR.dll Directory of C:\Program Files\Microsoft SQL Server\90\Shared 14/10/05 11:51 p.m. 80,600 SAC.exe 14/10/05 11:50 p.m. 45,272 sqladhlp90.exe 14/10/05 11:51 p.m. 239,320 sqlbrowser.exe 14/10/05 11:50 p.m. 64,728 SqlDumper.exe 14/10/05 11:51 p.m. 1,166,040 SqlSAC.exe 14/10/05 11:53 p.m. 117,464 sqlsqm.exe 14/10/05 03:53 a.m. 87,768 sqlwriter.exe 14/10/05 11:53 p.m. 92,888 SqlWtsn.exe 14/10/05 11:31 p.m. 40,664 custsat.dll
Yep. The file should be called DTSWizard.exe. Do you not have a DTS directory anywhere? [quoted text, click to view] "Tim Boyer" <thboyer@terranova.co.nz> wrote in message news:OJfdn4n6FHA.2676@TK2MSFTNGP15.phx.gbl: > Allan > this is the list of all the exe and dlls in the SQL Express program > directories > Regards Tim > > Directory of C:\Program Files\Microsoft SQL Server\90\COM > 14/10/05 11:31 p.m. 68,824 DISTRIB.exe > 14/10/05 11:45 p.m. 317,656 replmerg.exe > 14/10/05 11:53 p.m. 84,696 tablediff.exe > 14/10/05 11:31 p.m. 42,712 AXSCPHST90.DLL > 14/10/05 11:37 p.m. 35,032 instapi.dll > 14/10/05 11:42 p.m. 30,424 mergetxt.dll > 14/10/05 11:42 p.m. 47,832 > Microsoft.SqlServer.Replication.BusinessLogicSupport.dll > 14/10/05 11:45 p.m. 197,848 msgprox.dll > 14/10/05 11:46 p.m. 638,680 rdistcom.dll > 14/10/05 11:45 p.m. 112,856 replerrx.dll > 14/10/05 11:45 p.m. 271,064 replisapi.dll > 14/10/05 11:46 p.m. 547,032 replprov.dll > 14/10/05 11:46 p.m. 782,040 replrec.dll > 14/10/05 11:46 p.m. 403,672 replsub.dll > 14/10/05 11:45 p.m. 99,544 replsync.dll > 14/10/05 11:50 p.m. 174,296 spresolv.dll > 14/10/05 11:50 p.m. 145,624 sqldistx.dll > 14/10/05 11:50 p.m. 192,728 sqlmergx.dll > 14/10/05 11:49 p.m. 19,160 sqlresld90.dll > 14/10/05 11:53 p.m. 88,792 sqlwep.dll > 14/10/05 11:53 p.m. 40,664 ssradd.dll > 14/10/05 11:53 p.m. 41,176 ssravg.dll > 14/10/05 11:53 p.m. 27,352 ssrdown.dll > 14/10/05 11:52 p.m. 39,128 ssrmax.dll > 14/10/05 11:52 p.m. 39,128 ssrmin.dll > 14/10/05 11:53 p.m. 28,376 ssrpub.dll > 14/10/05 11:53 p.m. 27,352 ssrup.dll > 14/10/05 11:53 p.m. 192,728 xmlsub.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies > 14/10/05 11:43 p.m. 133,848 Microsoft.ExceptionMessageBox.dll > 14/10/05 11:43 p.m. 150,232 > Microsoft.SqlServer.ConnectionInfo.dll > 14/10/05 11:43 p.m. 68,312 > Microsoft.SqlServer.RegSvrEnum.dll > 14/10/05 11:44 p.m. 1,607,896 > Microsoft.SqlServer.Replication.dll > 14/10/05 11:43 p.m. 555,736 Microsoft.SqlServer.Rmo.dll > 14/10/05 11:45 p.m. 39,640 > Microsoft.SqlServer.ServiceBrokerEnum.dll > 14/10/05 11:46 p.m. 1,559,256 Microsoft.SqlServer.Smo.dll > 14/10/05 11:45 p.m. 223,960 Microsoft.SqlServer.SmoEnum.dll > 14/10/05 11:46 p.m. 895,704 Microsoft.SqlServer.SqlEnum.dll > 14/10/05 11:45 p.m. 20,184 Microsoft.SqlServer.SString.dll > 14/10/05 11:46 p.m. 43,736 Microsoft.SqlServer.WmiEnum.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap > 14/10/05 03:32 a.m. 213,208 ARPWrapper.exe > 14/10/05 03:51 a.m. 2,068,184 setup.exe > 14/10/05 03:53 a.m. 26,328 UACmd.exe > 14/10/05 03:33 a.m. 1,045,720 DbgHelp.dll > 14/10/05 03:42 a.m. 80,600 > Microsoft.SqlServer.AnalysisServices.UpgradeAdvisor.dll > 14/10/05 03:43 a.m. 56,024 > Microsoft.SqlServer.BestPracticesAnalyzer.UpgradeAdvisor.dll > 14/10/05 03:43 a.m. 187,096 > Microsoft.SqlServer.DTS.UpgradeAdvisor.dll > 14/10/05 03:42 a.m. 76,504 > Microsoft.SqlServer.NotificationServices.UpgradeAdvisor.dll > 14/10/05 03:45 a.m. 20,184 Microsoft.SqlServer.SString.dll > 14/10/05 03:45 a.m. 35,544 > Microsoft.SqlServer.UpgradeAdvisor.UaEngine.dll > 14/10/05 03:46 a.m. 43,736 > Microsoft.SqlServer.UpgradeAdvisor.UaInterface.dll > 14/10/05 03:50 a.m. 46,296 SqlBoot.dll > 14/10/05 03:51 a.m. 670,424 sqlcu.dll > 14/10/05 03:53 a.m. 1,295,576 sqlspars.dll > 14/10/05 03:53 a.m. 1,150,168 sqlsval.dll > 14/10/05 03:53 a.m. 167,128 xmlrw.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA > 14/10/05 12:19 a.m. 34,816 bpacmd.exe > 14/10/05 03:31 a.m. 47,832 BpaCmdX.dll > 14/10/05 03:46 a.m. 355,032 msvcr71.dll > 14/10/05 03:51 a.m. 695,000 SQLBPA.dll > 14/10/05 03:51 a.m. 821,976 SQLDATA.dll > 14/10/05 03:53 a.m. 596,696 SQLSORT.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\bin > 14/10/05 03:31 a.m. 51,928 BPAClient.dll > 14/10/05 03:31 a.m. 51,928 bpacommon.dll > 14/10/05 03:32 a.m. 199,384 BPAServer.dll > 14/10/05 03:31 a.m. 20,696 BPLib.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\ASPNETUSERENCRYPTED\bin > 14/10/05 03:32 a.m. 76,504 bpa.ASPNETUSERENCRYPTED.dll > 1 File(s) 76,504 bytes > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\DBUNWRITABLE_UPGBLKR\bin > 14/10/05 03:31 a.m. 64,216 bpa.DBUNWRITABLE_UPGBLKR.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\DUPLICATEINDEX_UPGBLKR\bin > 14/10/05 03:31 a.m. 68,312 bpa.DUPLICATEINDEX_UPGBLKR.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\DUPLICATESID\bin > 14/10/05 03:31 a.m. 64,216 bpa.DUPLICATESID.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\LOGINNAMEASSERVERROLE\bin > 14/10/05 03:31 a.m. 64,216 bpa.LOGINNAMEASSERVERROLE.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\RESERVEDATABASEID\bin > 14/10/05 03:32 a.m. 64,216 bpa.RESERVEDATABASEID.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\RSCUSTOMASSEMBLIES\bin > 14/10/05 03:32 a.m. 84,696 bpa.RSCUSTOMASSEMBLIES.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\RSCUSTOMSECURITY\bin > 14/10/05 03:31 a.m. 68,312 bpa.RSCUSTOMSECURITY.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\RSDEFAULTIIS\bin > 14/10/05 03:32 a.m. 80,600 bpa.RSDEFAULTIIS.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\RSDEFAULTIISYUKON\bin > 14/10/05 03:32 a.m. 80,600 bpa.RSDEFAULTIISYUKON.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Setup > Bootstrap\BPA\Repository\YUK1_UPGBLKR\bin > 14/10/05 03:32 a.m. 64,216 bpa.YUK1_UPGBLKR.dll > > Directory of C:\Program Files\Microsoft SQL Server\90\Shared > 14/10/05 11:51 p.m. 80,600 SAC.exe
So does anyone know where we can get hold of the said DTS dir and does it work with the final 2005 express release ?!!? So we can ALL do import/export All I want to do is import one access DB and then I'll never need it again
Well, in that case, u can install MSDE just to do this importation. You are lucky :) Josep. "Anthony Main" <anthonymain@hotmail.com> escribió en el mensaje news:e1Xxkf16FHA.3120@tk2msftngp13.phx.gbl... [quoted text, click to view] > > > So does anyone know where we can get hold of the said DTS dir and does > it work with the final 2005 express release ?!!? So we can ALL do > import/export > > All I want to do is import one access DB and then I'll never need it > again > > *** Sent via Developersdex http://www.developersdex.com ***
Don't see what you're looking for? Try a search.
|