SSIS传输数据库任务缺少传输文件信息 [英] SSIS Transfer Database Task missing transfer file information

问题描述

我是SSIS的新手，我正在尝试创建一个自动迁移60多个数据库的软件包。所有内容似乎都是有序的，但转移数据库任务失败了


传输文件信息，，，缺少文件名。


它也为文件夹部分提供了相同的错误，并说它找不到文件\在源数据库foo中。


这些东西正在表达式中填充。这就像任务没有识别表达式一样。

I''m an SSIS newbie and I''m trying to create a package to automate the migration of 60+ databases. Everything appears to be in order but the Transfer Database Task fails with

The transfer file information "","","" is missing the filename.

It also gives the same error for the folder part, and says it could not find the file"\" in the source database "foo".

These things are being populated in expressions. It''s like the task isn''t recognizing the expressions.

推荐答案

我们需要知道表达式是如何填充的以及它们是如何被填充的在任务中使用。

We would need to know how the expressions are being populated and how they''re being used in the task.

SourceDatabase的表达式来自变量@ [User :: DbName]，SourceDatabaseFiles正在填充以下表达式：

The expression for the SourceDatabase is coming from a variable @[User::DbName] and the SourceDatabaseFiles are being populated with the following expression:

展开 | 选择 | Wrap | 行号

是否将表达式设置为true？

Is evaluate as expression set to true?

这篇关于SSIS传输数据库任务缺少传输文件信息的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！