CODEWITHSUNDEEP
ssisscriptingtaskprecompile
Jaya
Jaya

Reputation:

Programmatically compile a Script Task in SSIS

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

Upvotes: 1

Views: 3257

Answers (2)

Glenn M
Glenn M

Reputation: 455

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.

Upvotes: 0

Andy Leonard
Andy Leonard

Reputation: 624

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

Upvotes: 1

Related Questions