Check out this article[/url]

Restore the the database to another location (database) and then select from the restored database to the production database.

Could you give some details on how Colour and Name are associated with Cabbage?

I agree with Grant, that is exactly the resultset I would expect from that query. An OR would return:

name age

------ ---

name226

name427

name527

name325

Looks like you should be tuning those queries.

You need to do a check for a null value BEFORE the ToString() function is used. You can't convert a NULL to a string. Somthing like:

If Not IsNothing(columnValue.GetValue(Row, Nothing))...

Your boss is being a little shortsighted as custom components can save a ton of time. You should still download mine for the source as it does a better...

Glad I could help.

Unfortunately there is no debugging in Script Components like there is in the script task. A real oversight in my opinion.

I realize you did not create a new component, what I am saying is that I created a Custom Component for SSIS that you can add to the toolbox and...

Unfortunately there is not a straightforward way of doing this. Here is a link to a blog post (not my blog) about how to do it:

http://agilebi.com/cs/blogs/jwelch/archive/2007/10/21/address-columns-generically-in-a-script-task.aspx

You could also look...

The answer is "It Depends".

In the project I was working on when I put this together I wanted a way to find out what data was causing my...

I am not aware of any way to do exactly what you want. This is why I like to use stored procedures for all data access and manipulation. ...

What SQL Server "sees" as your parameter value is '1,2,3,4' a single string that cannot be converted to an integer. There are 2 ways to handle this situation:

1. ...

I also mentioned that SSIS processes data row by row, it just looks like it is processing batches when it moves quickly. With this "pipeline" approach, an error down...

Everything appears to be working as expected.

In your image the data conversion is successfully processing all 3 rows, none caused an error, so there are no rows being passed to...