> Hi
>
> Is there a reason, why I wouldn't be able to transfer/export data,
> derived from #Tables, in DTS?
>
> Incidentally, the final query in the SP, is made up of a UNION
> statement, should this also be a factor?
>
> Kind Regards
>
> Ricky
>

"Allan Mitchell" <allan@no-spam.sqldts.com> wrote in message
news:5aaa44808d0f8c876119e894eb8@msnews.microsoft.com...
> Hello Ricky,
>
> You won't be able to see the # tables to do the mappings.
>
> Why not create permanent working tables to do this? if you use the
process
> often then you will not incur the overhead of building the tables every
time.
>
> Allan
>
>
> > Hi
> >
> > Is there a reason, why I wouldn't be able to transfer/export data,
> > derived from #Tables, in DTS?
> >
> > Incidentally, the final query in the SP, is made up of a UNION
> > statement, should this also be a factor?
> >
> > Kind Regards
> >
> > Ricky
> >
>
>