Newbie question about Object transfer

Hi,

I'm new to Integration Services and I have a problem when I try to make a simple transfer of tables and views between 2 DB.

The idea is to copy tables and views from DB1 to DB2.

If the object exists in the target DB, it must be dropped, then created and the data must be copied.

The problem occurs when a new object is created in the source DB and thus does not exist in the target DB. This throws an error because the system cannot drop an object wich does not exist.

What is the workaround ?

The idea is to execute this package every hour to have a cached DB. In this case, replication is not a solution.

Thanks in advance,

Patrice.

This issue is a bug in SQL Server 2005 RTM. Hopefully it will be fixed in one of the SP releases in the near future.

Newbie Question

Hi all,

I am using following update command but getting error on database field
name. I can't change the database filed name, please give me idea how can
I use reserved word in this statement.

update ws_apps
set database = 'EFORMS'
where app_id=4

Thanks for your helphqureshi1103@.rogers.com (Adnan Jamil) wrote:
>Hi all,
>I am using following update command but getting error on database field
>name. I can't change the database filed name, please give me idea how can
>I use reserved word in this statement.
>update ws_apps
>set database = 'EFORMS'
>where app_id=4
Try:
update ws_apps
set [database] = 'EFORMS'
where app_id=4

HTH,
Myron