Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Parsing through SSIS vs using C#


Parsing through SSIS vs using C#

Author
Message
rjv_rnjn
rjv_rnjn
Mr or Mrs. 500
Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)Mr or Mrs. 500 (515 reputation)

Group: General Forum Members
Points: 515 Visits: 430
Versions --> SQL 2005 & .Net 3.5 (C#)
Although I am almost done with my ETL (parse & load) development but during the code review one of the options suggested was why don't do all the parse and load in C# instead of splitting it between SSIS & C#. What I am currently doing is parsing the files in C#, holding data in DataSets and calling the library from SSIS to parse the set of files. The dataset is then used in SSIS to upload the data to tables in SQL Server. There are quite a few other decision making things that SSIS does, but nothing that can not be achieved in C#, fairly easily.

That option sounded quite good to me, and being a .Net developer I would lean more towards C# parsing. So I was thinking is there some basic question you should ask yourself before committing to how to parse your files? Like if you are going to use C# and call the C# code from SSIS, you better use C# for the entire thing instead of splitting it into two things. And then use SSIS just to call the C# parser at specified interval.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search