You could be right - my memory may be backwards on this, but I thought it was on the workstation that it needed to be in the framework folder. ...

To be perfectly clear, the .dll does not HAVE to be in the .Net framework folder on the server if you only run the package through the job agent. ...

The .dll needs to be in the .Net framework folder and registered in the GAC on any machine that will be executing the package.

If you open the package and run...

Just re-check the settings in the wizard. You have your expired indicator set backwards. I know the SCD components works correctly for using a boolean to mark records...

You have lots of options.

Here is another post in which I outlined some of them with some details:

http://www.sqlservercentral.com/Forums/Topic508430-364-1.aspx#bm508682

This is called a Type-1 Slowly Changing Dimension in the data warehousing world...

Write a UDF for this.

Your query performance is going to be pretty bad because of the CASE statements anyway, eliminate the headache.

[font="Courier New"]CREATE FUNCTION dbo.MinDate(@Date1 DATETIME, @Date2 DATETIME) RETURNS DATETIME

AS

BEGIN

DECLARE...

What you have is a list of files you do not want to delete.

So, I would simplify this a bit and loop through all fiels with a ForEach loop.

Each time...

You may want to throw in some error handling, but it would look something like this:

[font="Courier New"]CREATE PROCEDURE appInsertContractorRegistration

@ContractorName VARCHAR(50)

, @ContractorID INT = 0 OUTPUT

, @RegID INT = 0 OUTPUT

AS

SET...

Well, if they build a GUI similar to the one for Service Broker, it will be another great tool that most DBA's end up afraid of.

Even with a temp table, you are going to have to dynamically generate the create statement for the temp table and then execute the procedure inserting the records into it....

I would avoid xp_cmdshell - it is disabled by default for a reason.

Using the job agent is pretty easy and works well. If, however, the SSIS server is the...

You can also right-click on the control flow and choose logging to use the supplied log providers. One of them is a SQL provider that will log to a...

I don't know if "implied" constraints can be setup through the diagram wizard. I only tend to use the diagram wizard to actually set up real constraints.

On databases in...

In columns in which the length does not vary greatly, you could see a performance increase using CHAR vs. VARCHAR because many operations against fixed width data are faster.

However, data...

Zipcodes in particular cannot be stored as numbers - they can start with zero.

As far as storing the formatting, that can depend heavily on what you intend to do with...