Re: SQL2005 express and old DTS

#1

giovanni wrote:

Quote:

Hello everyone,
I've just installed a SQL2005 Express Ed (EE) which I'd like to
feed up with a bunch of old DTS for SQL2000 tasks. Source connection
are flat text files (.csv like).
1) in EE DTS are replaced with SSIS services for wich I can download
and use wizard to create a .dtsx packet that can be run by SSIS
command line utilities: i works fine if I feed from another SQL2000
server but not from a text file (annoying message "product level is
not...". So new .dtsx packet are useless

It's a bit confusing. When you are in SQL Server Management Studio and you ask
that an SSIS task "on the server" to be executed you might think that you are
asking that it be run "by the server". In fact it tries to run on your PC so if
you do not have Integration Services installed and running locally on your PC
you get that error. You either need to...

Remote into box running SQL Server and run it while logged into that PC

Run the package from Business Intelligence Studio which has a runtime of
Integration Services within

Install and run Integration Services on your PC

Create an Agent job on the server that runs the SSIS package and then from your
PC you can have the server execute the Agent job. Then it DOES run the package
on the server.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SQL2005 express and old DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: SQL2005 express and old DTS - 12-28-2006 , 10:24 AM