SQL Integration service not installed -MS SQL SERVER

Posted on 2009-02-12
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.


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

    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

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    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.
    Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

    755 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

    24 Experts available now in Live!

    Get 1:1 Help Now