RE: SSIS Pivot Transform Returns "The pivot key value is not valid -
06-19-2008
, 08:30 AM
Hi Joel,
Thank you for your response.
Sorry I did not say my scenario clearly. Actually it indeed could not run
at my side. What is the version of your SQL Server 2005? Was SQL Server
2005 SP2 installed on your computer?
If you have installed SP2 on your computer, you can check the file
summary.txt in the folder "C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Hotfix\" to see if the component "Integration Services" is
contained in the file and the final version number is greater than or equal
to 9.0.3042.
Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =======
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =======
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ======= |