OK, I've been playing with this and sys.dm_exec_sql_text only returns the code for the procedure. It doesn't return what the values that were passed into the procedure were.

Hmmm, OK, I'll play with that. It was always returning to me the entire actual code of the procedure. I didn't become intimately familiar with all of the...

Yes, this is for auditing purposes.

Yes, I know that in each and every procedure I could query the values that the proc was called with, but this is a very...

Here's what I can think of:

With DTS you can have better logging and error handling.

Without DTS you don't have to have the DTSExec running in the middle which I have...

Building on Tom's reply, it seems like you could check to see if all of the files are there. 

If they are, then you go about your dts package, and...

The g represents an Alias.  Instead of having to type tblGroups all the time, I can just type g.  You'll also noticed I aliased the two different ID fields. (u.ID...

With the relationship (many to many) table, it's probably best to first create a generic view.  Then your queries would look something like this:

View

CREATE VIEW v_UserGroup

AS

SELECT

  u.ID UserID,

 ...

Actually, my preference is to keep the extra ID.  I usually will have it be an IDENTITY value.  I DON'T use it as a Primary Key though. I do as...

Use the 3rd table (called a many to many, or relationship table).  This way it's easy with one select to see which members are in a group, or which groups...

Not sure exactly what you're looking for, but you should probably be able to find the answer here: http://www.sqldts.com/default.aspx?103 and if not, at least get some ideas.

There's no easy way around it that I can think of.  You're going to need an intermediate database that you would then drop the tables that you don't want included...

So did I?

It appears that you only have a couple of options.  You can:

1.  Change the source table to disallow Nulls, or somehow update them to 0 or default them to 0.

2. ...

Question #1:  Is the date coming from SQL Server to FoxPro, or is it coming from FoxPro to  SQL Server?

I've seen sometimes that the oledb provider will sometimes read the...

There are numerous ways to this. 

You basically have to convert it to a string first.  convert(varchar,getdate(),101) will get you there.  (this way I don't have to set the char(xx)...