Viewing 5 posts - 1 through 6 (of 6 total)
I found a link which helps me solve the problem by using global temp tables:
It helped solve the problem.
May 10, 2011 at 12:03 pm
Unfortunately the people in charge of our production applications frown upon keeping staging tables on the same database/server.
May 2, 2011 at 11:10 am
We are looking to use SSIS for scheduling and we also need to log the data retrieved on a different server.
With that in mind, we're using an OLE DB Source...
May 2, 2011 at 9:32 am
With the example I provided, I didn't need to set that flag however with my code I did lest it give me the same "No column information..." error.
There could be...
April 28, 2011 at 1:44 pm
@Elliott:
Excellent! Encompassing the entire thing in an EXEC statement worked! 🙂
One thing that I noticed was that I needed to add the SET FMTONLY OFF flag.
@Phil:
Your solution...
April 28, 2011 at 12:35 pm
Viewing 5 posts - 1 through 6 (of 6 total)