Use a LEFT JOIN.

INSERT INTO Prop (ListingID, Address, City, Zip, ListPrice, PropCID, PropTID)
SELECT
    LSID, B.Address, B.City, B.Zip, B.Price, 
PropCID = (CASE B.PropID WHEN 'A' THEN 'AA' WHEN 'B' THEN...

If you have package logging enabled, there is a wealth of information to be gained in the sysdtspackagelog, sysdtssteplog and sysdtstasklog tables in the msdb database.

It's to do with ANSI compliance. Take a look at this article,

http://vyaskn.tripod.com/differences_between_set_and_select.htm

Rather than copying and pasting a whole lot of links, go to the search for this site

http://www.sqlservercentral.com/search/turbo.asp

Enter "Business Days" and click all three check boxes. Peruse the results till you...

As far as I know there are no timezone conversions in storing and retrieving datetime data in SQL Server. What a good client application will do is use the local...

What account do the SQL Server and SQL Agent services use?

Check the connections in the DTS package. How are they connecting to SQL Server? Are they using the same credentials as the owner of the job?

NT Authentication is used for connecting to the server. Once you have successfully connected to the server, the permissions from there on are assigned by SQL Server.

This is the distinction...

Hmmm ... what are your stored procedures doing that the require specific permissions on the tables? Usually all you need to do is grant EXECUTE permission to the stored procedure....

Use SELECT instead of SET.

eg: SELECT @AcctNo = 1, @LName = 1, @AuthPerson = 1, @PUCo = 1

You have two options.

Option 1

If you absolutely have to have the information in Excel because of formatting or data placement requirements. What you do is create an empty Excel file...

Apart from any issues with the client application possibly hanging and causing a server restart (not much of an issue on your workstation, but a much larger problem when you...

If you added the comment as a Text Annotation, don't rely on it staying there. DTS is notrious for losing Text Annotations and the layout of the tasks.

You don't have

"...get around it by using a substitute statement, mapping my paramaters and then putting my original SQL back in via a disconnected edit..."

Makes maintenance a whole...

I find that hard to believe. I haven't dealt specifically with DB2, but interfacing to other vendors databases has always been extra slow using a Linked Server.

Have you done any...