March 7, 2008 at 6:39 am
Hello,
My IT manager had me write a routine in .net for reading in a text file and parse it. Eventually the parsed data will go to a table.
Now he wants me to figure out SSIS and put the routine into it and call a stored procedure to save it for each parsed record.
I've been going through some tutorials to learn about SSIS (still kind of lost) but can I run code I wrote in VB.net in SSIS? Is this even possible?
Anyone know of a tutorial for this type of project anywhere?
Thanks
Warren
March 10, 2008 at 3:35 pm
Is the routine in a DLL or does he just want you to copy code into SSIS?
Parsing a text file is a piece of cake in SSIS. On the Control FLow tab create a Data Flow Task. IN the Data Flow Task (double click to open it) create a Flat File Source then if you need to do transforms on the data using the routine, use a Script component and copy the routine into the script, then put the sql destination on and connect the 2.
You may not even need the bosses routine:cool:
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply