开发者

SSIS 2005 How to add a zip task?

I have a ssis 2005 project.

I have to add a 开发者_StackOverflowzipping task.ie, i have to zip a text file.

But i have to follow DB standards of the ORG. strictly.

1) No 3rd party software in the DB server.Not even resourec kit tools

2) No exe's in the DB server.

so i cant use(windows resource kit tools,7-zip, and a execute process task to invoke a c# exe.)

please suggest me a way to achieve zipping in ssis without compromising the DB standards.Any zip task is available as an addin to SSIS 2005?

Thanks

SNA


You could use a Script Task, and write code using the GZipStream class to compress the file.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜