SSIS Scripts

Question

SSIS Scripts

Harold E. Collins Jr.

Grasshopper

Points: 15
More actions
August 3, 2007 at 6:11 am

#118145

I use a 2000 DTS package to download a zip file, unzip it (It contains a delimited text file), open the file and seperate into different tables.
Basically I create the package from vb .net from within a running windows service.
I want to update the code to use the new SSIS features, but I used DTS Script Tasks a lot, for unzipping text files and such, but I cant figure out how to create a script task in SSIS because it doesnt use vbscript of jscript and it the task is a precompiled object.
Does anyone know of a way to progmatically create custom script tasks????

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Crispin Proctor SSCoach Points: 18161 More actions · Answer 1

There are many articles on custom components on the net. You options would be to use a script task and VB.NET to unzip stuff. Again, there are more than enough articles around.

Another, better option, would be to get a SSIS compression task. There are a number of version around which work. Some free, some cheap.

See http://www.cozyroc.com/products.html for an example.

Stay away from the ActiveX task in SSIS. It is end of life. Rather use the Script Task.

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Harold E. Collins Jr. Grasshopper Points: 15 More actions · Answer 2

That is my intention to stay away from the ActiveX task.

What I am trying to figure out is if I can save custom scripts and call them progmatically as a script task.

I cant seem to find a way to call them progmatically. I can create them with the designer and use them in the SSIS Package. But I want to create them, save them, and then call them in a ssis package that is built on the fly progmatically.

Crispin Proctor SSCoach Points: 18161 More actions · Answer 3

I am not aware that you can do that.

You best bet is then to create a custom component and call that.

Or, create a DLL and use that from withing the VB?

Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!

Harold E. Collins Jr. Grasshopper Points: 15 More actions · Answer 4

That is what I was afraid of

Thanks for your help.

H.E.

tymberwyld SSCertifiable Points: 7810 More actions · Answer 5

This is not supported but you could write a Custom Component which can run your Script files. There are plenty of articles for "Compiling" .NET Code on the fly or if you're using VBScript then you would not compile but use the ActiveX Script Component to run your scripts (which would require writing an Interop layer between .NET and the Script component).