回复: 上传好书(SQL.Server.2005.Integration.Services.Step.by.Step)
How Can I Debug the Script Component?Unfortunately, breakpoints are not supported in the Script component. However, it is still possible to write the state out of the component to understand what is happening inside the Script component. First, create a new Output in the Script component to write intermediate data or invalid data out of the component. Connect the Output to an arbitrary destination component, such as Flat File. You can set a data viewer between these two components to review the data while you're executing the package. Another option is to use the
Me.Log method to write out to Microsoft Windows Event Log, to SQL Server, or to a text file. You can also use event methods (for instance,
FireInformation) defined under
Me.ComponentMetadata to write a message to the Progress tab. Refer to Chapter 6, "Scripting Tasks," for details.
就看到这段对话了.
