The approach we take is to move the the read-only tables from the primary databse (D1) and put them into a different database (D2) and expose them in D1 via a view.  This...

You could set aside a master copy of the spreadsheet and copy it to the real destination as part of the "initialization" of the package.

HTH.

What I guess i'd try is a second sheet in the workbook.  Load from DTS to that second sheet and have a region in the final sheet that displays the...

Some development and front-end tools will generate a:

select * from <object> where 0 = 1

for every table and view in a database as a way of cataloging the columns in all the tables...

We use a heavily restricted .INI file that the users can't see.

However, it appears that all your activity is between SQL Servers.  Why not take advantage of trusted connections?  Your...

There are many differences between VBScript and VB.  I'm pretty sure two of them are:

VBScript:

Dim X

VB:

Dim X [as <datatype>]

VBScript:

next

VB:

Next [<variable>]

I always have trouble developing in VBScript.  It's powerful but finicky. ...

Do you expect to be running on good, contemporary hardware?

If so, I think I'd just try a 100K row operation all in one go and see what happens.  You could...

I am not sure I understand the question but this might be what you want:

select

 sum(case when col3 <> '' then col1 else 0 end) as c1,

 sum(case when col3 =...

In my experience, the "(local)" references won't prevent you opening the package, they'll just prevent you opening/editing certain objects on the package (actually, trying to edit those things, usually your...

I'm fairly sure its in dtspackages in msdb.  The "guts" of the package are probably in the packagedata column, which is an image datatype.

Looks like "nasty indecipherable code" to me.

Did...

It should be as easy as:

select

rtrim(t.last_name) + ', ' + rtrim(t.first_name) as name

from table t

If that doesn't work the way you want, post your SQL, the output and information about...

I don't know what your limitations and requirements are but we usually store binary and image data in files and then just store the file name in the database.

The front-end...

If you're trying to output this to a file, you might look at using DTS for this.

When you say "report," I'm not sure DTS is the method but you could...

I have no idea why you see this problem.  However, you might just try a maintenance plan to get your regular backup run.

In EM, right-click on "maintenance plans" for your...

FYI - I'm fairly certain COALESCE is in the ANSI standard syntax, which is why I'd recommend it.

select coalesce(null,'x') returns an 'x' on Teradata.  However, nothing is simple on DB2.

select...