I need to load data (either insert or update records) into a many
horizontally partitioned tables. I have a DDQ task set up to load the
data from a staging table. Is it possible to have the destination, of
a DDQ task, to be a view instead of a table ?
The designer does not seem to allow specify a view as the destination.
I hape to be able to use the DDQ task to load data into the view
instead of having to create a seperate DDQ talk to load individually
into each table in the partitioned view.

Thx,
Ken

Try setting the DestinationObjectName using the Disconnected Edit facility
or the Object model. To make sure that you can build the transformations
before hand have a table with the same meta data whilst you build the task.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Ken" <raidken (AT) yahoo (DOT) com> wrote

I wrote an ActiveX script tp updated the object property in a loop,
while reading the values , for the property, from a file.
Allan thanks for the pointer.

Ken


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote