开发者

How to configure SSIS 2005 OLE DB data source component to use sql query from external file?

I am using OLE DB dat开发者_开发技巧a source component as a part of data flow task, but I would like to keep the sql query in an external file and not embedded in the task itself. Is there an easy way to accomplish this?


You could use a script task in your control flow to extract the sql query from the file and store it in a string variable. You could then use the variable as a source for you ole db data source component.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜