开发者

SSIS: Using a View for a Sql Server Package Configuration

I have set up a View as the source for a Sql Server Package Configuration that has the same name and columns as the default table.

It works in design-time but the package fails to load the configurations claiming the view is an Invalid Object at run-time. This seems like it should work because the view appears in the drop-down in the editor. Is there something I'm missing or is it impossible to use a View as开发者_开发知识库 the source of the package configuration?


Figured this one out. Just had to cast all of the columns to nvarchar(255).

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜