We help IT Professionals succeed at work.

We've partnered with Certified Experts, Carl Webster and Richard Faulkner, to bring you a podcast all about Citrix Workspace, moving to the cloud, and analytics & intelligence. Episode 2 coming soon!Listen Now

x

SQL Integration service not installed -MS SQL SERVER

Medium Priority
645 Views
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)

Messages

· 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.
Comment
Watch Question

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...

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.