Thanks, I never thought of that, I am scripting the rest using the addrolemember stored procedure.

Thanks that did the trick!

I would set a for loop and inside it have a script task that sets a variable with the sql command needed for the current 2 month block. then exectue...

This is what I wanted to avoid, we use vmware and network storage so all our drives are setup with minimum amount of space. Its a general rule that nothing...

did you verify the security that the job runs under?

2 things I would check, first make sure the job is running under an account with the proper security and second use a UNC path just to be sure. If...

my first thought is that the file does not exist when the package begins execution and fails on the validation step. there is a delay validation setting on the flat...

The input column is assumed to be a DB_DBTIMESTAMP.

DATEPART("Day", MyDate ) < 15 ? MyDate : (DT_DBTIMESTAMP) ( (DT_STR,4,1252) DATEPART( "Year", MyDate ) + "-" + (DT_STR,2,1252) DATEPART( "Month", MyDate...

Here is a suggestion, I'm guessing there may be a better way, but this may get you started.

Run the query to generate the error list using an execute sql task...

I am getting the same thing, what I noticed is the post execute gets to 25% and the package ends with a status of canceled.

The data flow ran meaning the...

Thanks that's exactly what I was looking for.

I have updated all my connection manager configs to include the port number in the connection string.

You mentioned the browser, on the this particular server we are not running the...

I have updated all my connection manager configs to include the port number in the connection string.

You mentioned the browser, on the this particular server we are not running the...

thanks Steve,

Also wondering if anyone does this for servers setup on a non-standard port. I've had intermittent connection problems and was curious if this could be an issue. At the...

scratch that, sorry I didn't read carefully.

I don't believe there's a way to change mappings on the fly.