receiving the error
"An unhandled exception of type 'System.ExecutionEngineException' occurred
in SQLHelper.exe"

at the end of the following lines in VB.NET (VS2003/1.1):
Dim oTask As DTS.Task
Dim oLookup As DTS.Lookup

Dim oCustomTask3 As DTSCustTasks.DynamicPropertiesTask
oTask = goPackage.Tasks.New("DTSDynamicPropertiesTask")
oTask.Name = "DTSTask_DTSDynamicPropertiesTask_1"
oCustomTask3 = oTask.CustomTask

oCustomTask3.Name = "DTSTask_DTSDynamicPropertiesTask_1"
oCustomTask3.Description = "Dynamic Properties"

Dim oAssignment As DTSCustTasks.DynamicPropertiesTaskAssignment
'------- An Assignment is defined here

oAssignment = oCustomTask3.Assignments.New 'Error occurs HERE

how else would I create an assignment?

any help would be greatly appreciated!

btw,
the prev mentioned code was taken from the VB6 code generated by the SaveAs
in sql server 2000 and adapted to VB.NET. This code works fine in VB6 on the
same machine. Is this another example of LESS functionality in .NET than its
older brother?,

Dim oTask As DTS.Task
Dim oLookup As DTS.Lookup

Dim oCustomTask3 As DTSCustTasks.DynamicPropertiesTask
Set oTask = goPackage.Tasks.New("DTSDynamicPropertiesTask")
oTask.Name = "DTSTask_DTSDynamicPropertiesTask_1"
Set oCustomTask3 = oTask.CustomTask

oCustomTask3.Name = "DTSTask_DTSDynamicPropertiesTask_1"
oCustomTask3.Description = "Dynamic Properties"

Dim oAssignment As DTSCustTasks.DynamicPropertiesTaskAssignment
'------- An Assignment is defined here

Set oAssignment = oCustomTask3.Assignments.New


"dwaine" wrote:

Just to let you know i am looking into this and can repro in C#, VB.Net.


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know

Just curious, Allan, if you had any luck in your research? Also, curious why
no MS rep has joined the discussion. I thought they'd be interested.

I find it unfortunate that an RCW completely fails, where a vb6 component
has no problems. This has put a damper on a .NET project I've been working
on to manage DTS packages in bulk. For now I'm using a simple VB6 dll to
subsidise .NET functionality, but the original idea was a completely managed
assembly.

"Allan Mitchell" wrote:

OK So I know why this doesn't work now.

Don't thank me though thank Gert Drapers for finding the
error for me.

http://support.microsoft.com/default.aspx?scid=kb;en-
us;839884

Thanks Gert once again.

Thanks for the info, don't know how I missed this one.

"Allan Mitchell" wrote: