I am loading a DTS from a local file, setting the DTS parameters, and
the executing the DTS.

When I call Execute on the package it gives me "Type mismatch" for
DTSStep_DTSDynamicPropertiesTask_1

If I run the package manually from Enterprise Manager, then it
completes succesffully.

If I remove that task from the package, then the package runs fine when
calling Execute.

I have two string Globalvariable that are assigned(by the dynamic
properties task) to the Catalog and DataSource of an OLEDB SQL Server
connection.

Not sure what's going wrong.

I have also Loaded from the server, and the problem still occurs. I
recreated a new DTs package and added only a connection, a string
globalvariable, and a dynamicproperties task. The package runs fine
unless I add a variable assignment to the dynamicproperties task that
assigns to either DataSource or Catalog of the connection(I haven't
tried other types of assignments). In either case the error still
occurs.

shumaker (AT) cs (DOT) fsu.edu wrote:

BTW, I'm using C# with 2005 Express IDE. Any help would be really
appreciated. I'm banging my head against a wall on this one.

shuma... (AT) cs (DOT) fsu.edu wrote:

Fixed it, changed
packageVar.Value = databaseName;

to the corect way:

packageVar.let_Value(databaseName);

Hours of reading through unresolved posts on the same issue and trying
everything I could think of, and then 5 minutes after I post for help I
solve the problem.

Assigning in this way:
packageVar.Value = databaseName;
Causes the problem, even though the error doesn't show up until
Execute().


shuma... (AT) cs (DOT) fsu.edu wrote: