?
Solved

Export\Import from a remote machine

Posted on 2007-11-26
2
Medium Priority
?
362 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

777 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