Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ostinoh
Yak Posting Veteran
66 Posts |
 Posted - 2012-07-13 : 14:20:16
|
Hello - I'm in the process of creating an SSIS package that will import its data into two different tables.My source is an Excel Worksheet flowing into a Data Conversion then out too two OLE DB Destinations which I'll call Table A and Table B.I need to split the insert where only some of data goes into Table A and the other data goes into Table B.I'e tried but keep getting the data inserted into Table A and Table B is getting the errors Data Conversion Error output[SSIS.Pipeline] Warning: The output column "Copy of Version" (306) on output "Data Conversion Output" (94) and component "Data Conversion 0 - 0" (92) is not subsequently used in the Data Flow task. Removing this unused output column can increase Data Flow task performance. Regards,DO |
|
|
|
|
|
SSIS Excel Source instered into two tables?