Building A Test Package In SQL Dev That Writes To A Smartsheet

Benjamin O'Leary

Hello,

I am attempting to build a package in SQL Dev that takes data from a table in SQL Server and inserts it into a Smartsheet. For example, I have three lines of data in a table in SQL Server that I need to have added to a Smartsheet table.

How do I go about creating a package that does this? I have never built a package in SQL Dev before so I am relatively new to all of this.

Genevieve P.

Hi @Benjamin O'Leary

I don't have experience with SQL Dev; I would recommend posting in the SQL Developer Community for help with building this, see: SQL Developer - Oracle Communities and SQL Developer Documentation for more information.

I hope that helps!

Genevieve

Genevieve P.

Hi @Benjamin O'Leary

I don't have experience with SQL Dev; I would recommend posting in the SQL Developer Community for help with building this, see: SQL Developer - Oracle Communities and SQL Developer Documentation for more information.

I hope that helps!

Genevieve

Sarah Brelage

@Benjamin O'Leary Have you had any luck? I have a team that would like to do the same thing - take data from an SQL table and import it into Smartsheet on a regular basis. I'm trying to do some research to see if it is even possible...

Andrée Starå

Hi @Sarah Brelage

I hope you're well and safe!

Have you explored using the Premium App, Data Shuttle?

Is that an option?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!