I have to say you are very ambitious to use XRef to have cross-reference. It seems to me what you are trying is:

Select * from (Select detail.ID, detail.DX, detail.Mcode ,...

What I showed you was to prove the data model was working for you. Specially the ConditionLine table is the key in my model. I put this table because the...

No, you do not replace the string but global variable will be replaced automatically. Follow the instruction below but I added this already in the previous mail.

Now you need...

Is this something you wanted? Then you need an identity.

SET NOCOUNT ON

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TestID]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[TestID]

Create Table TestID...

Try this:

-- Create tables ModelOffice, Condition, ConditionLine. ConditionLine table contains the office and Condition information.

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ModelOffice]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table...

For Global Variable: http://msdn2.microsoft.com/en-us/library/aa933470(SQL.80).aspx

For ActiveX Script: http://msdn2.microsoft.com/en-us/library/aa933459(SQL.80).aspx

For Connection: http://msdn2.microsoft.com/en-us/library/aa176223(SQL.80).aspx

For Execute SQL Task: http://msdn2.microsoft.com/en-us/library/aa933511(SQL.80).aspx

For DTS in general:

I am sorry that I could not understand clearly your situation. What is dies table? In your original inquiry it said:

I am building a DB to handle production...

I am attaching one of my sample ActiveX Scripts. Basically it loop through a folder to find files using the Function ShouldILoop. if a file found the function returns TRUE...

Use GlobalVariable. This is how you can do it.

1. Create a GlobalVariable "gv_FileName" of type STRING.
2. Create a TextFile(Destination). Give any name when you create it.
3. Create a Dynamic Properties Task.

Inside the Dynamic...

Yes, you can send an email using GlobalVariable.

1. Create a GlobalVariable "StepName".
2. Set DTSGlobalVariables("StepName").Value="Step1" or something representing the step in the ActiveXScript task.
3. Create a Conncetion. This is required for send mail using Execute...

1. The package runs fine when I launch it from Enterprise Manager on my machine.
2. However the job I created to run the package fails.

This is because when you run the DTS...

Suggestions:

1. Verify the network is OK by PING to the servers.
2. Stop and start the services including MSSQLServer and SQLSERVERAGENT
3. If #2 did not work, then reboot the server that runs the job.

I am not too certain why you are complicating youself by using self join table. Do you have to build using only one table that hold the series of dies?...

"I did not change anything" is something always being heard from develpers. There must be something has been changed whatever that is.

I suggest to trace through SQL Profiler. You will...

It seems like you have two issues here.

1. Microsoft VBScript runtime error '800a01a8'

Object required: ''

/iPortforms/Stock/StockStatSegments/A1.asp, line

I am not too certain whether you figured out this issue??? I...