It appears that since nobody replied to my first post, DTS does not allow a
view as the Destination for a Data Export or Transform.

"Sometimes the answer is found in the silence."
John Kotuby 11/18/2005

Have a good day everyone :-)

If you can insert into the view with normal SQL it should work for an import
(cannot guarantee fast though). Has to be an updatable view however. If
you can't insert with a T-SQL statement, you can't use DTS either. I've
never tried it, but it "should" work. This is similar to the operation in
http://www.sqldts.com/default.aspx?204 in particular step 3. You can use a
table/view not listed, but you have to go through the back door.

Scott

"John Kotuby" <johnk (AT) powerlist (DOT) com> wrote

Thanks Scott,

I have tested your suggestion using a Dynamic Properties task to set the
DestinationObjectName in the DataPump task to a simple updateable view using
DTSGlobalVariables. It worked!

It's still not working with the partitioned view, but I think that I must be
sure to pass all field values in that case and not rely upon default
constraints in the underlying tables.

However, the proof of concept worked well. Have a great day...

"Wm. Scott Miller" <Scott.Miller (AT) spamkiller (DOT) wvinsurance.gov> wrote in
message news:uy2NbPG7FHA.632 (AT) TK2MSFTNGP10 (DOT) phx.gbl...