MS SQL 2005 SSIS包默认值 [英] MS SQL 2005 SSIS package default values

问题描述

我有一个运行了好几年的SSIS程序包.它将一些数据从文本文件导入到永久性临时表中.现在，我需要将数据放入不是来自文本文件的临时表的某些列中.我无法更改文本文件，因为它来自另一个系统.但是我需要在运行SSIS包时将导入日期/时间和另一个值放入临时表中.当我运行导入向导来创建程序包时，似乎不可能将不是文本文件中的数据放入表中.我尝试将另一列添加到列表中，但是它坚持要与文本文件中的内容进行匹配，并且不允许我继续.因此，我认为唯一的方法是在bus中编辑程序包.英特尔.开发.工作室.从那里，我可以添加所需的值.我在正确的轨道上吗?还是有另一种方法?

I''ve got an SSIS package that''s been running for years just fine. It imports some data into a permanent temp table from text files. Now, I need to put data into some columns in the temp table that doesn''t come from the text file. I CANNOT alter the text file as it comes from another system. But I need to put the import date/time and another value into the temp table at the time the SSIS package is run. When I run the import wizard to create the package, there doesn''t seem to be the possibility of putting data into the table that doesnt come from the text file. I tried adding another column to the list but it insists on matching it up wiht something from the text file and won''t allow me to continue. So I''m thinking the only way to do this is to edit the package in bus. intel. dev. studio. From there I could add the values I need. Am I on the right track? Or is there another way to do this?

推荐答案

要么创建一个新的脚本任务，在导入数据后将所需的数据追加到数据库中，要么承担该任务执行导入的调用将调用存储的proc，并让存储的proc附加附加数据.

Either create a new script task that appends the desired data to the database after the data is imported, or assuming the task that performs the import calls a stored proc, have the stored proc append the additional data.

这篇关于MS SQL 2005 SSIS包默认值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！