It would help if you posted some sample data and details as to what you are doing.

I find the error quite easy to understand. On row 44870 the column...

Select

parent_product,

product,

sub_product

From

products P Join

...

I changed to a Fuzzy Lookup with a minimum similariaty of 1 and a similarity threshold of .99 ( as high as it will go) and I get a match...

I think the error handling is logical. I would suggest alos passing back some kind of error flag so that your UI/business layer knows that it tried to create...

Well, as far as I am concerned, if that is truly your definition of uniqueness you should have that unique index on the table anyway.

First off, you probably would have gotten quicker response had you posted this in the Reporting Services forum.

Your expression sounds fairly simple to me, if I understand correctly. In...

First off, how are the tables being updated? I normally put this kind of work in the stored procedure/front end doing the updating. The only way to encapsulate...

Here is a link to an article on this site that answers your question:

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+SSIS/transactionsinsqlserver2005integrationservices/1653/

Basically is says that Supported means if a transaction was started by the process that calls the...

It would be helpful if you posted some sample data form the csv and the table specification. Based on the limited information given it sounds like you may have...

To accomplish what you are trying to accomplish you do not need to create the connection and command in the ASP.NET page. You just need pass the parameter...

The best way to send the date to SQL Server is YYYY/MM/DD. So if you switch this:

SUBSTRING(INVOICEDATE,7,2) + "/" + SUBSTRING(INVOICEDATE,5,2) + "/" + SUBSTRING(INVOICEDATE,1,4)

to this:

SUBSTRING(INVOICEDATE,1, 4) + "/"...

I don't think you can alter a running job. What you can do is just add the second step before starting the job like this (note adding on success...

WHere are you setting the report data source to the sqlcommand you are executing?

Have you verified that you are getting an empty string from the app? Are you sure youare getting data back to the app? I would change the if...

I just assumed the temp table represented the master table for example and testing purposes.