Perhaps I misunderstood your first post. I thought you were having problems with spaces.

Could you clarify for...

can you control how the xml is handled using the xsd document? perhaps you could specify how to handle white space using this?

tom

is the connection string for the flat file connection constructed using an expression?

do you have the text "@[user::variable1] =" within the expression for the variable?

if this is the case, then remove it and just have "update email set locator_id =...

are there any other tasks in your workflow that may have a hold of the file? perhaps a file system task that has copied off the file and...

any container has the disable property, which means it won't execute at runtime, and as the package is also a container it also has this property.

tom

There are two ways:

1. Use the Set values tab in the job step. The property path needs to be \Package.Variables[i]myvariable[/i].Value and then enter the new parameter value in the...

you can store the count in a variable using a execute sql task. then, set the workflow constraints to use an expression. place your check here. you...

there seems to be some issue with a null reference in your data reader source. is any part of this handled dynamically at run time?

tom

i'm not entirely sure the execute sql task is quite as dynamic as you hope.

one solution would be to use a data flow task to write the data from the...

you could use the script as a dummy task (i.e. it does nothing) and have a constraint between the script and the data flow which uses an expression.

then, in the...

what happens if you do as Crispin suggests and carry out the conversion in the source SQL? So, choose SQL command from the drop down and cast the column...

use the error output of the transformation to find out which rows are causing you problems.

You can do it in the derived column transformation using the syntax (DT_I4)[Your Column] in the expression field (for a four-byte signed integer).

in the derived column transformation, expand the list of columns in the top left pane. click on the one you want (the new one from the conversion transformation) and...