ssis 写文件到数据库
Dim filename As String
Dim contents As Byte()
Dim conn As SqlConnection
Dim cmd As SqlCommand
filename = Dts.Variables("filename").Value.ToString()
contents = File.ReadAllBytes(filename)
Dim fileinfo As New FileInfo(filename)
Dim name As String = fileinfo.Name
conn = New SqlConnection("server=(server);database=dbname;UID=abc;PWD=efg;")
cmd = conn.CreateCommand()
cmd.CommandText = "insert into doc_file(id,filename,contents) values (newid(),@filename,@contents)"
cmd.Parameters.AddWithValue("@filename", name)
cmd.Parameters.AddWithValue("@contents", contents)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()这段代码是放到脚本任务中，创建一个叫做filename 的变量。
Dim contents As Byte()
Dim conn As SqlConnection
Dim cmd As SqlCommand
filename = Dts.Variables("filename").Value.ToString()
contents = File.ReadAllBytes(filename)
Dim fileinfo As New FileInfo(filename)
Dim name As String = fileinfo.Name
conn = New SqlConnection("server=(server);database=dbname;UID=abc;PWD=efg;")
cmd = conn.CreateCommand()
cmd.CommandText = "insert into doc_file(id,filename,contents) values (newid(),@filename,@contents)"
cmd.Parameters.AddWithValue("@filename", name)
cmd.Parameters.AddWithValue("@contents", contents)
conn.Open()
cmd.ExecuteNonQuery()
conn.Close()这段代码是放到脚本任务中，创建一个叫做filename 的变量。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16436858/viewspace-620545/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
SQL Server 数据库同步配置
请登录后发表评论
登录
全部评论
