A lot Of Questions!!!

Good Morning..

i have started developing on DTS recently. and i have a few question about "How-To" issues.

Hope you guys can help

1) I noticed, whenever i want to "redirect row" whenever an error happen, i need to set my AccessMode to OpenRowSet... This mode as i noticed, cant be used when i am tranferring data into a sql table which has primary key set

e.g. Ms Access which has identity -> SQL table with PK set

Is there anyway, to capture the row error in my situation?

2) Another question is, in a data flow... can i have a source which has multiple output arrow.

Sorry for the inconvenince,Thank you in advance

I can hurry up and answer #2 for you. Place your output of the source into a multitask transformation. You'll get as many outputs as you want then.

Question though... Are you using the old DTS, or are you using SQL Server Integration Services?|||

Hi Phil thanks for the fast reply

I am using SSIS in SQL 2005....

For the first question...i have found a workaround...

In the destination table which has primary key and auto increment set to yes.. Before tranferring data into that particular table set the auto increment to "no"... With that we can "return row" as error output.....

By the way Phil...i cant c any multitask trnaformation in my data flow toolbox, all i c is a multicast.. are u referring to old DTS..

Thanks a lot guys ...

|||

I think Phill meant 'Multicast' transformation; it would privide n inputs out of a single output

Rafael Salas

|||

Rafael Salas wrote:

I think Phill meant 'Multicast' transformation; it would privide n inputs out of a single output

Rafael Salas

Yep, "multicast". Yesterday was not a good typing day for me!