Hello Experts,
I am new to the DTS (so please excuse me if the question is very silly) and so far it is looking like a very handy tool.
In one of my projects I have to import some data from an excel spreadsheet that contain company details and contacts on the specific company. Due to the way that the database is structured the Customer and Contacts are too different tables (as it should be). My question to you is this:
How can I get the identity of the Customer and then use it as a foreign key Contacts table without using SQL task? Is it possible?
Thank you in advance,
Camel
I am new to the DTS (so please excuse me if the question is very silly) and so far it is looking like a very handy tool.
In one of my projects I have to import some data from an excel spreadsheet that contain company details and contacts on the specific company. Due to the way that the database is structured the Customer and Contacts are too different tables (as it should be). My question to you is this:
How can I get the identity of the Customer and then use it as a foreign key Contacts table without using SQL task? Is it possible?
Thank you in advance,
Camel