Excel File(CSV) Automatic Creation with SSIS (SQL Server 2005)
$30-5000 USD
Đã hủy
Đã đăng vào gần 15 năm trước
$30-5000 USD
Thanh toán khi bàn giao
I have an SQL query and I need to automatically create an Excel file from the results of that query on a daily basis with SSIS (SQL Server 2005)
## Deliverables
* * *This broadcast message was sent to all bidders on Saturday Jun 20, 2009 1:00:42 AM:
Still didnt choose an SSIS expert Can you do the job ?
* * *This broadcast message was sent to all bidders on Sunday Jun 21, 2009 11:58:32 PM:
Hi. I will want to create as well a txt file and xml file that will contain same data as the excel. Can you do that?
* * *This broadcast message was sent to all bidders on Monday Jun 22, 2009 1:08:10 PM:
A few changes in the scope. I will need 4 files - you can offer just for some or them or for all. txt,excel(xsl),csv,xml 1. In the current txt file, there is a problem with the conversion from Ansi 1252 to 1255 in the text file of some columns 2. The excel file should be overwritten and have the same headers all the time. It is currently produced but is not overwritten. 3. The xml file should be in Atom 2.0 or RSS 2.0 format 4. The CSV file should have a ~ delimiter I want to have a price for all the 4 files and for each one. The txt file and excel file are already there and just need small fixes. The csv and xml still need to be made. Currently the creation of the files are done with a scheduler and batch. We can have a remote access while I am on the server as well.