Frustrating Visual Studio crashes when adding Script step

I have two similar packages that are both experiencing this issue.

I need to add a script step to generate an incrementing id for the packages.

Once I add the script step, and then save the package, next time I open the package I get a "Microsoft Visual Studio has encountered a problem and needs to close" error which kills off Visual Studio.

The error signature is:

EventType: clr20r3

P1: devenv.exe

P2: 8.0.50727.762

P3: 45716759

P4: microsoft.sqlserver.txscript

P5: 9.0.242.0

P6: 443f5ab8

P7: 67

P8: d

P9: bbp0yyyc15o2dbouwcacz2m0bodqkotn

If I move the error window to one side, delete the whole Script step, and save the Package, then I can reopen the package again without the error occurring.

Here is the actual code in my script step (in case its of any assistance...)

(I have retyped it from a printout, so it may not be 100%. DOCID is supposed to increment from 1. DREF1 is a system-unique id, that takes up from where the last batch left off, and is a string prefixed by "MP")

Code Snippet

Imports System

Imports System.Data

Imports System.math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dta.Runtime.Wrapper

Public Class ScriptMain

Inherits UserComponent

Dim ndx as Int32 = 0

Public Overrides Sub Input0_ProcessInputRow(Byval Row as Input0Buffer)

'

' Add your code here

'

Dim dref as String

ndx = ndx + 1

Row.DOCID = ndx

dref = "MP" + Ctype(ndx + Variables.MPIDOrig, String)

Row.DREF1 = dref

End Sub

Protected Overrides Sub finalize()

Variables.MPID = ndx + Variables.MPIDOrig

MyBase.Finalize()

End Sub

End Class

I have found that when I take out the finalize() function, Visual Studio no longer crashes.

Can anyone suggest a different way to achieve what I am trying to achieve?

|||

Could you to put it into PostExecute()?

Thanks,

Bob

|||

Thanks, yes this was the answer.

It was a bit frustrating, as a relative newbie to SSIS, to find that the Finalize method caused this sort of behaviour, and it wasn't immediately obvious that PostExecute should be used instead.

(By which I mean I actually had to read deeper than jsut fiddling about in the IDE.)

Frustrating Visual Studio crashes when adding Script step

I have two similar packages that are both experiencing this issue.

I need to add a script step to generate an incrementing id for the packages.

Once I add the script step, and then save the package, next time I open the package I get a "Microsoft Visual Studio has encountered a problem and needs to close" error which kills off Visual Studio.

The error signature is:

EventType: clr20r3

P1: devenv.exe

P2: 8.0.50727.762

P3: 45716759

P4: microsoft.sqlserver.txscript

P5: 9.0.242.0

P6: 443f5ab8

P7: 67

P8: d

P9: bbp0yyyc15o2dbouwcacz2m0bodqkotn

If I move the error window to one side, delete the whole Script step, and save the Package, then I can reopen the package again without the error occurring.

Here is the actual code in my script step (in case its of any assistance...)

(I have retyped it from a printout, so it may not be 100%. DOCID is supposed to increment from 1. DREF1 is a system-unique id, that takes up from where the last batch left off, and is a string prefixed by "MP")

Code Snippet

Imports System

Imports System.Data

Imports System.math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dta.Runtime.Wrapper

Public Class ScriptMain

Inherits UserComponent

Dim ndx as Int32 = 0

Public Overrides Sub Input0_ProcessInputRow(Byval Row as Input0Buffer)

'

' Add your code here

'

Dim dref as String

ndx = ndx + 1

Row.DOCID = ndx

dref = "MP" + Ctype(ndx + Variables.MPIDOrig, String)

Row.DREF1 = dref

End Sub

Protected Overrides Sub finalize()

Variables.MPID = ndx + Variables.MPIDOrig

MyBase.Finalize()

End Sub

End Class

I have found that when I take out the finalize() function, Visual Studio no longer crashes.

Can anyone suggest a different way to achieve what I am trying to achieve?

|||

Could you to put it into PostExecute()?

Thanks,

Bob

|||

Thanks, yes this was the answer.

It was a bit frustrating, as a relative newbie to SSIS, to find that the Finalize method caused this sort of behaviour, and it wasn't immediately obvious that PostExecute should be used instead.

(By which I mean I actually had to read deeper than jsut fiddling about in the IDE.)

sql

Frustrating Visual Studio crashes when adding Script step

I have two similar packages that are both experiencing this issue.

I need to add a script step to generate an incrementing id for the packages.

Once I add the script step, and then save the package, next time I open the package I get a "Microsoft Visual Studio has encountered a problem and needs to close" error which kills off Visual Studio.

The error signature is:

EventType: clr20r3

P1: devenv.exe

P2: 8.0.50727.762

P3: 45716759

P4: microsoft.sqlserver.txscript

P5: 9.0.242.0

P6: 443f5ab8

P7: 67

P8: d

P9: bbp0yyyc15o2dbouwcacz2m0bodqkotn

If I move the error window to one side, delete the whole Script step, and save the Package, then I can reopen the package again without the error occurring.

Here is the actual code in my script step (in case its of any assistance...)

(I have retyped it from a printout, so it may not be 100%. DOCID is supposed to increment from 1. DREF1 is a system-unique id, that takes up from where the last batch left off, and is a string prefixed by "MP")

Code Snippet

Imports System

Imports System.Data

Imports System.math

Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper

Imports Microsoft.SqlServer.Dta.Runtime.Wrapper

Public Class ScriptMain

Inherits UserComponent

Dim ndx as Int32 = 0

Public Overrides Sub Input0_ProcessInputRow(Byval Row as Input0Buffer)

'

' Add your code here

'

Dim dref as String

ndx = ndx + 1

Row.DOCID = ndx

dref = "MP" + Ctype(ndx + Variables.MPIDOrig, String)

Row.DREF1 = dref

End Sub

Protected Overrides Sub finalize()

Variables.MPID = ndx + Variables.MPIDOrig

MyBase.Finalize()

End Sub

End Class

I have found that when I take out the finalize() function, Visual Studio no longer crashes.

Can anyone suggest a different way to achieve what I am trying to achieve?

|||

Could you to put it into PostExecute()?

Thanks,

Bob

|||

Thanks, yes this was the answer.

It was a bit frustrating, as a relative newbie to SSIS, to find that the Finalize method caused this sort of behaviour, and it wasn't immediately obvious that PostExecute should be used instead.

(By which I mean I actually had to read deeper than jsut fiddling about in the IDE.)

Freezed column headers in RS Webreports

Hi,
a lot of my users were asking me to have the possibilty of a freeze
pane (similar to excel) in the RS web reports because often the reports
are to long to see the column haeders. Especially when you have
drilldowns it would help.
Has somebody tried to implement such feature by DLL to RS 2000. Is this
feature planned for RS 2005 '
thanks
BBIf I remember correctly, that might be in SQL 2005
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"BB_Reporting" <Bruce.Baessler@.web.de> wrote in message
news:1123855073.170843.218720@.o13g2000cwo.googlegroups.com...
> Hi,
>
> a lot of my users were asking me to have the possibilty of a freeze
> pane (similar to excel) in the RS web reports because often the reports
> are to long to see the column haeders. Especially when you have
> drilldowns it would help.
>
> Has somebody tried to implement such feature by DLL to RS 2000. Is this
> feature planned for RS 2005 '
>
> thanks
>
> BB
>|||I am sorry for not answering your question directly... I also have not seen
any 3rd party prods which currently do that in sql 2000 either
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"BB_Reporting" <Bruce.Baessler@.web.de> wrote in message
news:1123855073.170843.218720@.o13g2000cwo.googlegroups.com...
> Hi,
>
> a lot of my users were asking me to have the possibilty of a freeze
> pane (similar to excel) in the RS web reports because often the reports
> are to long to see the column haeders. Especially when you have
> drilldowns it would help.
>
> Has somebody tried to implement such feature by DLL to RS 2000. Is this
> feature planned for RS 2005 '
>
> thanks
>
> BB
>|||This is available in RS 2005.
I don't know of anyone who has implemented this for RS 2000 - but in that
case, you would need to implement a full custom rendering extension yourself
for RS 2000 (which is a major effort and lots of work).
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"BB_Reporting" <Bruce.Baessler@.web.de> wrote in message
news:1123855073.170843.218720@.o13g2000cwo.googlegroups.com...
> Hi,
>
> a lot of my users were asking me to have the possibilty of a freeze
> pane (similar to excel) in the RS web reports because often the reports
> are to long to see the column haeders. Especially when you have
> drilldowns it would help.
>
> Has somebody tried to implement such feature by DLL to RS 2000. Is this
> feature planned for RS 2005 '
>
> thanks
>
> BB
>|||Hi Robert,
I haven't had a chance to test this yet so, with fixed headers in 2005 will
the scroll position stay in place for auto-refreshing reports or will it be
a pain an spring back to the top?
Thanks in advance,
James Snape
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:O8oAI$goFHA.904@.TK2MSFTNGP10.phx.gbl...
> This is available in RS 2005.
> I don't know of anyone who has implemented this for RS 2000 - but in that
> case, you would need to implement a full custom rendering extension
> yourself for RS 2000 (which is a major effort and lots of work).
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "BB_Reporting" <Bruce.Baessler@.web.de> wrote in message
> news:1123855073.170843.218720@.o13g2000cwo.googlegroups.com...
>> Hi,
>>
>> a lot of my users were asking me to have the possibilty of a freeze
>> pane (similar to excel) in the RS web reports because often the reports
>> are to long to see the column haeders. Especially when you have
>> drilldowns it would help.
>>
>> Has somebody tried to implement such feature by DLL to RS 2000. Is this
>> feature planned for RS 2005 '
>>
>> thanks
>>
>> BB
>|||Auto-Refresh will remember the current page number, but it will not remember
the scroll position within the page.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"James Snape" <jim_snape.at.hotmail.com@.online.nospam> wrote in message
news:ubgRWP3oFHA.3988@.TK2MSFTNGP10.phx.gbl...
> Hi Robert,
> I haven't had a chance to test this yet so, with fixed headers in 2005
> will the scroll position stay in place for auto-refreshing reports or will
> it be a pain an spring back to the top?
> Thanks in advance,
> James Snape
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:O8oAI$goFHA.904@.TK2MSFTNGP10.phx.gbl...
>> This is available in RS 2005.
>> I don't know of anyone who has implemented this for RS 2000 - but in that
>> case, you would need to implement a full custom rendering extension
>> yourself for RS 2000 (which is a major effort and lots of work).
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "BB_Reporting" <Bruce.Baessler@.web.de> wrote in message
>> news:1123855073.170843.218720@.o13g2000cwo.googlegroups.com...
>> Hi,
>>
>> a lot of my users were asking me to have the possibilty of a freeze
>> pane (similar to excel) in the RS web reports because often the reports
>> are to long to see the column haeders. Especially when you have
>> drilldowns it would help.
>>
>> Has somebody tried to implement such feature by DLL to RS 2000. Is this
>> feature planned for RS 2005 '
>>
>> thanks
>>
>> BB
>>
>

Freeze pane in RS 2000 SP2 / RS2005 web reports

Hi,
a lot of my users were asking me to have the possibilty of a freeze
pane (similar to excel) in the RS web reports because often the reports
are to long to see the column haeders. Especially when you have
drilldowns it would help.
Has somebody tried to implement such feature by DLL to RS 2000. Is this
feature planned for RS 2005 '
thanks
BBThe only way (that I know of) to accomplish what you're asking for is to have
a custom application that modifies the output file after it has been saved
and then forwards it to the person who initially requested it. We have one
non-RS custom application that does this (internal use only) and are working
on a way to do this with RS rendered reports.
Basically what your application has to do:
1- Client requests report
2- Application renders report in excel and saves to disk.
3- Appliation modifies the excel file properties (page margins, fit to
page, freeze panes, etc.)
4- Appliation passes modified file to the Client
It's a lot of work.
"BB_Reporting" wrote:
> Hi,
> a lot of my users were asking me to have the possibilty of a freeze
> pane (similar to excel) in the RS web reports because often the reports
> are to long to see the column haeders. Especially when you have
> drilldowns it would help.
> Has somebody tried to implement such feature by DLL to RS 2000. Is this
> feature planned for RS 2005 '
> thanks
> BB
>

freeze display in Perfmon ?

Is the freeze display in Perfmon similar to pausing or stopping and starting
again. Are there any performance issues to freezing the display or should i
close the perfmon if i dont need to.
I have some counters that i would like to store and be able to run perfmon
any time with these set of counters rather than adding them every time i
open perfmon How can i do so ?Hassan
Use this link to see lots of tips for using perfmon
including how to store settings.
http://www.sql-server-
performance.com/performance_monitor_tips.asp
Hope this helps
John