Handling repeating groups of data

#1

I have an incoming text file (comma delimited) with repeating groups (arrays)
of data which I wish to load to a single table. Is there a "built-in"
mechanism for handling this situation or do I need to write code within the
package? Assuming the later, any code sample would be greatly appreciated!

TIA,
Chris.

#2

You might then be able to adapt this

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)

Allan

"Chris W" <ChrisW (AT) discussions (DOT) microsoft.com> wrote

Quote:

I have an incoming text file (comma delimited) with repeating groups
(arrays)
of data which I wish to load to a single table. Is there a "built-in"
mechanism for handling this situation or do I need to write code within
the
package? Assuming the later, any code sample would be greatly
appreciated!

TIA,
Chris.

#3

Looks like this will help. Thanks for your response!

"Allan Mitchell" wrote:

Quote:

You might then be able to adapt this

Processing The Same Row More Than Once
(http://www.sqldts.com/default.aspx?266)

Allan

"Chris W" <ChrisW (AT) discussions (DOT) microsoft.com> wrote in message
news

B7D317C-F11B-4153-A939-3DD7A08CF43F (AT) microsoft (DOT) com:

I have an incoming text file (comma delimited) with repeating groups
(arrays)
of data which I wish to load to a single table. Is there a "built-in"
mechanism for handling this situation or do I need to write code within
the
package? Assuming the later, any code sample would be greatly
appreciated!

TIA,
Chris.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Handling repeating groups of data

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Handling repeating groups of data - 09-07-2005 , 09:05 AM

Re: Handling repeating groups of data - 09-07-2005 , 01:33 PM

Re: Handling repeating groups of data - 09-07-2005 , 03:29 PM