I don't know if you actually read the article I linked to, but in it there is mention that you need to use a script component to actually get the...

I have a couple of comments:

1. You probably don't want to to create your trace files on the root of the C drive.

2. What account is the SQL...

Is D a local or mapped drive?

Are you attempting this via BIDS, a scheduled job, dtsexec?

Here's my take on this issue. As far as the database is concerned you never have to have a row in the link table. A book with corresponding...

Here's one of my favorite type of problem:

http://www.sqlservercentral.com/Forums/Topic665812-266-1.aspx

At least they have backups.

Check out RESTORE in BOL (books on line). Basic Syntax is:

Restore Database [db name] From Disk='path to backup' with MOVE '[data file logical name]' to '[data path]',

MOVE '[log file...

Do you have database backups?

I think you actually missed my point, which is understandable since I probably did not make it clearly, so here it is in what I hope is a clear manner.

You...

Can you post the query plan?

Why are you doing an Outer Join if tableB is a subset of tableA? Wouldn't this mean that every row in tableB would have...

I think I experienced a similar issue and I learned that the Script Component is instantiated (I think that would be the correct term) once during the Data Flow so...

If you are doing a lot of scripting in your DTS packages then you will need to rewrite those scripts and to do that you need basic VB.NET skills.

You have a couple of options.

One is to use a Lookup transform where you send the "error rows" (rows where a match is not found) on to the...

You may want to check out this BOL section: http://msdn.microsoft.com/en-us/library/ms156493(SQL.90).aspx

Here is one quote:

Report language

Reports use language settings for labels and formats:

* Labels are articulated in the...

I'm not real familiar with Partitioning, but I think you can add CompanyId to AuditListings to use as a foreign key relationship without having to partition the table.

Your other option...

I'm not a .NET guru by any means, but doesn't this code:

Finally

If success Then

InfoLabel.Text = "User successfully created."

...