Aytime I try to set up a DTS package with a temp table it will not parse and thus fails. If I change it to a table variable it will work. Unfortunately I now have a situation where I need to be able to insert the data from another sp into a temp table to use in this sp that I want to run a DTS package on. Since a table variable cannot be used that way, I'm stuck with rewriting a very long complex procedure into another very long complex procedure. I will rewrite it is I must to put it all in one sp rather than calling an sp from another sp, but I would prefer not to if there is some way to get DTS to be happy about using a local temp table. Has anyone evcer sucessfully gottten DTS to use a temp table? If so, what did you have to do?
Questions about posting. See faq183-874
Click here to help with Hurricane Relief
Questions about posting. See faq183-874
Click here to help with Hurricane Relief