开发者

SSIS 2005 How to add a zip task?

开发者 https://www.devze.com 2023-01-03 18:03 出处:网络
I have a ssis 2005 project. I have to add a 开发者_StackOverflowzipping task.ie, i have to zip a text file.

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

上一篇:

:下一篇

精彩评论

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

关注公众号