Script Task to open database connection and write to it

Question

Script Task to open database connection and write to it

Armani

SSC Rookie

Points: 34
More actions
May 18, 2009 at 7:37 am

#131678

I am looking for example on how to open database conn and write to it in Script Task.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Tim Mitchell SSCoach Points: 15685 More actions · Answer 1

For a simple data flow operation, you don't need to script it; you can use the OleDB Destination to write data to your SQL Server database.

hth,

Tim

Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices

Armani SSC Rookie Points: 34 More actions · Answer 2

I have script task that does data validation and manipulation using custom dll's and i need to store data into database after data validation. It has to be in script task. I just need to insert data into database in Script Task.

Paul_J Hall of Fame Points: 3698 More actions · Answer 3

One option is to:

1. Create an ADO.NET Connection Manager named "MySQLConnMgr"

2. In your Script Task have something like:

Dim oConn As System.Data.SqlClient.SqlConnection = DirectCast(Dts.Connections("MySQLConnMgr").AcquireConnection(Nothing), System.Data.SqlClient.SqlConnection)

'TODO: Use the connection

If oConn IsNot Nothing Then

Dts.Connections("MySQLConnMgr").ReleaseConnection(Nothing)

End If

Script Task to open database connection and write to it

Cookies on SQLServerCentral