You can use an expression for this.... rather than leave SSIS to work it out implicitly, you can explicity set it out as a date using ANSI date format. i.e....

This error is usually a permission problem.

If you are running under a SQL login, check that the service account has read permission on that filepath.

If you are running under a...

More ideas for you...

If you are trying to write to Excel and you have IMEX set to 1 in your connection string, your excel file will be in read-only mode.

You...

Have you tried using separate execute SQL tasks for each Create statement? I don't know if the Excel provider allows batches...

Also, you say that this fails only when you enable...

Thats a really neat approach. Good article.

Found the link

http://blogs.conchango.com/jamiethomson/archive/2005/08/08/SSIS-Nugget_3A00_-Get-error-descriptions.aspx

Good luck

Yes,

You can write a transformation script in your dataflow to capture the error description on your failing rows.

I can't remember off the top of my head what the syntax is...

In SSIS:

"Always use Execute SQL task because the database engine is faster"

"SSIS is slower than T-SQL"

"Just use the script task/component"

:crazy:

Hi,

I think one of the earlier posters may have mentioned this already.

Use a For Each container to enumerate through the folder. It will execute whatever task is placed within the...

Here[/url]'s the script to set the password programatically.

Hi Brian,

I blogged[/url] about this a little while back as I couldn't find much info on it at the time. It may help you too. You'd need to manipulate the...

It's interesting how people's interpretation of keeping it simple varies from organisation to organisation. I've worked in places where a developers concept of keeping it simple meant the simplest code...

Hi,

In SSIS you shouldn't need any scripting to achieve this.

Create 2 variables. One should be varSQLSelect (string) and the other varImportMode (or whatever works for you).

Then highlight the variable for...

Not much of a trekkie, but always thought that holodeck in Star Trek was cool... and completely under used!!

You could use a variable evaluated as an expression to build the SQL command that selects the data. That way you eliminate the need for parameters and you can debug...