Research ALTER TABLE in BOL or you can perform this via EM

UDFs AND SPs are both compiled.  Granted their are specific instances that force SPs to be recompiled but generally that is not the case.

You will still need a sp to...

Unfortunately, I don't think we can add much without seeing the view(s) to help diagnose your problem..

You will WRITELINE your oFile to a text file.  There are plenty of sample scripts in VB BOL, and on the internet (to include decent from support.microsoft.com) with textstream, writeline,...

I would research BEGIN TRANSACTION in BOL.  That will give you #2.  #1 is more art then science and BOL doesn't cover it.  I think your easiest bet will be...

I think you are missing techarea from your GROUP BY as well...

You are correct there is a system table that stores descriptions of FIELDS but not a TABLE descriptor.  These are extended table properties and you can look them up in...

Why not fire the EXE via xp_cmdshell in QA?

1. Still get to develop
2. Get to "tune" the system by running tools that generally developers don't have access to and analyze what the tools are saying
3. Get to mentor developers either gently...

basically you need to build a temp table and populate column A with your ID list.  You will then need to LOOP (any way you prefer) and start with the...

Why are you using , 101 when you are doing CONVERT(DATETIME)????  Located in INSERT statement...

If you are converting to VARCHAR(10) change the DATETIME to be VARCHAR(10)...

Try

CASE COUNT(App.techarea) WHEN < 1 THEN COUNT(App.agency_id) WHEN > 1 THEN COUNT(App.techarea) END AS CountOfTA

OR

you could just add the END reserved word after your 2nd THEN.....

I think your problem is cust_ord_due = '2005-03-28' AND GetDate() = '2005-03-28 12:14:00.000'

Change your code to be CONVERT(VARCHAR(10), GETDATE(), 101) and your code should work.  If you want to WRAP...

I would make sure that the RunAS for the SQL job has rights to perform the activities involved.  When you run the package it uses YOUR rights...  May be permission...

IF you have this hard-coded in the DTS packages there is no way around...  IF you use UDL file or some other mechanism for the connection change in 1 place...