I am trying to create a DTS package for copying data from one database to other. The source of the package is a view which takes long time to execute. The destination is a table. I was able to select the source and Destination , but when I clicked the Transformations tab to link the fields, it got stuck. Is this because it is trying to run the view?
Thanks