Programmatically compile a Script Task in SSIS

Question

Hi, For my requirement I need to write Script task from One SSIS package to another. As my server is 64bit machine, when I execute the overriden SSIS package, it throws the error "Binary Script not found". Hence I need to compile the script programmatically in the Parent SSIS package and put the binary code into the another one. I dont know how to compile the Script programmatically. Let me know how to do that

Answer 1

Hi Jaya,

I don't think you can do this with SSIS. If there's a way to accomplish this using a Parent Package / Child Package architecture, I'm unaware of it.

You can get more flexibility creating packages dynamically in .Net. Although I haven't tried to dynamically compile script task code.

I'm curious: Why not copy the code out of the parent package and paste it into a child package?

:{> Andy

Answer 2

So you need to somehow programatically execute a (Debug>Build). This typically gets around the problem of binary not being found, when you do it manually in VS. Doesn't strike me as possible at runtime though.

Answer 3

This is exactly you should be using.

With BI xPress you can compile scripts in 2 ways... From BIDS and During deployment process

http://www.pragmaticworks.com/help/bixpress/scr/Compile%20Scripts.htm

for more info visit

www.pragmaticworks.com/products/business-intelligence/bixpress/