Copy selected columns from source table to destination table
Hi,
I am playing around with TOS DI and finding my feet a little, it seems like a really good product.
What I am trying to do is copy all the columns apart from the identity column from one table to a renamed copy of the exact table in MS SQL Server.
In TOS my job I have a tMSSqlInput that is correctly configured to the DB and SQL query is good. This is connected to a tMap which in turn is connected to a tMSSqlOutput which is pointing at the destination table. What I am finding confusing is when I double click my tMap object to go into Map Editor there are no columns on either side, I was expecting as I had declared a source and destination table I would see these columns in there.
Obviously I have got my wires crossed. Can anyone point out where I am going wrong please.
Thanks
I edited the schema of the output table and removed the id field. It works great now. Thanks again Sabrina. I like this IDE but it is just a case of getting used to it.
Hi Dave,
Talend offers a rich set of online and instructor-led
training courses to speed your ramp-up time, deliver projects faster, and maximize your Talend investment.
Best regards
Sabrina
