Forcing an error on a row in SSIS

#11

On Aug 22, 1:29*pm, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

When you extract the data from the CSV, is this date info being sent into
the pipeline as a DATE, or string?

It's set in the CSV file definition as a string if that's what you
mean.

Quote:

You may need to keep it as a string so you can examine the first four
characters. Use multipe Conditional Split Transforms to break up the datato
different pipes and massage and 'fix' it accordingly. In the end do a big
UNION Transform to pull it back together.

This was exactly what I started thinking through in my head. I was
actually playing with the conditional split when I got back to
checking the newsgroup. Great minds and all that

Thanks for the response and the suggestion!

-Tom.

#12

On Aug 22, 1:29*pm, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

When you extract the data from the CSV, is this date info being sent into
the pipeline as a DATE, or string?

It's set in the CSV file definition as a string if that's what you
mean.

Quote:

You may need to keep it as a string so you can examine the first four
characters. Use multipe Conditional Split Transforms to break up the datato
different pipes and massage and 'fix' it accordingly. In the end do a big
UNION Transform to pull it back together.

This was exactly what I started thinking through in my head. I was
actually playing with the conditional split when I got back to
checking the newsgroup. Great minds and all that

Thanks for the response and the suggestion!

-Tom.

#13

On Aug 22, 1:29*pm, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

When you extract the data from the CSV, is this date info being sent into
the pipeline as a DATE, or string?

It's set in the CSV file definition as a string if that's what you
mean.

Quote:

You may need to keep it as a string so you can examine the first four
characters. Use multipe Conditional Split Transforms to break up the datato
different pipes and massage and 'fix' it accordingly. In the end do a big
UNION Transform to pull it back together.

This was exactly what I started thinking through in my head. I was
actually playing with the conditional split when I got back to
checking the newsgroup. Great minds and all that

Thanks for the response and the suggestion!

-Tom.

#14

On Aug 22, 1:29*pm, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

When you extract the data from the CSV, is this date info being sent into
the pipeline as a DATE, or string?

It's set in the CSV file definition as a string if that's what you
mean.

Quote:

You may need to keep it as a string so you can examine the first four
characters. Use multipe Conditional Split Transforms to break up the datato
different pipes and massage and 'fix' it accordingly. In the end do a big
UNION Transform to pull it back together.

This was exactly what I started thinking through in my head. I was
actually playing with the conditional split when I got back to
checking the newsgroup. Great minds and all that

Thanks for the response and the suggestion!

-Tom.

#15

On Aug 22, 1:29*pm, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

When you extract the data from the CSV, is this date info being sent into
the pipeline as a DATE, or string?

It's set in the CSV file definition as a string if that's what you
mean.

Quote:

You may need to keep it as a string so you can examine the first four
characters. Use multipe Conditional Split Transforms to break up the datato
different pipes and massage and 'fix' it accordingly. In the end do a big
UNION Transform to pull it back together.

This was exactly what I started thinking through in my head. I was
actually playing with the conditional split when I got back to
checking the newsgroup. Great minds and all that

Thanks for the response and the suggestion!

-Tom.

#16

On Aug 22, 1:29*pm, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

When you extract the data from the CSV, is this date info being sent into
the pipeline as a DATE, or string?

It's set in the CSV file definition as a string if that's what you
mean.

Quote:

You may need to keep it as a string so you can examine the first four
characters. Use multipe Conditional Split Transforms to break up the datato
different pipes and massage and 'fix' it accordingly. In the end do a big
UNION Transform to pull it back together.

This was exactly what I started thinking through in my head. I was
actually playing with the conditional split when I got back to
checking the newsgroup. Great minds and all that

Thanks for the response and the suggestion!

-Tom.

#17

On Aug 22, 1:29*pm, Todd C <To... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

When you extract the data from the CSV, is this date info being sent into
the pipeline as a DATE, or string?

It's set in the CSV file definition as a string if that's what you
mean.

Quote:

You may need to keep it as a string so you can examine the first four
characters. Use multipe Conditional Split Transforms to break up the datato
different pipes and massage and 'fix' it accordingly. In the end do a big
UNION Transform to pull it back together.

This was exactly what I started thinking through in my head. I was
actually playing with the conditional split when I got back to
checking the newsgroup. Great minds and all that

Thanks for the response and the suggestion!

-Tom.

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

Forcing an error on a row in SSIS

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

Re: Forcing an error on a row in SSIS - 08-22-2008 , 01:06 PM

Re: Forcing an error on a row in SSIS - 08-22-2008 , 01:06 PM

Re: Forcing an error on a row in SSIS - 08-22-2008 , 01:06 PM

Re: Forcing an error on a row in SSIS - 08-22-2008 , 01:06 PM

Re: Forcing an error on a row in SSIS - 08-22-2008 , 01:06 PM

Re: Forcing an error on a row in SSIS - 08-22-2008 , 01:06 PM

Re: Forcing an error on a row in SSIS - 08-22-2008 , 01:06 PM