Groups | Blog | Home
all groups > sql server dts > september 2005 >

sql server dts : DTS with SQL Express 2005


karenmiddleol NO[at]SPAM yahoo.com
9/17/2005 3:37:36 AM
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
karenmiddleol NO[at]SPAM yahoo.com
9/17/2005 5:04:46 AM
Allan

When you say Export & Import do you mean - BCP.

Thanks
Karen
Allan Mitchell
9/17/2005 10:50:11 AM
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]
Allan Mitchell
9/17/2005 12:34:21 PM
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 NO[at]SPAM yahoo.com
9/17/2005 7:45:23 PM
I thought the IMPORT/EXPORT wizard was based on DTS.

Karen
Allan Mitchell
9/18/2005 7:51:13 AM
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]
RSH
9/20/2005 10:01:00 AM
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]

Josep
9/26/2005 4:01:54 PM
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]

Josep
9/27/2005 10:40:59 AM

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]

Allan Mitchell
11/14/2005 6:48:46 AM
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
11/14/2005 11:27:41 AM
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]

Tim Boyer
11/15/2005 12:00:00 AM
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
11/15/2005 8:39:43 PM
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
11/16/2005 12:00:00 AM
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
Allan Mitchell
11/17/2005 12:00:00 AM
Yep. The file should be called DTSWizard.exe. Do you not have a DTS
directory anywhere?

[quoted text, click to view]
Anthony Main
11/17/2005 1:18:36 AM


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

Josep
11/21/2005 9:17:16 AM

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]

AddThis Social Bookmark Button