SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Unable to Edit Script in 'Script Task Editor'


Unable to Edit Script in 'Script Task Editor'

Author
Message
sam.alexander
sam.alexander
SSC Eights!
SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)SSC Eights! (933 reputation)

Group: General Forum Members
Points: 933 Visits: 150
Hi,

Earlier today I went into one of my SSIS packages and opened Script Task then Edited the code but decided not to save it so I X'ed out of the Script Editor and then Canceled out of the Script Task Editor. Then when I went back into the same Task and clicked Edit Script I get this error:
Cannot show Visual Studio 2008 Tools for Applications Editor
Additional Info - Failed to create project at location "C:\Documents and settings\blahblah\Local Settings\Temp\SSIS\8ef498447e824e608b9053636c8b0443"! (Microsoft.SqlServer.VSTAScriptingLib)


This is using SQL Server 2008 and I can open the Script Editor in other SSIS packages or other Script Tasks within this same package so I think it's a problem with this particular Script Task. I had just started working on it a week or so ago and it's not a project script, so I have no backups. :-/ Is there anyway you guys know of to get the guts of the script without going through the SSIS Editor? If something in the package is hosed and I can salvage the code I can just delete and recreate the Script Task, but I can't even begin to remember all the code I added to it since rather involved and took a while to write.

Thanks for any suggestions or insight. Take care,

Sam
Koen Verbeeck
Koen Verbeeck
SSC Guru
SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)SSC Guru (235K reputation)

Group: General Forum Members
Points: 235511 Visits: 13380
Open the package with a text editor.
You will see the XML code of the package and somewhere in all that gibberisch, there should be your VB/C#.NET code.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search