Very Basic Overview Of SSIS scripting needed

[thendrickson]

I am just starting with SSIS and need some basic information to guide me the right direction.

I need to process some information from the database and create flat files or Excel speedsheets according to different criteria.

I have a VB 6 application which contains the code to create these files. The current process is kicked off from a menu.
I have pulled the relevent parts from the VB6 app and converted that code to VB.net.

Can I take my .net code and place it within a scripting task? There are a number of classes and different modules involved. The code is fairly complex.

Or should I create a .NET exe with no forms to run in the background? Or should I do a console application and run it hidden Can I even do either? My .Net experience is somewhat limited.

Thanks

 

[RiverGuy]

So you're migrating a VB6 data processing app to SSIS? If you're wanting to use SSIS, it would make more sense to use the built-in SSIS tools to do the data processing instead of using it as just a container to call an executable. SSIS can export to flat files and to Excel. If you want to keep your logic as an executable, you probably don't even need SSIS to call it--just set up a job on the SQL server to call the .exe.

 

[thendrickson]

Thanks, but I was trying to simplify the question to only ask for what I am bogged down with.

This whole SSIS package will be a bit more complex than just the export of data. Only if the first 2 tasks in The SSIS succeed will the data be exported

Basically step 1
step 2
step 3 Process data to files
step 4 determine if I e-mail or FTP the file or save to hard drive
step 5 e-mail, FTP or write to file

Any failure at any step will e-mail failure notices.

I understand how to use SSIS for everything except the processing the data part.


And I prefer to not use an .exe if I can use a scripting task instead since I want to be able to edit code without needing to compile a new exe if possible.

So my basic question can I add each module and class from my existing code to my SSIS project and execute from a scripting task? Or do I need to add all the code to a scripting task?

Only if that is not possible, would I need to use an exe.

I have done a lot of VB6 and a fair amount of DTS but SSIS and .Net are different and I am uncertain of the basic points of adding existing .net code to a scripting task or creating a .NET exe with no forms.

If all else fails I can rewrite the code into the scripting task but I am hoping to avoid that since time is short.

I know this is probably a bit of a stupid question, but I seem to find all kinds of information other than the very very basics

Thanks