vb.net DTS interaction
I have created a tds package that I wanted to be called from a web form application (ASP.NET)
Here is the code.
Dim pack As New DTS.PackageClass
pack.LoadFromSQLServer("mtfs012", "bgtest", "test", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , , , , "CSV_Importer", )
pack.Connections.Item(3).ConnectionProperties.Item (1).Value = fileName
pack = Nothing
Catch ex As Exception
Response.Write("Doesn't work: " + ex.ToString())
It doesn't return any erros, however the dts package is not executed.
It could be a permision problem?