Functions used in a select will slow a query down as the contents of the function is run for each and every row. but I said that already

When you add the path, you use D: when the error is \\tedevsql02.

is D: relative to that server?

How about security? Can SQL See that path?

I second that - Not In's can kill you. Avoid non-sargable queries.

http://www.sql-server-performance.com/transact_sql.asp

"Try to avoid WHERE clauses that are non-sargable. The term "sargable" (which is in effect a made-up word) comes...

The main drawback for RAID5 is the time taken to calculate the parity bit. When log files or data files are on a RAID 5 array, the write requests are...

Firstly, get rid of the nested select. Functions and nested selects are inherently slow.

Rather use another way such as a join, case statement etc to suite.

This however does not explain...

and there you go... Have to love the simple alternatives.

hold your horses....

The duplicates in cache cannot be seen in the data viewer. You are looking at your source data there, not the cache.

Saying ignoring errors because there is an...

You're sort of on the right track.

You need to use the error output for each component in the data flow. That's the red line. You also need to ensure that...

Not really an answer to your question (because I don't use ActiveX script task)

The ActiveX component is depreciated. Why not change the code to use the script component which is...

First note: Don't select a table unless you are using every single column in it. If you are not, select only the columns you will use. Why waste memory?

The key...

it's as the error says - you have a duplicate in your cache.

The statement that you are using for the lookup is returning a duplicate based on the key. Run...

You cannot change the meta data at run time for a data flow.

Your best bet is to dynamically create SQL to do the select and insert and execute it as...

Stay away from the active x script. It is end of line and would be removed soon(?)

if you really want to log using VB, you would use StreamWriter object.

Here...

You will have to use a script task or a file system task to create the folder. The name and path of the folder can be derived from a variable...

Your best bet is then to use a *.* wild card.

Inside your loop, drop a container control. This does nothing but lets you add a constraint between it and your...