SQL Server Forums - Exporting To Excel: SP contains #Temp table

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

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

Topic

5fifty5
Starting Member

35 Posts

Posted - 01/21/2010 : 05:53:56

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

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...

russell
Pyro-ma-ni-yak

USA
4967 Posts

Posted - 01/22/2010 : 07:38:35

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.

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.06 seconds.