What I do in my dts is to have several data transformation tasks, to build each dim table and then one to build the fact table.

As I said you can specify...

Assuming the Dim tables are populated correctly then get the keys/ids when you select data for the fact table

insert into facttable

select s.col1,

s.col2,

d.datekey,

s.coln

from sourcetable s

inner join dimtable d on d.inputdate...

The bcp will be blocked by the insert/update locks. Try adding NOLOCK hint to the tables in testprocedure.

netstat -na will give IP Address for LISTENING but only on WIN2K SP4.

netstat -na will not give you IP address for LISTENING only for ESTABLISHED connections

Try This

DECLARE @stdate datetime,@enddate datetime,@wkdate datetime,@sql nvarchar(4000),@sql2 nvarchar(4000)

SET @stdate = '2004-04-01'

SET @enddate = '2004-04-06'

SET DATEFIRST 1

CREATE TABLE #temp_sum (CODE CHAR(10))

SET @wkdate = @stdate

WHILE (@wkdate...

Can you explain what you mean by 'skip weekends' and 'total will be wrong'.

Are you trying to output total qty per day for a calendar month or between two dates...

This will search the procedures in a database but will not find the text in encrypted procedures

declare @keyword varchar(20)

set @keyword = 'keyword'

select distinct s.name 

from sysobjects s

inner join...

Not sure what you really after, but this procedure

CREATE PROCEDURE insert_data @input char(150)

AS

INSERT

INTO [yourtable]

(col1, col2, col3)

VALUES

(

SUBSTRING(@input,1,50),

SUBSTRING(@input,51,50),

SUBSTRING(@input,101,50)

)

GO

will split 150...

After reading your other post on this matter, I would do the following

create temp table containing identity column and teacherid. Insert the unique teacherid's (ordered if you wish) using the...

Why are you using activex.

Change your proc (dbo.Mainframe_Extract_LateStart) to include the spaces

In the DTS Transform Data Task specify the query as

EXEC dbo.Mainframe_Extract_LateStart 'HCO'

p.s. if your proc does anything with...

OK try this

CREATE TABLE #assoc (rowid int IDENTITY(1,1), BOOKING int, Z_ASSOC_ROW numeric(9,0) ,Z_ID varchar(254))

INSERT INTO #assoc (BOOKING, Z_ASSOC_ROW, Z_ID)

SELECT BOOKING, 0, Z_ID

FROM GS_DETAIL

ORDER BY BOOKING, Z_ID...

You can do it in dts to a fixed length file by selecting the data and adding extra columns for the spaces, e.g

SELECT col1,

' ' as Space1,

col2,

' ' as Space1,

col3,

'...

Firstly your relationship is incompete, what you are asking for is all DETAILS for bookId and all STAFF for a bookId and that is what you got. You need to clarify...