sql server dts: ssis performance -- sql server dts

ssis performance

tomypow
10/18/2007 12:02:00 PM

sql server dts: Hi,
I'm the most newbie ever to SSIS.
I'm a sharepoint developper who need to migrate data each week from a client
submitted file to a Sharepoint list (i.e. to Sql Server 2005).
I'm here because for my volume of data (20,000 rows * 5 cols), i've been
suggested that SSIS was the way to go.
(ref: http://www.devx.com/dotnet/Article/35070/0/page/1)

Is it true?

Can SSIS perform this with efficiency?
(I mean within seconds, cause with the Sharepoint API, it's is extremely
slow, and not practical).

Having a look at the ref article, it seems to me that all the step (xml,...)
will take a long time.

Any pointer is appreciate.
thanks.

RE: ssis performance

Todd C
10/22/2007 1:11:02 PM

Hello Newbie:

Yes, SSIS can handle 20K rows. Of course, so much of performance depends on
hardware that nobody is going to give you an answer about how LONG that
should take.

Speaking from personal experience using a dual core laptop with 2Gig ram,
abd servers that were significaltly better, 20,000 rows shouldn't take more
than a minute and probably much less.

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.