Hello,

I would like to ask how to add class
Microsoft.Sqlserver.dts.pipeline.wrapper in script task..

Thank you, Reda

Reda,

The class is automatically added when you create a Script Component.
Otherwise you can add reference of the assembly
Microsoft.SqlServer.DTSPipelineWrap to your project. The assembly is located
in the Microsoft SQL Server\90\SDK\Assemblies folder.

What exactly are you trying to do?

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email: charles at kangai.demon.co.uk

"reda246 (AT) gmail (DOT) com" wrote:

Hello,

Thanks for reply, I am trying to get information of custom properties
(data flow components, i.e SQL Destination: bulkinserttablename). I
would like programmically to change this property.

I can't add reference of Microsoft.SqlServer.DTSPipelineWrap to my
Integration Services project. There is no such as "Add References" in
this type of Projects. Do you know how to make it do?

Thanks alot.
Reda

Hi Reda,

I suspect there is a simpler way of doing what you are trying to do. Anyway,
if you want to run scripts in an SSIS project, you add a Script Task. Within
the script editor window, there is a Project, Add Reference menu command. Or
you could add this reference from an external .NET language project.

Charles Kangai, MCT, MCDBA
Author of Learning Tree's 4-day course: "SQL Server 2005 Integration
Services" http://www.learningtree.com/courses/134.htm
Author of Learning Tree's 4-day course: "SQL Server Reporting Services"
http://www.learningtree.com/courses/523.htm
email: charles at kangai.demon.co.uk



"reda246 (AT) gmail (DOT) com" wrote:

Thank you very much. I found the problem: It was "Script Task" not
"Script Task Component", so Script Task doesn't have
Microsoft.SqlSever.DTS.Pipeline class, but when I added to Data Flow
Script Task Component everything worked fine.
Reda
Charles Kangai raše: