dbTalk Databases Forums  

SSIS. Dynamically populate collection in Transfer SQL Sevrer Objects Task

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


Discuss SSIS. Dynamically populate collection in Transfer SQL Sevrer Objects Task in the microsoft.public.sqlserver.dts forum.



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

Default SSIS. Dynamically populate collection in Transfer SQL Sevrer Objects Task - 12-08-2006 , 04:16 PM






Hello everyone,
I can't seem to be able to add a reference to
Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObj ectsTask Namespace in
Sript Task because it just doesn't show up in the available components
list.
Any ideas?

Thank you,
Igor



*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: SSIS. Dynamically populate collection in Transfer SQL Sevrer Objects Task - 12-08-2006 , 06:13 PM






Hello mEmENT0m0RI,

Why do you need to?

Your subject suggests dynamically populating a collection in an existing
task. Remember iin SSIS you cannot see outside of your own TaskHost so you
cannot start manipulating properties directly of other tasks in the same
package.

Have a read here though

http://sqljunkies.com/WebLog/knight_.../31/17731.aspx


Regards

Allan Mitchell
Konesans Ltd
T +44 7966 476 572
F +44 2071 008 479
http://www.konesans.com

Quote:
Hello everyone,
I can't seem to be able to add a reference to
Microsoft.SqlServer.Dts.Tasks.TransferSqlServerObj ectsTask Namespace
in
Sript Task because it just doesn't show up in the available components
list.
Any ideas?
Thank you,
Igor
*** Sent via Developersdex http://www.developersdex.com ***




Reply With Quote
  #3  
Old   
mEmENT0m0RI
 
Posts: n/a

Default Re: SSIS. Dynamically populate collection in Transfer SQL Sevrer Objects Task - 12-11-2006 , 11:00 AM



Allan,
Thank you very much. Right on the money!


*** Sent via Developersdex http://www.developersdex.com ***

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.