Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


SQL Integration service not installed -MS SQL SERVER

Posted on 2009-02-12
Medium Priority
Last Modified: 2012-05-06
We are having all sorts of issues loading flat files into SQL. The report follows.


Operation stopped...


- Initializing Data Flow Task (Success)


- Initializing Connections (Success)


- Setting SQL Command (Success)


- Setting Source Connection (Success)


- Setting Destination Connection (Success)


- Validating (Error)


· Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Source - GMIsample_csv" (1).
 (SQL Server Import and Export Wizard)

· Error 0xc00470fe: Data Flow Task: The product level is insufficient for component "Data Conversion 1" (207).
 (SQL Server Import and Export Wizard)


- Prepare for Execute (Stopped)


- Pre-execute (Stopped)


- Executing (Success)


- Copying to [Samples].[dbo].[J7Y1804] (Stopped)


- Post-execute (Stopped)


- Cleanup (Stopped)



I googled the error and found this page.  http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/289d0bbb-1d06-4856-9c66-8d3e540d7be9/


Do we need to have integration services installed on our PCs?  The below screenshot is from my machine.
Question by:GlobaLevel
1 Comment
LVL 15

Accepted Solution

MohammedU earned 2000 total points
ID: 23635510
It depends what you are using...
Some times based on the components you use you may need SSIS. You can install the developer edition to reduce the cost of licencing...
What are you running and how and from where?
If you are running from your PC...try running it on the server if you don't want to install SSIS on the PCs...

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

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

Ready to get certified? Check out some courses that help you prepare for third-party exams.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

572 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