Post reply

Using SP as Data Transform Source gives no source columns

  • December 12, 2006 at 11:47 am

    #72205

    I'm trying to extract the results of a stored procedure to a CSV file. I set up a SQL Data Source and a CSV (Text) output destination. I set up a Data Transformation task between the two. I open the properties of the Data Transform and enter "Exec dbo.getresultsincr" into the SQL Query of the Source tab. I go to the Destination tab and I have no option to create the columns from the Source. The button is there but it doesn't do anything.

    Does anyone know how to make this work? I need to automate this process and DTS seemed the most likely avenue, but this is making me .

    TIA

     

  • December 12, 2006 at 12:55 pm

    #677600

    What works for me is to click the 'Populate from Source' button, then the 'Execute' button.

    Greg

    Greg

  • December 12, 2006 at 1:00 pm

    #677607

    >What works for me is to click the 'Populate from Source' button, then the >'Execute' button.

     

    Original post: "The button is there but it doesn't do anything. "

    I click Populate from Source and nothing happens...

     

  • December 12, 2006 at 2:19 pm

    #677625

    Take a look..

    http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=328008

     

    MohammedU
    Microsoft SQL Server MVP

  • December 13, 2006 at 6:27 am

    #677741

    So in order to use a Stored Procedure as the Source for a Data Transform I have to code in my SQL Query to create a temp table with all the variables from the SP, then execute the SP to insert the data into the table, then select * from the table? I can't believe you have to jump through that many hoops just to use an SP as a data source!!! There has to be a simpler way (maybe wait for SS2005 & SSIS...)

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply