Solved

Export\Import from a remote machine

Posted on 2007-11-26
2
358 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 500 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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

910 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now