Great article, thanks.

Thanks, nice question.

Very interesting question, as I don't have SP1 installed yet on our server.

Luckily I guessed the intent of the question and realised that the first answer was a typo.

Let the...

Second that one. The File System Task is...

David Walker-278941 (2/23/2012)

---

Thanks for the reply. (The word "reent" in my question should have been "recent".)

SSIS expression language is a horrible language! I had to write some...

You can set the time-out behaviour on the database server, but I would advice not setting it to infinite. It can affect other applications as well and can cause programs...

In SSIS, use the datatype DT_NTEXT instead of the regular DT_WSTR.

Try reading a book. For example:

SQL Server 2008 For Dummies

or

Microsoft SQL Server 2008 Internals

Do you use Windows Authentication or SQL Server Authentication?

Are you running in 32-bit mode?

You have a bit of conflicting requirements 🙂

Rollback if there's a failure, but still insert some rows somewhere.

If you could do everything in TQSL you could maybe do a TRY...

subhaannai (2/22/2012)

---

For example if some Db connection time out error occurs,when my data's are half written in my file.I want this to be handled.My package should not fail.It has be...

subhaannai (2/22/2012)

---

hi koen ,

I have to include a header and footer in my file, based on the number of records in the file.Thats y i opted Script component.

Can u pls...

I think there's something wrong with that First function.

It has the entire boolean statement as a parameter:

Fields!IsSales.Value, "spBOSS2012_Reports_InvoiceHeader") = 1 or (Fields!NEWBOSS.Value, "spBOSS2012_Reports_InvoiceHeader") = 0

Carlo Romagnano (2/22/2012)

---

I found this: http://msdn.microsoft.com/en-us/library/ms190249.aspx

It states that:

To change the default values for any one of the database options for...