on 04-20-2015 11:43 AM
hello,
I need to replicate some data from WIP database to ODS database, we need this data to create reports against ODS database.
to replicate the data i create a project using SSIS , when I tried to execute the job in SQL server , the job failed and I get this error message:
Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: 12:10:00 Error: 2015-04-20 12:10:00.90 Code: 0xC00470FE Source: Data Flow Task SSIS.Pipeline Description: SSIS Error Code DTS_E_PRODUCTLEVELTOLOW. The component "Lookup" (94) cannot run on installed (64-bit) of Integration Services. It requires Standard Edition (64-bit) or higher. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 12:10:00 Finished: 12:10:00 Elapsed: 0.826 seconds. The package execution failed. The step failed.
the SQL server Integration Services is installed but why the package cann't be executed?
thank you
Regards,
Vian
Hello Vian,
I'm not an expert, but this link seems to describe exactly the error you get:
Regards,
Konstantin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
This is MS SQL Server related so I don't really understand how SAP DB could be in play here. I believe you are using MS SQL for WIP/ODS, don't you? If so - that's where the problem is. As I said, I'm not an expert in that deep MS SQL details, but this is definitely a direction you might want to looks into. If Integration Services is installed in your server instance, maybe you should look into 2nd cause mentioned in the article then.
Regards,
Konstantin
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.