Tuesday, October 21, 2008

The product level is insufficient for component "Flat File Source"

Are you getting this error?

Executed as user: SRV001\SYSTEM. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 12:31:18 AM Error: 2008-08-07 00:31:22.80 Code: 0xC00470FE Source: Copy Data from loginv to abc DTS.Pipeline Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The product level is insufficient for component "Flat File Source" (1). End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:31:18 AM Finished: 12:31:22 AM Elapsed: 3.906 seconds. The package execution failed. The step failed.

Then Solution is just SIMPLE, Your SQL Server is not having SQL Server Analysis Services installed just install SSAS and this issue will be solved!

No comments:

Post a Comment

Please do not spam!