开发者

SSIS: Using a View for a Sql Server Package Configuration

开发者 https://www.devze.com 2023-01-03 17:10 出处:网络
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.

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

精彩评论

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