dbTalk Databases Forums  

Using variables in custom SSIS transformation

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Using variables in custom SSIS transformation in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Thomas Mutter
 
Posts: n/a

Default Using variables in custom SSIS transformation - 09-03-2006 , 07:22 AM






Hi all

I'm trying to implement a custom transformation component for SSIS to
support some special requirements. In the UI I'd like to use some package
variables. Using IDtsVariableService.PromptAndCreateVariable the designer
allows to create a new variable for the package.
Is there a possibility to list the existing variables in the package?
Neither the variable service nor the VariableDispenser of the component
gives me a list with the available variables.

Has anyone ever worked with these objects? I am glad for any hints.

Yours, Thomy

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.