tDBLastInsertId - Empty component list

[Anonymous]

Hi.  So I'm trying to use tDBLastInsertId with SQLServer.  When I drag this component into my project and after I select SQL Server as the target DB to use, the component list is always blank; it doesn't see the two existing SQL Server Db Connections I have.  If I drag an existing connection onto my job, I don't see  tDBLastInsertId as a suggested component option, but I see everything else (e.g. tMSSqlInput, tMSSqlOutput, etc) in the drop down.  Even if I connect a tMSSqlOutput (using one of the aforementioned connections) to a tDBLastInsertId, I still don't see any component list being generated.

Do I need to somehow associate the tDBLastInsertId that is in my component palette to SQLServer to be able to see the valid connections in the component list?   Thanks!

[vapukov]

Hi,

could you share your design and what steps you do?

because it shows all connections already presented in the job (not in a repository)

[Anonymous]

Hi, thanks for getting back to me.  So, I built a silly little job with my existing connections to illustrate my issue.

When I use my existing SQLServer connection:

To designate the table I'd like to use:

And then I build my sample job:

I see:

Screen Shot 2019-04-18 at 10.35.21 AM.png

[vapukov · Accepted solution]

Hi,

thank you, this confirms my guessing

as I mentioned before - you must have tMSSQLConnection component on your job screen, but not in the repository

in your tDBInput component you have also checkbox - use an existing connection, same for tDBOutput

so, you define connection once and use it for all components

https://help.talend.com/reader/iYcvdknuprDzYycT3WRU8w/tR5sAkr~80fPFhrYZNlNWQ