?
Solved

Export\Import from a remote machine

Posted on 2007-11-26
2
Medium Priority
?
364 Views
Last Modified: 2008-02-01
I am running Microsoft SQL Server 2005 Standard Edition.  From the machine that SQL Server is installed, I can use the import/export funtions.

When I try to use these from a remote machine using the Microsoft SQL Server Management Studio, I receive the following error:
On the Validating Action -- Error 0xc00470fe:  Data Flow Task:  The product level is insufficient for component "Destination - test_txt" (19).

Is there a way to import/export from a remote machine?
0
Comment
Question by:FIM2003
2 Comments
 
LVL 8

Accepted Solution

by:
digital_thoughts earned 2000 total points
ID: 20350838
The error indicates the SSIS product level (standard/developer/workstation/etc) is not high enough for this component.
The product level is ignored when run from designer, but is checked when run using DTEXEC or using object model, check if the package runs in DTEXEC.

To fix this, you need to install the SSIS (not just Workstation Components) on this machine.
0
 

Author Comment

by:FIM2003
ID: 20350994
Installing the Integration services along with the Workstation Componets fixed the problem.  Thank you.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question