Re: How to deploy a package to client PC ?

From: "Allan Mitchell" <allan@xxxxxxxxxxxxxxxxxx>
Date: Mon, 12 Feb 2007 11:27:47 +0000

Chances are you are seeing this

http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

"ABC" <abc@xxxxxxx> wrote in message news:uQWi72oTHHA.2212@xxxxxxxxxxxxxxxxxxxx:

As the security requirements, We have a ftp download package which must run
on another PC from SQL Server,
When I deploy a package to client, run it using "dtexec".

The error is display "The task "XXX" cannot run on this edition of
Integration Services. It requires a higher level edition."

Our database server is standard version. I can run it on BI, but use
command line cannot. Why!!

References:
- How to deploy a package to client PC ?
  - From: ABC

Prev by Date: Re: running a SSIS package from a scheduled job sql server 2005
Next by Date: How to use XML Task to read the whole XML file content ?
Previous by thread: How to deploy a package to client PC ?
Next by thread: How to use XML Task to read the whole XML file content ?
Index(es):
- Date
- Thread

Relevant Pages

Re: Catastrophic failure
... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... > designed the package for the Data Source for my dbf Connection (Source ... > only some time - say the very first time - that to again very rare. ... >> Allan Mitchell MCSE,MCDBA, ...
(microsoft.public.sqlserver.dts)
Re: DTS and MSDE
... "Allan Mitchell" wrote: ... box that does the calling of the package as the package runs from the ... I will presume that the package is stored on a SQL Server somewhere. ... I've even used the "sa" login to execute the dts pkg and still ...
(microsoft.public.sqlserver.dts)
Re: Business intel SQL2005 packages
... I have logging working on it now. ... I have saved the password in connection in the package and all works fine, ... "Allan Mitchell" wrote: ... OK when you say it does not work in SQL Server then I presume you mean there ...
(microsoft.public.sqlserver.dts)
Re: How to do this from DTS?
... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... Package Task 'DTSStep_DTSExecuteSQLTask_10' was not found) even though ...
(microsoft.public.sqlserver.dts)
Re: How to do this from DTS?
... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... www.SQLDTS.com - The site for all your DTS needs. ... Package Task 'DTSStep_DTSExecuteSQLTask_10' was not found) even though ...
(microsoft.public.sqlserver.programming)