Post reply

Export SQL query from Execute SQL in SSIS

  • September 30, 2010 at 4:01 am

    #239071

    Hi,

    I am new to SSIS and I was wondering if it was possible to export a SQL query using Execute SQL query to an excel or text file.

    All i need to do is export the results of

    SELECT AccountID, BranchID, DepartmentID, ClientName, GroupNumber, PAREA, ProductCode, ProductDescription, SearchType, Quantity, ClientType, Filler,

    VRM, VIN, [Transaction Date], TransactionValue

    FROM MangoletsiHoldings

    WHERE (SearchType = '4') AND ([Transaction Date] BETWEEN '01/08/2010 00:00' AND '05/08/2010 00:00')

    to an excel or txt file, any help is much appreciated.

    Thanks.

    Ant

  • September 30, 2010 at 6:13 am

    #1229544

    Don't use the execute query, create a data flow and use your query as a source and your file as an output (flat file or excel).

  • September 30, 2010 at 6:17 am

    #1229545

    Hi,

    Thank you for that,

    i've had tried that, that works fine.

    The only think is that, is there anyway to update the SQL query dynamically, for instance update the .sql file in SSMS and then this runs in OLE DB source?

    Or will I have to go an manually update the statment in SSIS?

    Cheers

Viewing 3 posts - 1 through 2 (of 2 total)

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