Thanks Gail,

Its a developers environment with little diskspace on which we occassionally have to load and process data thats about as big as the total available diskspace.

Regards,

Ben

I think I can use the sql server objects task and then your renaming option.

thx

Hello Russel,

Thanks..

Im not sure how to restore DB_X (170 tables) into an existing DB_Y.

The restored DB_X tables need to be dropped and recreated every day

Ben

Each customer has its own view, its own database and its own file.

I used the dynamic properties task so i dont need to program in AxtiveX.

Furthermore i used a sp to...

The platform is SQL2000, but the move content action from view_x to file_x has to take place everytime the user askes for it from within a asp.net application.

A new customer_y can...

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_NULLS ON

GO

ALTER   procedure SP_CREATE_VIEW_TEST

@dbname sysname,

@Klant_ID bigint

as

DECLARE @cmd varchar(3000)

SET @cmd = 'USE ' + @dbname + ';GO;CREATE VIEW FACTUURGEGEVENS_' + convert(varchar,@Klant_ID) + ' as

SELECT  ikp.IKP_GROEPNAAM,

 ikp.IKP_NAAM,...

I tried this:

ALTER procedure SP_CREATE_VIEW_TEST

@dbname sysname,

@Klant_ID bigint

as

DECLARE @cmd varchar(3000)

SET @cmd = 'USE ' + @dbname + ';CREATE VIEW FACTUURGEGEVENS_' + convert(varchar,@Klant_ID) + ' as

SELECT  ikp.IKP_GROEPNAAM,

 ikp.IKP_NAAM,

 ks.KS_NUMMER,

 ks.KS_NAAM,

 lev.LEV_CREDITEURNUMMER,

 lev.LEV_NAAM,...

I tried this but i get :

The name 'USE db_presmon_dwh_9;CREATE TABLE dbo.ETL_TEST (LAAD_KEY bigint IDENTITY (1, 1) NOT NULL , LAAD_DATUM datetime NOT NULL) ON [PRIMARY]' is not a valid...

You can, however, use the three part name for the table(s) used in the VIEW definition.

I will look into it, thx for your suggestions.

Ben