Type Mismatch when Excuting Dynamicproperties

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@cs.fsu.edu wrote:
> 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@cs.fsu.edu wrote:
> 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@cs.fsu.edu wrote:
> 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@cs.fsu.edu wrote:
> 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@cs.fsu.edu wrote:
> 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.

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...@cs.fsu.edu wrote:
> 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@cs.fsu.edu wrote:
> > 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.

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...@cs.fsu.edu wrote:
> 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@cs.fsu.edu wrote:
> > 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.

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...@cs.fsu.edu wrote:
> 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@cs.fsu.edu wrote:
> > 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.

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...@cs.fsu.edu wrote:
> 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@cs.fsu.edu wrote:
> > 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.