Error - SSIS Package while running

Question

Error - SSIS Package while running

ranganathanmca

SSC Eights!

Points: 920
More actions
February 3, 2011 at 8:05 am

#233168

Hi Guys,
Actually i m facing one problem while windows scheduler running with SSIS Package.
Error Description:
Error: 2011-02-03 19:08:05.94
Code: 0xC00470FE
Source: Data Flow Task DTS.Pipeline
Description: The product level is insufficient for component "Excel Source" (
1).
End Error
Please help me to reslove this error,thanks for great help
Thanks
Ranganathan Palanisamy

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

Is there any reason why you are not using SQL Agent to run the package?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

ranganathanmca SSC Eights! Points: 920 More actions · Answer 2

Hi.,

Thanks for Reply., No reason behind using file system.,i don't have much idea about SQL Agent

I wanted to knw error Reason why it's coming?

Thanks

Phil Parkin SSC Guru Points: 246960 More actions · Answer 3

I suggest that you learn - it is a better tool to use in this situation.

Do you have SSIS installed on the machine you are doing this?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 4

What edition of SQL are you using? Express, Workgroup, Standard, Enterprise, ????

CEWII

ranganathanmca SSC Eights! Points: 920 More actions · Answer 5

Hi.,

Thanks for suggestion.,SSIS installed on my machine SQLserver 2005.,MS Excel 2007 is this problem But while saving Excel converted to Excel 97-2003..

please suggest to reslove this issue

Thanks

ranganathanmca SSC Eights! Points: 920 More actions · Answer 6

Hi Elliott Whitlow.,

Thanks for your reply.,

SQL server Details :

Microsoft SQL Server Management Studio9.00.1399.00

Microsoft Analysis Services Client Tools 2005.090.1399.00

Microsoft Data Access Components (MDAC)2000.085.1132.00 (xpsp.080413-0852)

Microsoft MSXML2.6 3.0 5.0 6.0

Microsoft Internet Explorer7.0.5730.13

Microsoft .NET Framework2.0.50727.1433

Operating System5.1.2600

Thanks

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 7

That unfortunately did not answer my question.

Do a:

SELECT @@VERSION

That will answer the question.

CEWII

ranganathanmca SSC Eights! Points: 920 More actions · Answer 8

Hi.,

thanks for reply, i thing you are expecting this answer only

Version:

thanks

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 9

According to this blog article, the issue is related to the fact that SSIS is not installed on the machine:

http://blogs.msdn.com/b/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

Or you 100% sure it is installed and up and running?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

ranganathanmca SSC Eights! Points: 920 More actions · Answer 10

Hi.,

Thanks for reply.,Actually i am doing the testing for developer machine only.,

Sql Version Detail:

SSIS Package detail :

Microsoft Visual Studio 2005

Version 8.0.50727.42 (RTM.050727-4200)

Microsoft .NET Framework

Version 2.0.50727 SP1

Installed Edition: Professional

SQL Server Analysis Services

Microsoft SQL Server Analysis Services Designer

Version 9.00.1399.00

SQL Server Integration Services

Microsoft SQL Server Integration Services Designer

Version 9.00.1399.00

SQL Server Reporting Services

Microsoft SQL Server Reporting Services Designers

Version 9.00.1399.00

Please suggest what is problem?

Thanks

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 11

And is it running? Go to SQL Server Configuration Manager to check it out.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

ranganathanmca SSC Eights! Points: 920 More actions · Answer 12

Hi

Thanks for reply., i am using sql server client only., Database connection remote path only.,

In Developer Machine every thing is running fine.while BIDS it's working fine., It's going for scheduler showing error.

Thanks

Ranganathan Palanisamy