将静态数据添加到Microsoft Report Builder生成的CSV
我正在为我的雇主实施新服务，并且它通过CSV文件SFTP“将数据sftp”用于手表文件夹。
我打算使用SQL Server上的报告服务并报告订阅以使其定期运行。
生产CSV非常容易，但是CSV需要具有一组逗号分隔的行，这些行向目标系统提供了有关已包含的数据的配置和指令，我看不到如何在报告中进行此标头钻头。我相信CSV渲染器会忽略视觉编辑器的标头块。
文件标头是 static ，如下（有点缩小）
__BEGIN_CONFIG__,,,,,,,,,,
VERSION,2,,,,,,,,,,
LOOKUP_COLUMNS,LABEL-ID,,,,,,,,,,
IMPORT_COLUMNS,A,B,C,D,E,F,G,H,I,J,K
,,,,,,,,,,,,
__BEGIN_DATA__,,,,,,,,,,,
CSV数据放在__ begin_data __行下，
我已经研究了更改CSV渲染器配置的行，以查看是否有一个指令包含标头文件，但我看不到此。
感谢任何帮助。
I am implementing a new service for my employer and it consumes data through CSV files SFTP'ed to a watch folder.
I am planning to do this using Report Services on SQL Server and report subscriptions to make it run periodically.
Producing the CSV is dead easy, however the CSV needs to have a set of comma delimited rows that provide configuration and instruction to the target system about the included data prepended to the generated CSV, and I cannot see how to do this header bit in report builder as I beleive that the CSV Renderer ignores the header block from the visual editor..
file header is static looks as follows (a bit cut down)
__BEGIN_CONFIG__,,,,,,,,,,
VERSION,2,,,,,,,,,,
LOOKUP_COLUMNS,LABEL-ID,,,,,,,,,,
IMPORT_COLUMNS,A,B,C,D,E,F,G,H,I,J,K
,,,,,,,,,,,,
__BEGIN_DATA__,,,,,,,,,,,
CSV data is placed under the __BEGIN_DATA__ row
I have investigated altering the CSV renderer config to see if there is a directive to include a header file but I cannot see this.
I would appreciate any assistance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
看来这是直接从报告服务器中直接出现的，当然不是我发现的
It appears that this is not possible directly out of Report Server, certainly not that I have discovered