Once you enable xp_Cmdshell, it can be used for a lot of things. If the CLR procedure can only move a file from one location to another, it ends...

Jeff Moden just published an article on this site relating to this topic. It specifically addresses the performance differences.

http://www.sqlservercentral.com/articles/T-SQL/63681/%5B/url%5D

That would be a good place to start.

You can connect from another server that has SQL 2000 and DTS without doing anything else. If you want to run DTS locally on the SQL 2005 server, you...

You need to not allow NULL or specify to use the default. If your column does not allow NULL, selecting the "Ignore" option will use the default value. ...

In addition to xp_CmdShell, you have a few other options. Enabling xp_Cmdshell can be a security problem - these other options will be a bit more secure.

1) Create a...

The query builder uses ANSI 89 SQL Syntax. So, it's join syntax will be a problem for any outer joins and for other joins, the syntax is deprecated. ...

Use expressions to build a string for the SQL Source.

To start with, test to see if it is the provider - just hard-code in the SQL Statement that was taking...

Some versions of PC Anywhere are REALLY resource intensive. Make sure you are running the latest version if you have to run it at all.

My suggestion would be to...

During the pre-execute, an OLEDB Source will try to cache the data, so this is when the SELECT is being run. I assume it does not really take this...

I always try to create the minimum number of roles possible. If permissions need to split later, I split them at that time rather than trying to anticipate that...

SELECT Company, CASE WHEN Company LIKE '%, The' THEN 'The ' + REPLACE(Company,', The','') END AS NewCompany

FROM MyTable

Not really.

In SSIS 2008, you have an option to add to a lookup cache at runtime, so you could do what you are suggesting. In SSIS 2005, the easiest...

By default, transactional replication uses stored procedures to do the individual INSERT/UPDATE/DELETE operations. So, modifying the stored procedures (or specifying different ones) can allow a great deal of flexibility...

Even if it was not shut down cleanly, you can still recover your database without the log file. You may have some data loss and possibly some corruption. ...

If you load them all with a single data flow, SSIS can remove the duplicates before loading them into the table.

Add two source components to your data flow and connect...