I have an SSIS package created in Visual Studio .NET 2008 which contains a
Script Task. When I open the Script Task Editor and click on the 'Edit
Script' button. I get the following error message. When I check the GAC I
have version 8.0.0.0 of the missing file but not 9.0.0.0.

On the same PC I have the developer edition of SQL Server 2008 installed
with the Integration Services option.

Thanks.

TITLE: Microsoft Visual Studio
------------------------------

Cannot show Visual Studio 2008 Tools for Applications editor.

------------------------------
ADDITIONAL INFORMATION:

Could not load file or assembly 'VSTADTEProvider.Interop, Version=9.0.0.0,
Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies.
The system cannot find the file specified.
(Microsoft.SqlServer.VSTAScriptingLib)

------------------------------
BUTTONS:

OK
------------------------------

--
TomM

Hi Tom,
Thank you for using Microsoft MSDN Managed Newsgroup. This is Charles and I will assist you on this issue.

From your description, I understand that when you tried to open your SSIS Script Task of your SSIS package in
Visual Studio .NET 2008, you encountered the error that could not load file or assembly
'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its
dependencies. The system cannot find the file specified. '
If I have misunderstood, please let me know.

The error message indicates that the assembly was not correctly installed on your computer. I recommend
that you try uninstalling and installing your SQL Server 2008 workstation components again:
1. Go to Add/Remove Program in Control Panel, locate Microsoft SQL Server 2008 and click Change/Remove
button;
2. Click Remove, during the process, in the "Select Instance" window, choose "<<Remove shared features
only>>", and click Next, choose "Select All" to remove all the shared features and click Next to remove them;
3. After the uninstallation finishes, reinstall them from your SQL Server 2008 setup program.

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

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.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from
the community or a Microsoft Support Engineer within 2 business day is acceptable. Please note that each
follow up response may take approximately 2 business days as the support professional working with you
may need further investigation to reach the most efficient resolution. The offering is not appropriate for
situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled
working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services
(CSS) at http://msdn.microsoft.com/en-us/subs.../aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
Thank you for using Microsoft MSDN Managed Newsgroup. This is Charles and I will assist you on this issue.

From your description, I understand that when you tried to open your SSIS Script Task of your SSIS package in
Visual Studio .NET 2008, you encountered the error that could not load file or assembly
'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its
dependencies. The system cannot find the file specified. '
If I have misunderstood, please let me know.

The error message indicates that the assembly was not correctly installed on your computer. I recommend
that you try uninstalling and installing your SQL Server 2008 workstation components again:
1. Go to Add/Remove Program in Control Panel, locate Microsoft SQL Server 2008 and click Change/Remove
button;
2. Click Remove, during the process, in the "Select Instance" window, choose "<<Remove shared features
only>>", and click Next, choose "Select All" to remove all the shared features and click Next to remove them;
3. After the uninstallation finishes, reinstall them from your SQL Server 2008 setup program.

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

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.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from
the community or a Microsoft Support Engineer within 2 business day is acceptable. Please note that each
follow up response may take approximately 2 business days as the support professional working with you
may need further investigation to reach the most efficient resolution. The offering is not appropriate for
situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled
working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services
(CSS) at http://msdn.microsoft.com/en-us/subs.../aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
Thank you for using Microsoft MSDN Managed Newsgroup. This is Charles and I will assist you on this issue.

From your description, I understand that when you tried to open your SSIS Script Task of your SSIS package in
Visual Studio .NET 2008, you encountered the error that could not load file or assembly
'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its
dependencies. The system cannot find the file specified. '
If I have misunderstood, please let me know.

The error message indicates that the assembly was not correctly installed on your computer. I recommend
that you try uninstalling and installing your SQL Server 2008 workstation components again:
1. Go to Add/Remove Program in Control Panel, locate Microsoft SQL Server 2008 and click Change/Remove
button;
2. Click Remove, during the process, in the "Select Instance" window, choose "<<Remove shared features
only>>", and click Next, choose "Select All" to remove all the shared features and click Next to remove them;
3. After the uninstallation finishes, reinstall them from your SQL Server 2008 setup program.

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

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.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from
the community or a Microsoft Support Engineer within 2 business day is acceptable. Please note that each
follow up response may take approximately 2 business days as the support professional working with you
may need further investigation to reach the most efficient resolution. The offering is not appropriate for
situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled
working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services
(CSS) at http://msdn.microsoft.com/en-us/subs.../aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
Thank you for using Microsoft MSDN Managed Newsgroup. This is Charles and I will assist you on this issue.

From your description, I understand that when you tried to open your SSIS Script Task of your SSIS package in
Visual Studio .NET 2008, you encountered the error that could not load file or assembly
'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its
dependencies. The system cannot find the file specified. '
If I have misunderstood, please let me know.

The error message indicates that the assembly was not correctly installed on your computer. I recommend
that you try uninstalling and installing your SQL Server 2008 workstation components again:
1. Go to Add/Remove Program in Control Panel, locate Microsoft SQL Server 2008 and click Change/Remove
button;
2. Click Remove, during the process, in the "Select Instance" window, choose "<<Remove shared features
only>>", and click Next, choose "Select All" to remove all the shared features and click Next to remove them;
3. After the uninstallation finishes, reinstall them from your SQL Server 2008 setup program.

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

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.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from
the community or a Microsoft Support Engineer within 2 business day is acceptable. Please note that each
follow up response may take approximately 2 business days as the support professional working with you
may need further investigation to reach the most efficient resolution. The offering is not appropriate for
situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled
working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services
(CSS) at http://msdn.microsoft.com/en-us/subs.../aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
Thank you for using Microsoft MSDN Managed Newsgroup. This is Charles and I will assist you on this issue.

From your description, I understand that when you tried to open your SSIS Script Task of your SSIS package in
Visual Studio .NET 2008, you encountered the error that could not load file or assembly
'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its
dependencies. The system cannot find the file specified. '
If I have misunderstood, please let me know.

The error message indicates that the assembly was not correctly installed on your computer. I recommend
that you try uninstalling and installing your SQL Server 2008 workstation components again:
1. Go to Add/Remove Program in Control Panel, locate Microsoft SQL Server 2008 and click Change/Remove
button;
2. Click Remove, during the process, in the "Select Instance" window, choose "<<Remove shared features
only>>", and click Next, choose "Select All" to remove all the shared features and click Next to remove them;
3. After the uninstallation finishes, reinstall them from your SQL Server 2008 setup program.

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

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.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from
the community or a Microsoft Support Engineer within 2 business day is acceptable. Please note that each
follow up response may take approximately 2 business days as the support professional working with you
may need further investigation to reach the most efficient resolution. The offering is not appropriate for
situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled
working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services
(CSS) at http://msdn.microsoft.com/en-us/subs.../aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
Thank you for using Microsoft MSDN Managed Newsgroup. This is Charles and I will assist you on this issue.

From your description, I understand that when you tried to open your SSIS Script Task of your SSIS package in
Visual Studio .NET 2008, you encountered the error that could not load file or assembly
'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its
dependencies. The system cannot find the file specified. '
If I have misunderstood, please let me know.

The error message indicates that the assembly was not correctly installed on your computer. I recommend
that you try uninstalling and installing your SQL Server 2008 workstation components again:
1. Go to Add/Remove Program in Control Panel, locate Microsoft SQL Server 2008 and click Change/Remove
button;
2. Click Remove, during the process, in the "Select Instance" window, choose "<<Remove shared features
only>>", and click Next, choose "Select All" to remove all the shared features and click Next to remove them;
3. After the uninstallation finishes, reinstall them from your SQL Server 2008 setup program.

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

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.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from
the community or a Microsoft Support Engineer within 2 business day is acceptable. Please note that each
follow up response may take approximately 2 business days as the support professional working with you
may need further investigation to reach the most efficient resolution. The offering is not appropriate for
situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled
working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services
(CSS) at http://msdn.microsoft.com/en-us/subs.../aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
Thank you for using Microsoft MSDN Managed Newsgroup. This is Charles and I will assist you on this issue.

From your description, I understand that when you tried to open your SSIS Script Task of your SSIS package in
Visual Studio .NET 2008, you encountered the error that could not load file or assembly
'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its
dependencies. The system cannot find the file specified. '
If I have misunderstood, please let me know.

The error message indicates that the assembly was not correctly installed on your computer. I recommend
that you try uninstalling and installing your SQL Server 2008 workstation components again:
1. Go to Add/Remove Program in Control Panel, locate Microsoft SQL Server 2008 and click Change/Remove
button;
2. Click Remove, during the process, in the "Select Instance" window, choose "<<Remove shared features
only>>", and click Next, choose "Select All" to remove all the shared features and click Next to remove them;
3. After the uninstallation finishes, reinstall them from your SQL Server 2008 setup program.

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

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.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from
the community or a Microsoft Support Engineer within 2 business day is acceptable. Please note that each
follow up response may take approximately 2 business days as the support professional working with you
may need further investigation to reach the most efficient resolution. The offering is not appropriate for
situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled
working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services
(CSS) at http://msdn.microsoft.com/en-us/subs.../aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

Hi Tom,
Thank you for using Microsoft MSDN Managed Newsgroup. This is Charles and I will assist you on this issue.

From your description, I understand that when you tried to open your SSIS Script Task of your SSIS package in
Visual Studio .NET 2008, you encountered the error that could not load file or assembly
'VSTADTEProvider.Interop, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its
dependencies. The system cannot find the file specified. '
If I have misunderstood, please let me know.

The error message indicates that the assembly was not correctly installed on your computer. I recommend
that you try uninstalling and installing your SQL Server 2008 workstation components again:
1. Go to Add/Remove Program in Control Panel, locate Microsoft SQL Server 2008 and click Change/Remove
button;
2. Click Remove, during the process, in the "Select Instance" window, choose "<<Remove shared features
only>>", and click Next, choose "Select All" to remove all the shared features and click Next to remove them;
3. After the uninstallation finishes, reinstall them from your SQL Server 2008 setup program.

Hope this helps. If you have any other questions or concerns, please feel free to let me know.

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.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...#notifications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from
the community or a Microsoft Support Engineer within 2 business day is acceptable. Please note that each
follow up response may take approximately 2 business days as the support professional working with you
may need further investigation to reach the most efficient resolution. The offering is not appropriate for
situations that require urgent, real-time or phone-based interactions. Issues of this nature are best handled
working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services
(CSS) at http://msdn.microsoft.com/en-us/subs.../aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

I had already uninstalled and reinstalled, however, I did not do this with
only the Shared Features. This appeared to be the trick.

Thank you, Charles!
--
TomM


""Charles Wang [MSFT]"" wrote: