Multiple tables

[rac55]

Hi

I am trying to import an excel spreadsheet into a sql server database. The problem is I need the information in the spreadsheet to be imported into 3 different tables. I thought of transfering all details into a temporary table and then setting 3 triggers for each transfer of information. But this seems very inefficient. I know there should be an easier way to do this in dts.

Any help would be greatly appreciated

Thanks

 

[JayKusch]

Create your DTS package w/ the Source connection being your Excel spreadsheet and then have 3 Target connections, 1 for each one of the tables you need populated. Then create the 3 datapumps that exports the data from the Excel to each of the three tables respectively.

Thanks

J. Kusch

 

[rac55]

Thanks for replying...so I have 3 links or workflows coming from the source connections.
When you say target connections, do you just mean the OLE connection?

Thanks
Rachel

 

[JayKusch]

I mean the actual sql server server that your target tables reside on.

Thanks

J. Kusch