Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask Namespace

Question

no examples are provided in the BOL for much of this namespace.  this is unacceptable for me.

how can i get examples for the entire namespace?

---

Duane Douglas, MCAD | http://www.ssisbi.com | Please mark the post(s) that answered your question.

Answer 1

Duane,

How about this link: http://msdn.microsoft.com/en-us/library/ms141003.aspx

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012

Answer 2

Duane,

How about this link: http://msdn.microsoft.com/en-us/library/ms141003.aspx

---

Kalman Toth, SQL Server 2008 Training, SSAS, SSIS, SSRS, BI: www.SQLUSA.com

thanks, but i was referring to the api to build packages programmatically.

can anyone assist me?

---

Duane Douglas, MCAD | http://www.ssisbi.com | Please mark the post(s) that answered your question.

Answer 3

over 200 views and not a single reply from microsoft.

what's wrong with this picture?

---

Duane Douglas, MCAD | http://www.ssisbi.com | Please mark the post(s) that answered your question.

Answer 4

The follwoing article on Sqlis.com provides code examples that cover adding the Execute SQL Task, returning a single value with a result set, and parameter mapping for SQL statements.  And, you can download the code from the web site.

"Creating packages in code -- Execute SQL Task"
http://www.sqlis.com/post/Execute-SQL-Task-in-Code.aspx

Answer 5

The follwoing article on Sqlis.com provides code examples that cover adding the Execute SQL Task, returning a single value with a result set, and parameter mapping for SQL statements.  And, you can download the code from the web site.

"Creating packages in code -- Execute SQL Task"
http://www.sqlis.com/post/Execute-SQL-Task-in-Code.aspx

i saw this link before i created this thread.  it didn't help me resolve my issue.

i wonder how the example in the link could be created without examples from microsoft.

i need examples from microsoft, not third-party developers.

---

Duane Douglas, MCAD | http://www.ssisbi.com | Please mark the post(s) that answered your question.

Answer 6

i submitted feedback to sql server connect requesting code examples: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=468072

please feel free to vote on this issue.

---

Duane Douglas, MCAD | http://www.ssisbi.com | Please mark the post(s) that answered your question.