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

Karen

Have a look here

http://www.microsoft.com/sql/2005/pr...5features.mspx



AFAIK Express will only have IMPORT/EXPORT functionality.

Allan

"karenmiddleol (AT) yahoo (DOT) com" <karenmiddleol (AT) yahoo (DOT) com> wrote

Allan

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

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



"karenmiddleol (AT) yahoo (DOT) com" <karenmiddleol (AT) yahoo (DOT) com> wrote

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



"karenmiddleol (AT) yahoo (DOT) com" <karenmiddleol (AT) yahoo (DOT) com> wrote

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 (AT) yahoo (DOT) com> wrote

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 (AT) no-spam (DOT) sqldts.com> wrote

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_...egory/460.aspx

Allan



"Tim Boyer" <thboyer (AT) terranova (DOT) co.nz> wrote

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/prodinf...-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 (AT) no-spam (DOT) sqldts.com> wrote