is your varArgument variable in the readwrite variables collection?

an alternative to this is to use the dts.variablesdispenser to lock the variable for writing.

tom

have a look at this article:

http://englestone.blogspot.com/2008/05/ssis-send-mail-task-change-smtp-port.html

Tom

one way is to use a lookup transformation to compare the incoming records to the destination table. direct the "error" rows (i.e. unmatched) to the destination table and the...

Oh, I fell for that one. good question, highlighting an incorrect assumption of mine (I neither use exponents nor bitwise XORs on a regular basis).

Thanks, Tom

if the metadata for each source is the same, you could populate an ado object with the various department names along with the source connection string and the destination file...

I enjoyed this question (even though the clause is being phased out!) as it was something I wasn't aware of, and it made me go off and research the subject....

what happens if you set the ValidateExternalMetadata to false?

i usually find the easiest way is to delete the original source and add a brand new one with the modified sql (the code with the explicit cast in it)....

at a glance, I would say perhaps an easier solution would be to use a data flow task in your foreach loop.

use the loop to iterate over your directory...

check the metadata on your source transformation and see how the column is being pulled across. you may need to do an explicit conversion in your source sql

tom

a global executor is simply another package that you use to control the execution of your other packages.

It is just a package executing blocks of code, except these blocks are...

it seems that perhaps a global executor might be the way to go in this instance. you could group location specific packages under their own containers and use conditions...

why would you want them in separate jobs and not in one job as separate steps?

you can schedule them as separate steps in a job using sql server agent, or you could have a global executor parent package that would run each package using the...

you can use a foreach loop to loop through the files in a directory, then use a dataflow task to pass the data across to your database.

tom