Export SQL query from Execute SQL in SSIS
Posted By: Posted Date: September 30, 2010
Points: 0 Category :Sql Server
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
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.
View Complete Post