Error running report: script

Showing posts with label script. Show all posts

Monday, March 26, 2012

Error when refreshing Taskpad view

When the view of a database in Enterprise Manager has been
set to "Taskpad", and this database is selected, there is
a script error reported the first time. After the error is
issued, you have to change the view to somethinh else
before you can succesfully access the Taskpad view. Does
anybody know how to correct this error?
I recall that being a bug....?
"Wilbert" <anonymous@.discussions.microsoft.com> wrote in message
news:01b101c426a9$aedacd40$3501280a@.phx.gbl...
> When the view of a database in Enterprise Manager has been
> set to "Taskpad", and this database is selected, there is
> a script error reported the first time. After the error is
> issued, you have to change the view to somethinh else
> before you can succesfully access the Taskpad view. Does
> anybody know how to correct this error?
|||I can't seem to find any documentation on it (Knowledge
Base), and I've got SP3a installed.

> I recall that being a bug....?
>
|||It's a bug with Internet Explorer (components of which are used to drive the
Taskpad) rather than SQL Server, so check that you got the latest IE patch.
Jacco Schalkwijk
SQL Server MVP
<anonymous@.discussions.microsoft.com> wrote in message
news:173401c426b5$27640960$a301280a@.phx.gbl...
> I can't seem to find any documentation on it (Knowledge
> Base), and I've got SP3a installed.
>
|||I use Windows Server 2003 with IE 6 as a platform. There
are no updates available through Windows Update. Now what?

>--Original Message--
>It's a bug with Internet Explorer (components of which
are used to drive the
>Taskpad) rather than SQL Server, so check that you got
the latest IE patch.
>--
>Jacco Schalkwijk
>SQL Server MVP
|||Its a known bug, which to my knowledge has not been fixed and the workaround
is to select a different view as you have stated. Since it has been around
for such a long time I wouldn't hold your breath about it being fixed
anytime soon.
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
<anonymous@.discussions.microsoft.com> wrote in message
news:1f8001c4276a$fbfec150$a101280a@.phx.gbl...
> I use Windows Server 2003 with IE 6 as a platform. There
> are no updates available through Windows Update. Now what?
>
> are used to drive the
> the latest IE patch.
>

Thursday, March 22, 2012

ERROR WHEN I TRY TO EDIT A SCRIPT TASK

Today, I must to re-install VS2005 and SQL Server 2005 desktop tools in my computer, because I install SQL Server 2005 SP2 desktop tool for an special features that I need.

This caused that the edition of the Script Task gives to me the following error:

Cannot show the editor for this task

Additional information:

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa.DT)

After the reinstalación, the error continues appearing, and I do not know that to do so that it works fine again.

Can any help me with this?

Thanks.

Alejandro

Are you on Vista?

http://blogs.msdn.com/mattm/archive/2007/03/09/sp2-vista-and-script-tasks.aspx|||No. I′m in XP SP2|||

Take a look at this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1270413&SiteID=1

sql

Wednesday, March 21, 2012

error when I run script

Hi All,

I can't not run the query to update data but it raice an error as below:

"Server: Msg 1101, Level 17, State 10, Line 1
Could not allocate new page for database 'TEMPDB'. There are no more pages available in filegroup DEFAULT. Space can be created by dropping objects, adding additional files, or allowing file growth."

HDD free space: 5GB
RAM: 1GB
CPU: 2.8MHz

What should I do?
Please advice me on this.

Thanks in advance,
TNLooks like your TempDb is running out of space.

Are you the database administrator?

The Fonzi approach (not reccomended) would be to restart the SQL Server Service on the server because the tempdb is recreated each time SQL Server is restarted.

In the Enterprise Manager you can right click on the tempdb and check the file growth propeties and adjust them as necessary.

Finally, I wonder what your query might be doing to fill up the tempdb. Do you want to post your script or tell us what you are trying to do?

Monday, March 19, 2012

Error when creating script to copy Stored Procedures

Our DB has around 30 SProcs - I need to move them into a script, so that it can be easily added to another server. The way I'm creating the script is to highlight all the SProcs, then copy - in my notepad screen, I paste, which gives me one script, which includes all the individual creation scripts for the Sprocs.

However, I'm getting an error when I create the script -

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'SP_MySproc'. The stored procedure will still be created.

So - what's a good, and/or easy way to structure the script, so that I can easily find WHERE to put Which SProc Script, in the list?

Hey,

You could follow those steps:

Right click Database in Sql Server Management Studio -> Tasks->Generate Scripts->choose databse ->...->check Stored Procedure->next...

|||

That still gives me the same error - I guess what I'm asking is:

how can I figure out what order the Stored Procedures need to be scripted, so this error doesn't happen?

|||

The generate script option only guarantees that the script can pass compile and the order is determined by design.

If you don't mind you could execute script twice and error should go away in the second time.

Hope this helps.

|||

Hi,

If you are sure that all procedures you need are in your script do not worry about the errors, procedures will be created and will work. The only problem will be if you call procedures from another table which are not scripted or if you script your procedures into another database (with different name) and you used call like exec [Sourcedatabase].[dbo].[Procedurename] so it is possible in this case that your procedures will not work if database [Sourcedatabase] is not visible on your server from inside your destination database so check your script for "long" calls.

If you would like to have procedures in correct order you can write TSQL script which will script procedures for you in correct order, I hear about application which can do it for you and you can do it by hands by ordering your procedures in the script the way that procedure is defined before is called by another procedure.

Thanks

JPazgier

Monday, March 12, 2012

Error when cast Varchar to decimal

I'm writing a script with an insert statment to insert records from one
database to another but I have to change the type first. How can I find out
more about what can be causing this or is it something wrong with my syntax?
The field [patient_weight] is a varchar(256) stripped of all spaces left and
right.
Thanks, Alpha
cast([patient_weight] as decimal(10,2))What result do you get here?
SELECT COUNT(*) FROM [source table name]
WHERE ISNUMERIC(patient_weight) = 0
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> I'm writing a script with an insert statment to insert records from one
> database to another but I have to change the type first. How can I find
out
> more about what can be causing this or is it something wrong with my
syntax?
> The field [patient_weight] is a varchar(256) stripped of all spaces left
and
> right.
> Thanks, Alpha
> cast([patient_weight] as decimal(10,2))
>|||I got 4. I looked at the table and they're all '0'(zero) except these 4.
"Aaron [SQL Server MVP]" wrote:
> What result do you get here?
> SELECT COUNT(*) FROM [source table name]
> WHERE ISNUMERIC(patient_weight) = 0
> --
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> > I'm writing a script with an insert statment to insert records from one
> > database to another but I have to change the type first. How can I find
> out
> > more about what can be causing this or is it something wrong with my
> syntax?
> > The field [patient_weight] is a varchar(256) stripped of all spaces left
> and
> > right.
> > Thanks, Alpha
> >
> > cast([patient_weight] as decimal(10,2))
> >
>
>|||Well, you need to fix those 4 rows.
SELECT * FROM Source_Table_Name
WHERE ISNUMERIC(patient_weight) = 0
If they look like 0's, maybe they're o's, or maybe they're zero's with
non-printable characters attached (e.g. carriage return).
UPDATE Source_Table_Name SET patient_weight = '0'
WHERE ISNUMERIC(patient_weight) = 0
--
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Alpha" <Alpha@.discussions.microsoft.com> wrote in message
news:5B264C8D-9F07-4A20-8066-93256AD0D975@.microsoft.com...
> I got 4. I looked at the table and they're all '0'(zero) except these 4.
> "Aaron [SQL Server MVP]" wrote:
> > What result do you get here?
> >
> > SELECT COUNT(*) FROM [source table name]
> > WHERE ISNUMERIC(patient_weight) = 0
> >
> > --
> > Please post DDL, sample data and desired results.
> > See http://www.aspfaq.com/5006 for info.
> >
> >
> >
> >
> > "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> > news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> > > I'm writing a script with an insert statment to insert records from
one
> > > database to another but I have to change the type first. How can I
find
> > out
> > > more about what can be causing this or is it something wrong with my
> > syntax?
> > > The field [patient_weight] is a varchar(256) stripped of all spaces
left
> > and
> > > right.
> > > Thanks, Alpha
> > >
> > > cast([patient_weight] as decimal(10,2))
> > >
> >
> >
> >|||Thank you that works but I don't understadn what happend here. So these 4
rows has a '0'(zero) char in it with CR. So how does this query able to
select it? ISNUMERIC cast it to 0 (zero in numerica) right? I don't
understand.
Thanks,
Alpha
> SELECT * FROM Source_Table_Name
> WHERE ISNUMERIC(patient_weight) = 0
"Aaron [SQL Server MVP]" wrote:
> Well, you need to fix those 4 rows.
> SELECT * FROM Source_Table_Name
> WHERE ISNUMERIC(patient_weight) = 0
> If they look like 0's, maybe they're o's, or maybe they're zero's with
> non-printable characters attached (e.g. carriage return).
> UPDATE Source_Table_Name SET patient_weight = '0'
> WHERE ISNUMERIC(patient_weight) = 0
> --
> Please post DDL, sample data and desired results.
> See http://www.aspfaq.com/5006 for info.
>
>
> "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> news:5B264C8D-9F07-4A20-8066-93256AD0D975@.microsoft.com...
> > I got 4. I looked at the table and they're all '0'(zero) except these 4.
> >
> > "Aaron [SQL Server MVP]" wrote:
> >
> > > What result do you get here?
> > >
> > > SELECT COUNT(*) FROM [source table name]
> > > WHERE ISNUMERIC(patient_weight) = 0
> > >
> > > --
> > > Please post DDL, sample data and desired results.
> > > See http://www.aspfaq.com/5006 for info.
> > >
> > >
> > >
> > >
> > > "Alpha" <Alpha@.discussions.microsoft.com> wrote in message
> > > news:D0914609-50C8-4480-A15D-302752BECA86@.microsoft.com...
> > > > I'm writing a script with an insert statment to insert records from
> one
> > > > database to another but I have to change the type first. How can I
> find
> > > out
> > > > more about what can be causing this or is it something wrong with my
> > > syntax?
> > > > The field [patient_weight] is a varchar(256) stripped of all spaces
> left
> > > and
> > > > right.
> > > > Thanks, Alpha
> > > >
> > > > cast([patient_weight] as decimal(10,2))
> > > >
> > >
> > >
> > >
>
>|||> Thank you that works but I don't understadn what happend here. So these 4
> rows has a '0'(zero) char in it with CR. So how does this query able to
> select it? ISNUMERIC cast it to 0 (zero in numerica) right?
No, ISNUMERIC(expression) returns either 1 or 0. If the number is numeric*,
it returns 1, otherwise it returns 0. Something about the way you decided
to store numeric data in a character data type led to problems in these 4
rows (which could have been predicted at the outset, and prevented by
choosing the correct data type).
* ISNUMERIC() is not perfect. See http://www.aspfaq.com/2390|||Oh, got it. Thank you very much and have a nice day.
Alpha
"Aaron [SQL Server MVP]" wrote:
> > Thank you that works but I don't understadn what happend here. So these 4
> > rows has a '0'(zero) char in it with CR. So how does this query able to
> > select it? ISNUMERIC cast it to 0 (zero in numerica) right?
> No, ISNUMERIC(expression) returns either 1 or 0. If the number is numeric*,
> it returns 1, otherwise it returns 0. Something about the way you decided
> to store numeric data in a character data type led to problems in these 4
> rows (which could have been predicted at the outset, and prevented by
> choosing the correct data type).
> * ISNUMERIC() is not perfect. See http://www.aspfaq.com/2390
>
>

Wednesday, March 7, 2012

Error using rs.FireEvent

Hi all ,
I am using rs.fireevent () class for firing an event but I a getting an
error
My script code is
Sub Main
Dim rs As New ReportingService()
rs.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim subs As Subscription() = rs.ListSubscriptions("/Reports/Report1", Nothing)
try
rs.FireEvent("TimedSubscription", subs(0).SubscriptionID)
Catch ex As Exception
Console.WriteLine(ex.Message)
End Try
End Sub
Whenever I run this script using Rs.utility in command prompt Like
"rs -i NewSubscription.rss -s http://mercury/reportserver -e mgmt2000"
I get an error as
"The permissions granted to user 'sb\svaddadi' are insufficient for per
forming this operation."
Even though I have administrator privliges to server I am getting this
error.
Any suggestion will be apprecaible
SonuHi,
Sorry I didn;t see your earlier post and replied that you need to write the
code . Now that you tried writing code in this post. Gr8. Try giving -u and
-p values as well.
Amarnath
"Shrinivas" wrote:
> Hi all ,
> I am using rs.fireevent () class for firing an event but I a getting an
> error
> My script code is
> Sub Main
> Dim rs As New ReportingService()
> rs.Credentials = System.Net.CredentialCache.DefaultCredentials
> Dim subs As Subscription() => rs.ListSubscriptions("/Reports/Report1", Nothing)
> try
> rs.FireEvent("TimedSubscription", subs(0).SubscriptionID)
> Catch ex As Exception
> Console.WriteLine(ex.Message)
> End Try
> End Sub
> Whenever I run this script using Rs.utility in command prompt Like
> "rs -i NewSubscription.rss -s http://mercury/reportserver -e mgmt2000"
> I get an error as
> "The permissions granted to user 'sb\svaddadi' are insufficient for per
> forming this operation."
> Even though I have administrator privliges to server I am getting this
> error.
> Any suggestion will be apprecaible
> Sonu
>

Sunday, February 26, 2012

Error upgrading to Sql 2000 from Sql 7

Everything proceeds fine but when it is running the file
called messages.sql, there is an error.
Error running script : messages.sql(1)
The process then stops. Any ideas what this is ? All that
the script file messages.sql does is insert in
master..sysmessages. I increased the log size but that did
not help either.
Any help is appreciated. Thanks in advance.Jack,
See
FIX: Upgrade from SQL Server 7.0 May Abort with Messages.sql and You Cannot
Connect to SQL Server
http://www.support.microsoft.com/?id=300676
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Jack" <jacka8@.excite.com> wrote in message
news:054e01c3636f$d71d7ee0$a101280a@.phx.gbl...
> Everything proceeds fine but when it is running the file
> called messages.sql, there is an error.
> Error running script : messages.sql(1)
> The process then stops. Any ideas what this is ? All that
> the script file messages.sql does is insert in
> master..sysmessages. I increased the log size but that did
> not help either.
> Any help is appreciated. Thanks in advance.|||Thanks, Dinesh. That was a bulls eye.
Didnt Microsoft test an upgrade before releasing the CD ?
Anyways...
>--Original Message--
>Jack,
>See
>FIX: Upgrade from SQL Server 7.0 May Abort with
Messages.sql and You Cannot
>Connect to SQL Server
>http://www.support.microsoft.com/?id=300676
>--
>Dinesh.
>SQL Server FAQ at
>http://www.tkdinesh.com
>"Jack" <jacka8@.excite.com> wrote in message
>news:054e01c3636f$d71d7ee0$a101280a@.phx.gbl...
>> Everything proceeds fine but when it is running the file
>> called messages.sql, there is an error.
>> Error running script : messages.sql(1)
>> The process then stops. Any ideas what this is ? All
that
>> the script file messages.sql does is insert in
>> master..sysmessages. I increased the log size but that
did
>> not help either.
>> Any help is appreciated. Thanks in advance.
>
>.
>

Error Type 'System.Xml.XmlTextWriter' is not defined

I use this Code in SSIS Destination Script Transforamtion:
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper
Imports System.Xml

Public Class ScriptMain
Inherits UserComponent
Dim xWriter As XmlTextWriter
' get this Error: Type 'System.Xml.XmlTextWriter' is not defined

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
End Sub
End Class

Whats wrong Tongue Tied ?

I use CTP Sept 2005 on Windows XP German.

Willfried

You need to add a reference to System.Xml in your script component

Go to Project|Add Reference... and select System.xml from the assembly list|||Thanks, i'm a fool Idea |||Don't worry I just spent 30 minutes doing exactly the same thing

Friday, February 24, 2012

Error trying to design script (Script Component)

Hi everybody:
Maybe somebody around here can help me out with this one.
I applied SQL Server 2005 SP 2 to my local environment (win 2003 server) about two weeks ago week and last week I noticed an error when I tried to edit the script components of some previously created packages.
I am not 100% sure that SP 2 is the cause but that's the only thing that has changed recently.

Well, this is my error:
I click on the "design script" button of any package that was built before patching my sql server and I get an error message telling me that the "Visual Studio for Applications editor cannot be shown" and, of course, Visual Studio won't open.
I've tried creating new test packages with script components and they seem to work fine so this is only happening with older pacakges.

I'm appending below the error message that I get when I click on the technical details button of the error dialog box that I get.

I can see that the something is going on when generating/retriveing the GUID for the script. I tried cutting and pasting the component and that didn't work. If I delete the script component and create a new one, I am able to open VSA and I notice on the project explorer tab of VS that my old ScriptComponent project is there. So, the project explorer shows two projects: one with the default ScriptMain class and one with the previously worked ScriptMain that was never lost. When I close VSA, I get the error dialog box. If I try to design the script again, it won't open.

Well, I hope anybody here has a clue if this is a bug with SP 2 or if there is workaround without having to re-install either SQL server 2005 or VS .NET 2005 to see if the error is gone.

Thanks,
Alonso

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%u00ae+Visual+Studio%u00ae+2005&ProdVer=8.0.50727.42&EvtSrc=Microsoft.DataTransformationServices.DataFlowUI.SR&EvtID=CouldNotShowVsaIDE&LinkId=20476

===================================

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

Program Location:

at Microsoft.VisualBasic.Vsa.VsaEngine.LoadSourceState(IVsaPersistSite Site)
at Microsoft.SqlServer.VSAHosting.DesignTime.LoadEngineSource(String engineMoniker, String project)
at Microsoft.SqlServer.Dts.Pipeline.ScriptDesignTime.CreateDesignTimeEngine(String projectName, Boolean loadSource, ICodeGenerator codeGenerator)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ShowIDE()
at Microsoft.DataTransformationServices.DataFlowUI.ScriptUI.propPage_DesignScript(Object sender, EventArgs args)

===================================

A project with the name 'ScriptComponent_56e278ce61c7453580a57df39d4765bf' already exists.

Program Location:

at Microsoft.Vsa.IVsaEngine.LoadSourceState(IVsaPersistSite site)
at Microsoft.VisualBasic.Vsa.VsaEngine.LoadSourceState(IVsaPersistSite Site)

You're not the only one with un-editable script components (here is the thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1270413&SiteID=1) . Quite a few others are experiencing this issue (uneditable script component on SP2 for components created prior to SP2). Now, what's interesting, if I may term it that, is that your local environment is win2k3, whereas I've seen it on XP x86. Personally been in contact with Microsoft for over two weeks trying to get this resolved. If you want to call up PSS as well and send them sample packages, perhaps that would help add more data points to the investigation, and get this resolved.
|||Thanks for your reply. I'll try to open a ticket with PSS today.
I'll follow the activity in your thread and give an update if any progress has been made.
|||

Alonso Villanueva wrote:
Thanks for your reply. I'll try to open a ticket with PSS today.
I'll follow the activity in your thread and give an update if any progress has been made.

What operating system are you on?

There is already a hotfix for Vista, if that's your situation.|||This is my local environment configuration:

Visual Studio 2005 Professional Edition SP1
Windows Server 2003 Standard Edition SP1
SQL Server 2005 SP2
Microsoft .NET Framework v2.0.50727

Unfortunately it's not Vista :(

Like I said before. I'll try to have Microsoft PSS contacted today.

Thanks,
Alonso
|||After reading the http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1270413&SiteID=1 thread, I tried opening my Script Component from a Windows 2003 server and I was able to edit it there, but not from my XP workstation. Both have SQL Server SP2 installed.|||

Windows XP, MS SQL Server 2005 SP2. I got this one after clicking 'Design Script...' in Script Transformation. Script Task swallows an error and does nothing at all. Tried to apply all solutions mentioned on this forum, however nothing helped. Could MS Guys eventually fix this?

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Retrieving the COM class factory for component with CLSID {3089D50C-DDAC-4743-9FBF-C15743A32161} failed due to the following error: 800736b1. (Microsoft.VisualBasic.Vsa.DT)

Program Location:

at Microsoft.VisualBasic.Vsa.Dt.VsaEngine.CreateEngine()
at Microsoft.VisualBasic.Vsa.VsaEngine.CheckEngine()
at Microsoft.VisualBasic.Vsa.VsaEngine.set_RootMoniker(String value)
at Microsoft.SqlServer.VSAHosting.DTEngines.Create(String moniker, String language, IDTEngineEvents engineEventsHandler)
at Microsoft.SqlServer.Dts.Pipeline.ScriptDesignTime.CreateDesignTimeEngine(String projectName, Boolean loadSource, ICodeGenerator codeGenerator)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ShowIDE()
at Microsoft.DataTransformationServices.DataFlowUI.ScriptUI.propPage_DesignScript(Object sender, EventArgs args)

|||

Could this be the issue you are facing: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1855810&SiteID=1 ?

Have you installed any .NET update recently?

Thanks,

Bob

|||The solution described there is to install SP2. As I mentioned I already have SP2 installed.|||

I am sorry -- I missed that. I will ask around if anybody has an idea.

Thanks,

Bob

|||

Hi Alonso,

Can you take a look at the scripts in that offending package and make sure there are no 2 script components with that same name (ScriptComponent_56e278ce61c7453580a57df39d4765bf). You can open the .dtsx file in notepad or any other text viewer and search for that text. If that is the case you can either remove one of those script components and re-add it which will generate it with an unique name. Pre SP2 we had some problems with using copy/paste operation on script tasks or script components that will cause problems at run time by generating scripts with the same name for both the source and the destination of the copy/paste operation.

As an workaround you can try doing a copy/paste on the offending component and then remove the source component of the copy/paste operation on a machine with SQL Server SP2 installed. That should change it's name with an unique one but make sure to rebuild the new component by opening it in the designer and closing it.

Let me know if that worked for you.

Thanks,

Silviu Guea [MSFT], SQL Server Integration Services

|||

I'm having the exact same problem as Alonso. I have SQL Server 2005 SP2 installed (in part as an attempt to fix this problem) and I've searched the code to ensure that there are no script components with the same ID (there were no duplicates). I do have two packages in the same project, and I checked the other package to see if it used the same ID (it didn't).

Please Help!

|||

We are having similar issues with the "Design Script" button in a Script Task. We get an error when clicked and it leads to an "Interface not registered" error in the detail text.

So far we have followed a number of dead end fixes (registering DLLs, tracking registry/file activity with regmon and file mon, looking for duplicate entries in the GAC, etc...).

One of our developers is dead in the water until this is resolved.

Anyone else get further?

Halvo

|||

To add more details to my specific problem: the problem also occurs with packages that have been created with both pre SP2 and post SP2 SQL Server 2005. Steps to create the problem are:

1. Create a new package, and create a data flow task

2. Add a new flat file connection manager and flat file source

3. Add Transformation type Script Component

4. Make connection between flat file source and Script Component

5. Edit Script Component node; check a couple of fields to reference as read only fields in the script

6. Click Design Script button. I end up in "Module1", but select the actual ScriptComponent_xxxxxxx ScriptMain from the Project Explorer

7. Save, and exit. A popup appears that says "Cannot show Visual Studio for Applications editor. Additional Information: A project with the name 'ScriptComponent_xxxxxxx' already exists" (same GUID as seen in the project explorer in step 6 - but it already exists because it was created as a result of designing the script! It's not a duplicate)

8. Subsequent attempts to click the Design Script button will now fail with the message:

Cannot show Visual Studio for Applications editor. Additional Information: The operation could not be completed (Microsoft.VisualBasic.Vsa)

Program Location:

at Microsoft.VisualBasic.Vsa.VsaEngine.set_Name(String value)
at Microsoft.SqlServer.Dts.Pipeline.ScriptDesignTime.CreateDesignTimeEngine(String projectName, Boolean loadSource, ICodeGenerator codeGenerator)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.ShowIDE()
at Microsoft.DataTransformationServices.DataFlowUI.ScriptUI.propPage_DesignScript(Object sender, EventArgs args)

Incidently, you can create a new Script Task and access the VSA GUI as in step 6 above, but again you can only do this once before the same error occurs.

I really wanted to use the script component for my application but I'm running short on time for my project and will have to use an ugly workaround if I can't solve this soon.

Any help is much appreciated - I'm running out of ideas here!

Scottie

|||

Hi - I'm wondering if this problem has been resolved as I ran into it and have been unable to resolve.

I've tried everything posted on this board - more than once and am still getting the dreaded

error "Cannot Show Visual Studio for Applications Editor"

Running the following...

XP sp2

SQL 2005 Service Pack 2

Microsoft Visual Studio 2005 Team Edition for Software Developers - ENU Service Pack 1 (KB926601)

Thanks

Error trying to design script (Script Component)

I'm appending below the error message that I get when I click on the technical details button of the error dialog box that I get.

Well, I hope anybody here has a clue if this is a bug with SP 2 or if there is workaround without having to re-install either SQL server 2005 or VS .NET 2005 to see if the error is gone.

Thanks,
Alonso

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

Program Location:

===================================

A project with the name 'ScriptComponent_56e278ce61c7453580a57df39d4765bf' already exists.

Program Location:

at Microsoft.Vsa.IVsaEngine.LoadSourceState(IVsaPersistSite site)
at Microsoft.VisualBasic.Vsa.VsaEngine.LoadSourceState(IVsaPersistSite Site)

Alonso Villanueva wrote:
Thanks for your reply. I'll try to open a ticket with PSS today.
I'll follow the activity in your thread and give an update if any progress has been made.

What operating system are you on?

There is already a hotfix for Vista, if that's your situation.|||This is my local environment configuration:

Visual Studio 2005 Professional Edition SP1
Windows Server 2003 Standard Edition SP1
SQL Server 2005 SP2
Microsoft .NET Framework v2.0.50727

Unfortunately it's not Vista :(

Like I said before. I'll try to have Microsoft PSS contacted today.

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Retrieving the COM class factory for component with CLSID {3089D50C-DDAC-4743-9FBF-C15743A32161} failed due to the following error: 800736b1. (Microsoft.VisualBasic.Vsa.DT)

Program Location:

|||

Could this be the issue you are facing: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1855810&SiteID=1 ?

Have you installed any .NET update recently?

Thanks,

Bob

|||The solution described there is to install SP2. As I mentioned I already have SP2 installed.|||

I am sorry -- I missed that. I will ask around if anybody has an idea.

Thanks,

Bob

|||

Hi Alonso,

Let me know if that worked for you.

Thanks,

Silviu Guea [MSFT], SQL Server Integration Services

|||

Please Help!

|||

We are having similar issues with the "Design Script" button in a Script Task. We get an error when clicked and it leads to an "Interface not registered" error in the detail text.

So far we have followed a number of dead end fixes (registering DLLs, tracking registry/file activity with regmon and file mon, looking for duplicate entries in the GAC, etc...).

One of our developers is dead in the water until this is resolved.

Anyone else get further?

Halvo

|||

To add more details to my specific problem: the problem also occurs with packages that have been created with both pre SP2 and post SP2 SQL Server 2005. Steps to create the problem are:

1. Create a new package, and create a data flow task

2. Add a new flat file connection manager and flat file source

3. Add Transformation type Script Component

4. Make connection between flat file source and Script Component

5. Edit Script Component node; check a couple of fields to reference as read only fields in the script

6. Click Design Script button. I end up in "Module1", but select the actual ScriptComponent_xxxxxxx ScriptMain from the Project Explorer

8. Subsequent attempts to click the Design Script button will now fail with the message:

Cannot show Visual Studio for Applications editor. Additional Information: The operation could not be completed (Microsoft.VisualBasic.Vsa)

Program Location:

Incidently, you can create a new Script Task and access the VSA GUI as in step 6 above, but again you can only do this once before the same error occurs.

I really wanted to use the script component for my application but I'm running short on time for my project and will have to use an ugly workaround if I can't solve this soon.

Any help is much appreciated - I'm running out of ideas here!

Scottie

|||

Hi - I'm wondering if this problem has been resolved as I ran into it and have been unable to resolve.

I've tried everything posted on this board - more than once and am still getting the dreaded

error "Cannot Show Visual Studio for Applications Editor"

Running the following...

XP sp2

SQL 2005 Service Pack 2

Microsoft Visual Studio 2005 Team Edition for Software Developers - ENU Service Pack 1 (KB926601)

Thanks

Error trying to design script (Script Component)

I'm appending below the error message that I get when I click on the technical details button of the error dialog box that I get.

Well, I hope anybody here has a clue if this is a bug with SP 2 or if there is workaround without having to re-install either SQL server 2005 or VS .NET 2005 to see if the error is gone.

Thanks,
Alonso

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

Program Location:

===================================

A project with the name 'ScriptComponent_56e278ce61c7453580a57df39d4765bf' already exists.

Program Location:

at Microsoft.Vsa.IVsaEngine.LoadSourceState(IVsaPersistSite site)
at Microsoft.VisualBasic.Vsa.VsaEngine.LoadSourceState(IVsaPersistSite Site)

Alonso Villanueva wrote:
Thanks for your reply. I'll try to open a ticket with PSS today.
I'll follow the activity in your thread and give an update if any progress has been made.

What operating system are you on?

There is already a hotfix for Vista, if that's your situation.|||This is my local environment configuration:

Visual Studio 2005 Professional Edition SP1
Windows Server 2003 Standard Edition SP1
SQL Server 2005 SP2
Microsoft .NET Framework v2.0.50727

Unfortunately it's not Vista :(

Like I said before. I'll try to have Microsoft PSS contacted today.

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Retrieving the COM class factory for component with CLSID {3089D50C-DDAC-4743-9FBF-C15743A32161} failed due to the following error: 800736b1. (Microsoft.VisualBasic.Vsa.DT)

Program Location:

|||

Could this be the issue you are facing: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1855810&SiteID=1 ?

Have you installed any .NET update recently?

Thanks,

Bob

|||The solution described there is to install SP2. As I mentioned I already have SP2 installed.|||

I am sorry -- I missed that. I will ask around if anybody has an idea.

Thanks,

Bob

|||

Hi Alonso,

Let me know if that worked for you.

Thanks,

Silviu Guea [MSFT], SQL Server Integration Services

|||

Please Help!

|||

We are having similar issues with the "Design Script" button in a Script Task. We get an error when clicked and it leads to an "Interface not registered" error in the detail text.

So far we have followed a number of dead end fixes (registering DLLs, tracking registry/file activity with regmon and file mon, looking for duplicate entries in the GAC, etc...).

One of our developers is dead in the water until this is resolved.

Anyone else get further?

Halvo

|||

To add more details to my specific problem: the problem also occurs with packages that have been created with both pre SP2 and post SP2 SQL Server 2005. Steps to create the problem are:

1. Create a new package, and create a data flow task

2. Add a new flat file connection manager and flat file source

3. Add Transformation type Script Component

4. Make connection between flat file source and Script Component

5. Edit Script Component node; check a couple of fields to reference as read only fields in the script

6. Click Design Script button. I end up in "Module1", but select the actual ScriptComponent_xxxxxxx ScriptMain from the Project Explorer

8. Subsequent attempts to click the Design Script button will now fail with the message:

Cannot show Visual Studio for Applications editor. Additional Information: The operation could not be completed (Microsoft.VisualBasic.Vsa)

Program Location:

Incidently, you can create a new Script Task and access the VSA GUI as in step 6 above, but again you can only do this once before the same error occurs.

I really wanted to use the script component for my application but I'm running short on time for my project and will have to use an ugly workaround if I can't solve this soon.

Any help is much appreciated - I'm running out of ideas here!

Scottie

|||

Hi - I'm wondering if this problem has been resolved as I ran into it and have been unable to resolve.

I've tried everything posted on this board - more than once and am still getting the dreaded

error "Cannot Show Visual Studio for Applications Editor"

Running the following...

XP sp2

SQL 2005 Service Pack 2

Microsoft Visual Studio 2005 Team Edition for Software Developers - ENU Service Pack 1 (KB926601)

Thanks

Error trying to design script (Script Component)

I'm appending below the error message that I get when I click on the technical details button of the error dialog box that I get.

Well, I hope anybody here has a clue if this is a bug with SP 2 or if there is workaround without having to re-install either SQL server 2005 or VS .NET 2005 to see if the error is gone.

Thanks,
Alonso

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

Program Location:

===================================

A project with the name 'ScriptComponent_56e278ce61c7453580a57df39d4765bf' already exists.

Program Location:

at Microsoft.Vsa.IVsaEngine.LoadSourceState(IVsaPersistSite site)
at Microsoft.VisualBasic.Vsa.VsaEngine.LoadSourceState(IVsaPersistSite Site)

Alonso Villanueva wrote:
Thanks for your reply. I'll try to open a ticket with PSS today.
I'll follow the activity in your thread and give an update if any progress has been made.

What operating system are you on?

There is already a hotfix for Vista, if that's your situation.|||This is my local environment configuration:

Visual Studio 2005 Professional Edition SP1
Windows Server 2003 Standard Edition SP1
SQL Server 2005 SP2
Microsoft .NET Framework v2.0.50727

Unfortunately it's not Vista :(

Like I said before. I'll try to have Microsoft PSS contacted today.

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Retrieving the COM class factory for component with CLSID {3089D50C-DDAC-4743-9FBF-C15743A32161} failed due to the following error: 800736b1. (Microsoft.VisualBasic.Vsa.DT)

Program Location:

|||

Could this be the issue you are facing: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1855810&SiteID=1 ?

Have you installed any .NET update recently?

Thanks,

Bob

|||The solution described there is to install SP2. As I mentioned I already have SP2 installed.|||

I am sorry -- I missed that. I will ask around if anybody has an idea.

Thanks,

Bob

|||

Hi Alonso,

Let me know if that worked for you.

Thanks,

Silviu Guea [MSFT], SQL Server Integration Services

|||

Please Help!

|||

We are having similar issues with the "Design Script" button in a Script Task. We get an error when clicked and it leads to an "Interface not registered" error in the detail text.

So far we have followed a number of dead end fixes (registering DLLs, tracking registry/file activity with regmon and file mon, looking for duplicate entries in the GAC, etc...).

One of our developers is dead in the water until this is resolved.

Anyone else get further?

Halvo

|||

To add more details to my specific problem: the problem also occurs with packages that have been created with both pre SP2 and post SP2 SQL Server 2005. Steps to create the problem are:

1. Create a new package, and create a data flow task

2. Add a new flat file connection manager and flat file source

3. Add Transformation type Script Component

4. Make connection between flat file source and Script Component

5. Edit Script Component node; check a couple of fields to reference as read only fields in the script

6. Click Design Script button. I end up in "Module1", but select the actual ScriptComponent_xxxxxxx ScriptMain from the Project Explorer

8. Subsequent attempts to click the Design Script button will now fail with the message:

Cannot show Visual Studio for Applications editor. Additional Information: The operation could not be completed (Microsoft.VisualBasic.Vsa)

Program Location:

Incidently, you can create a new Script Task and access the VSA GUI as in step 6 above, but again you can only do this once before the same error occurs.

I really wanted to use the script component for my application but I'm running short on time for my project and will have to use an ugly workaround if I can't solve this soon.

Any help is much appreciated - I'm running out of ideas here!

Scottie

|||

Hi - I'm wondering if this problem has been resolved as I ran into it and have been unable to resolve.

I've tried everything posted on this board - more than once and am still getting the dreaded

error "Cannot Show Visual Studio for Applications Editor"

Running the following...

XP sp2

SQL 2005 Service Pack 2

Microsoft Visual Studio 2005 Team Edition for Software Developers - ENU Service Pack 1 (KB926601)

Thanks

Error trying to design script (Script Component)

I'm appending below the error message that I get when I click on the technical details button of the error dialog box that I get.

Well, I hope anybody here has a clue if this is a bug with SP 2 or if there is workaround without having to re-install either SQL server 2005 or VS .NET 2005 to see if the error is gone.

Thanks,
Alonso

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

Program Location:

===================================

A project with the name 'ScriptComponent_56e278ce61c7453580a57df39d4765bf' already exists.

Program Location:

at Microsoft.Vsa.IVsaEngine.LoadSourceState(IVsaPersistSite site)
at Microsoft.VisualBasic.Vsa.VsaEngine.LoadSourceState(IVsaPersistSite Site)

Alonso Villanueva wrote:
Thanks for your reply. I'll try to open a ticket with PSS today.
I'll follow the activity in your thread and give an update if any progress has been made.

What operating system are you on?

There is already a hotfix for Vista, if that's your situation.|||This is my local environment configuration:

Visual Studio 2005 Professional Edition SP1
Windows Server 2003 Standard Edition SP1
SQL Server 2005 SP2
Microsoft .NET Framework v2.0.50727

Unfortunately it's not Vista :(

Like I said before. I'll try to have Microsoft PSS contacted today.

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Retrieving the COM class factory for component with CLSID {3089D50C-DDAC-4743-9FBF-C15743A32161} failed due to the following error: 800736b1. (Microsoft.VisualBasic.Vsa.DT)

Program Location:

|||

Could this be the issue you are facing: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1855810&SiteID=1 ?

Have you installed any .NET update recently?

Thanks,

Bob

|||The solution described there is to install SP2. As I mentioned I already have SP2 installed.|||

I am sorry -- I missed that. I will ask around if anybody has an idea.

Thanks,

Bob

|||

Hi Alonso,

Let me know if that worked for you.

Thanks,

Silviu Guea [MSFT], SQL Server Integration Services

|||

Please Help!

|||

We are having similar issues with the "Design Script" button in a Script Task. We get an error when clicked and it leads to an "Interface not registered" error in the detail text.

So far we have followed a number of dead end fixes (registering DLLs, tracking registry/file activity with regmon and file mon, looking for duplicate entries in the GAC, etc...).

One of our developers is dead in the water until this is resolved.

Anyone else get further?

Halvo

|||

To add more details to my specific problem: the problem also occurs with packages that have been created with both pre SP2 and post SP2 SQL Server 2005. Steps to create the problem are:

1. Create a new package, and create a data flow task

2. Add a new flat file connection manager and flat file source

3. Add Transformation type Script Component

4. Make connection between flat file source and Script Component

5. Edit Script Component node; check a couple of fields to reference as read only fields in the script

6. Click Design Script button. I end up in "Module1", but select the actual ScriptComponent_xxxxxxx ScriptMain from the Project Explorer

8. Subsequent attempts to click the Design Script button will now fail with the message:

Cannot show Visual Studio for Applications editor. Additional Information: The operation could not be completed (Microsoft.VisualBasic.Vsa)

Program Location:

Incidently, you can create a new Script Task and access the VSA GUI as in step 6 above, but again you can only do this once before the same error occurs.

I really wanted to use the script component for my application but I'm running short on time for my project and will have to use an ugly workaround if I can't solve this soon.

Any help is much appreciated - I'm running out of ideas here!

Scottie

|||

Hi - I'm wondering if this problem has been resolved as I ran into it and have been unable to resolve.

I've tried everything posted on this board - more than once and am still getting the dreaded

error "Cannot Show Visual Studio for Applications Editor"

Running the following...

XP sp2

SQL 2005 Service Pack 2

Microsoft Visual Studio 2005 Team Edition for Software Developers - ENU Service Pack 1 (KB926601)

Thanks

Error trying to design script (Script Component)

I'm appending below the error message that I get when I click on the technical details button of the error dialog box that I get.

Well, I hope anybody here has a clue if this is a bug with SP 2 or if there is workaround without having to re-install either SQL server 2005 or VS .NET 2005 to see if the error is gone.

Thanks,
Alonso

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Engine returned Unknown Error (Microsoft.VisualBasic.Vsa)

Program Location:

===================================

A project with the name 'ScriptComponent_56e278ce61c7453580a57df39d4765bf' already exists.

Program Location:

at Microsoft.Vsa.IVsaEngine.LoadSourceState(IVsaPersistSite site)
at Microsoft.VisualBasic.Vsa.VsaEngine.LoadSourceState(IVsaPersistSite Site)

Alonso Villanueva wrote:
Thanks for your reply. I'll try to open a ticket with PSS today.
I'll follow the activity in your thread and give an update if any progress has been made.

What operating system are you on?

There is already a hotfix for Vista, if that's your situation.|||This is my local environment configuration:

Visual Studio 2005 Professional Edition SP1
Windows Server 2003 Standard Edition SP1
SQL Server 2005 SP2
Microsoft .NET Framework v2.0.50727

Unfortunately it's not Vista :(

Like I said before. I'll try to have Microsoft PSS contacted today.

===================================

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

===================================

Retrieving the COM class factory for component with CLSID {3089D50C-DDAC-4743-9FBF-C15743A32161} failed due to the following error: 800736b1. (Microsoft.VisualBasic.Vsa.DT)

Program Location:

|||

Could this be the issue you are facing: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1855810&SiteID=1 ?

Have you installed any .NET update recently?

Thanks,

Bob

|||The solution described there is to install SP2. As I mentioned I already have SP2 installed.|||

I am sorry -- I missed that. I will ask around if anybody has an idea.

Thanks,

Bob

|||

Hi Alonso,

Let me know if that worked for you.

Thanks,

Silviu Guea [MSFT], SQL Server Integration Services

|||

Please Help!

|||

We are having similar issues with the "Design Script" button in a Script Task. We get an error when clicked and it leads to an "Interface not registered" error in the detail text.

So far we have followed a number of dead end fixes (registering DLLs, tracking registry/file activity with regmon and file mon, looking for duplicate entries in the GAC, etc...).

One of our developers is dead in the water until this is resolved.

Anyone else get further?

Halvo

|||

To add more details to my specific problem: the problem also occurs with packages that have been created with both pre SP2 and post SP2 SQL Server 2005. Steps to create the problem are:

1. Create a new package, and create a data flow task

2. Add a new flat file connection manager and flat file source

3. Add Transformation type Script Component

4. Make connection between flat file source and Script Component

5. Edit Script Component node; check a couple of fields to reference as read only fields in the script

6. Click Design Script button. I end up in "Module1", but select the actual ScriptComponent_xxxxxxx ScriptMain from the Project Explorer

8. Subsequent attempts to click the Design Script button will now fail with the message:

Cannot show Visual Studio for Applications editor. Additional Information: The operation could not be completed (Microsoft.VisualBasic.Vsa)

Program Location:

Incidently, you can create a new Script Task and access the VSA GUI as in step 6 above, but again you can only do this once before the same error occurs.

I really wanted to use the script component for my application but I'm running short on time for my project and will have to use an ugly workaround if I can't solve this soon.

Any help is much appreciated - I'm running out of ideas here!

Scottie

|||

Hi - I'm wondering if this problem has been resolved as I ran into it and have been unable to resolve.

I've tried everything posted on this board - more than once and am still getting the dreaded

error "Cannot Show Visual Studio for Applications Editor"

Running the following...

XP sp2

SQL 2005 Service Pack 2

Microsoft Visual Studio 2005 Team Edition for Software Developers - ENU Service Pack 1 (KB926601)

Thanks

Monday, March 26, 2012

Error when refreshing Taskpad view

Thursday, March 22, 2012

ERROR WHEN I TRY TO EDIT A SCRIPT TASK

Wednesday, March 21, 2012

error when I run script

Monday, March 19, 2012

Error when creating script to copy Stored Procedures

Monday, March 12, 2012

Error when cast Varchar to decimal

Error when cast Varchar to decimal

Error when cast Varchar to decimal

Wednesday, March 7, 2012

Error using rs.FireEvent

Sunday, February 26, 2012

Error upgrading to Sql 2000 from Sql 7

Error Type 'System.Xml.XmlTextWriter' is not defined

Friday, February 24, 2012

Error trying to design script (Script Component)

Error trying to design script (Script Component)

Error trying to design script (Script Component)

Error trying to design script (Script Component)

Error trying to design script (Script Component)

Error trying to design script (Script Component)

Error running report

Blog Archive

About Me