Post reply

Loading Views Through DTS

  • October 17, 2006 at 12:03 am

    #67947

    Hi,

    Is it possible to Load view through DTS?

    If so please let me know..

    Right now i am loding the view through stored procedures.

    Thanks & Regards

    Chethan

  • October 17, 2006 at 3:05 pm

    #666362

    Do you mean use a view as the source of a data transformation?   If so, yes.

  • October 18, 2006 at 9:54 am

    #666557

    Chethan,

    I don't think you can use a Transform Data task to import into a view, but you can use an Execute SQL task using your current stored procedures.  I'm not sure if that would gain you anything over your current process.

    Greg

    Greg

  • October 18, 2006 at 9:40 pm

    #666701

    Thanks Guys..

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply