SSIS package error
I got this error SSIS package error after installation.
Kindly help. Thanks in advance.
May 13th, 2013 9:01am
Did you install the BIDS from the SQL server installation disk?Michael Wandzik | Please mark the post as answered if it answers your question
Free Windows Admin Tool Kit Click here and download it now
May 13th, 2013 9:09am
Hi Michael,
I installed BIDS.
May 13th, 2013 9:23am
Hi bgt_790,
Please check the edition of the SQL Server. If the SQL Server edition is Express with Advanced Services, the Integration Services is not supported by this edition, hence a SSIS package cannot be opened in the BIDS installed by this edition of SQL Server.
In this condition, please upgrade to SQL Server 2008 R2 Stanard Edition or higher, or uninstall the SQL Server Express with Advanced Services, and then install SQL Server Evaluation, Standard or higher.
Regards,Mike Yin
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
May 16th, 2013 11:24pm
Hi bgt_790,
Please check the edition of the SQL Server. If the SQL Server edition is Express with Advanced Services, the Integration Services is not supported by this edition, hence a SSIS package cannot be opened in the BIDS installed by this edition of SQL Server.
In this condition, please upgrade to SQL Server 2008 R2 Stanard Edition or higher, or uninstall the SQL Server Express with Advanced Services, and then install SQL Server Evaluation, Standard or higher.
Regards,Mike Yin
TechNet Community Support
May 16th, 2013 11:24pm
Hi bgt_790,
Please check the edition of the SQL Server. If the SQL Server edition is Express with Advanced Services, the Integration Services is not supported by this edition, hence a SSIS package cannot be opened in the BIDS installed by this edition of SQL Server.
In this condition, please upgrade to SQL Server 2008 R2 Stanard Edition or higher, or uninstall the SQL Server Express with Advanced Services, and then install SQL Server Evaluation, Standard or higher.
Regards,Mike Yin
TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2013 6:23am
Hi bgt_790,
Please check the edition of the SQL Server. If the SQL Server edition is Express with Advanced Services, the Integration Services is not supported by this edition, hence a SSIS package cannot be opened in the BIDS installed by this edition of SQL Server.
In this condition, please upgrade to SQL Server 2008 R2 Stanard Edition or higher, or uninstall the SQL Server Express with Advanced Services, and then install SQL Server Evaluation, Standard or higher.
Regards,Mike Yin
TechNet Community Support
May 17th, 2013 6:23am