SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Exporting To Excel: SP contains #Temp table
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

5fifty5
Starting Member

35 Posts

Posted - 01/21/2010 :  05:53:56  Show Profile  Reply with Quote
Hi,
I have created a Stored Procedure which contains a temp table. I am using this SP in a DTS and using EXECUTE. A Transformation Task is exporting data to a CSV/TXT file.

Now, my problem is that when I was setting it up, it worked fine and showed columns in Transformation. However, for some reason, I can't see the columns now and can't complete the Transformation hence unable to add any more Transformation Tasks.

All I am trying to achieve is EXEC the SP using the DTS and export it to a CSV file.

Can someone help asap Please? I haven't changed anything at all, its just not letting me add another Transformation task properly because I can't see the columns to map anymore. However, the ones that I had added previously work fine.

Cheers.

5fifty5
Starting Member

35 Posts

Posted - 01/22/2010 :  04:52:31  Show Profile  Reply with Quote
Can anybody help??

One thing I forgot to mention was that the SELECT statement in the SP is within a IF .. ELSE IF block which I can't get rid of...
Go to Top of Page

russell
Pyro-ma-ni-yak

USA
5071 Posts

Posted - 01/22/2010 :  07:38:35  Show Profile  Visit russell's Homepage  Reply with Quote
create the temp table. map the columns. drop the temp table.

take the create #temp part, put it in its own Execute T-SQL task. run that task. now you can do your mappings.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.03 seconds. Powered By: Snitz Forums 2000