如何将 SSIS 包中的变量设置为文本文件中的一行？
我正在创建一个 SSIS 包（使用 VS 2008），它将运行各种存储过程、创建文件并将它们放在可以上传到另一个系统的位置。该软件包将每月运行一次，并且由于每次运行时都会创建大约 9 个文件，因此我希望该软件包获取上个月的文件并将其存档。此外，这些文件的名称将包含它们的运行日期。由于我无法控制这些文件的运行，因此我不能假设它们会在每个月的同一天运行。
我认为最好的方法是创建一个名为 lastrundate 的变量，并用文本文件中的数据填充它，该文本文件每次运行包时都会更新上次运行日期。问题是我无法弄清楚如何将用户变量的值设置为文本文件中的信息。
另外，我应该注意，我必须使用 C#，因为 Visual Studio 的设置不允许我将语言更改为 VB，而且我从未使用过 C#，所以我处于完全劣势。
I am creating an SSIS package (using VS 2008) that will run various stored procedures, create files and place them where they can be uploaded into another system. The package will run monthly and, since it will create around 9 files each time it is run, I would like to have the package take the previous month's files and archive them. Also, these files will have names that will include the date they were run. Since I will have no control on the running of these files, I cannot assume that they will run on the same day each month.
I thought the best way to do this would be to create a variable called lastrundate populate it with data from a text file that updates with the last run date everytime the package it run. The problem is that I cannot figure out how to set the value of my user variable to the information in the text file.
Also, I should note that I have to use C#, as the set up for Visual Studio will not allow me to change the language to VB, and I have never worked with C#, so I am at a total disadvantage.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
如果每次进程运行时都归档文件，您可能会考虑通过循环“默认”目录中的文件来启动该过程，将它们移动到以日期（日期/时间）命名的“归档”目录（命名为基于包运行的日期/时间）。
这种方法意味着您不需要从文件名中解析出日期，但如果某些文件将被存档而其他文件将被重新使用，那么它实际上可能无法满足您的需求。
If you're archiving the files each time the process runs, you might consider starting the procedure by looping through the files in the 'default' directory, moving them to a date(date/time)-named 'archive' directory (with naming based on the date/time the package is run).
This approach means you don't need to parse the date out of the file name, but if some of the files will be archived and others will be re-used, it may not actually meet your needs.