You can get around this by creating a new column of type DT_DBDATE and using this new column to write to the CSV file.

First, add a new derived column transformation...

Thanks Lynn - forgot to add the hyperlink.

A foreach loop in SSIS is, by definition, an iteration of n items, in which n is defined at the beginning of the loop. So you can't really exit...

You won't find that information in the package itself. If you have logging set up on the package, the logging information will give you that information. If you're...

If I understand correctly, you want to filter the sample barcode from the main report even though this field is not present in the main report?

If that's the issue, you...

Maggie,

I'm not clear on which piece is giving you trouble. Are you having trouble with the query itself, or with passing the values from the main report to the...

If you want to continue processing after a task error, you can use the Propagate property of the mail task. I recently blogged about this design pattern here: http://www.timmitchell.net/post/2013/08/05/continue-package-execution-after-error-in-ssis/

If you're...

If that's the case, there are a few troubleshooting steps I'd recommend:

First, add a Data Viewer to each data pipeline in your data flow. This will allow you see...

If you're still looking for an answer on this, I published a blog post on this topic earlier today:

http://www.timmitchell.net/post/2013/08/05/continue-package-execution-after-error-in-ssis/

If I understand correctly, you want to write an output CSV file to the file system on a destination server on a different network. The easiest way to do...

Are you writing this to a relational database table? If so, what is the data type of the destination column for this value?

This is a fairly common issue with SSIS (at least in versions before SSIS 2012 - I haven't yet tested this on 2012). When using a stored proc as...

Great! Glad it worked out. Thanks for the follow up.

For both of the posters asking about this, I'm going to second Phil's earlier comment. If you're using SSIS for ETL, don't use xp_cmdshell to fire executables against the...

I agree with the above comments - you can learn a lot from reading questions other people are asking (forums) as well as learning from experts (blogs, online videos, etc.).

I...