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.

Setup your file source to skip the first row and don't use the header info. As long as each file has the same format there should not be any problem.

Hi, We're also using SVN and wan't to know if there is any possibility that the merge function would work for a dtsx file modified by 2 developers. I can't...

I just re-read your post and you say "Access mode to Fast Load" I assumed you were referring to an OLE Destination, is that correct or is Access mode something...

I run fast load on all my inserts. Unfortunately we've been trying to get the latest release deployed and I have not had any time to investigate. We are in...