thanks satya, I will no doubt have questions later on the specifics of how to do it since i am pretty much a novice when it comes to BIDS. But the...
Would I be able to use the export import wizard to do that ..or do i have to go thru the Business Intelligence Development Studio?
I need to run a daily job that will export data from SQL Server to an Excel File. How do i name the destination file dynamically? the file path...
Separate names with a comma.