Hi,
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
        Try
            pack.LoadFromSQLServer("mtfs012", "bgtest", "test", DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default , , , , "CSV_Importer", )
            pack.Connections.Item(3).ConnectionProperties.Item (1).Value = fileName
            pack.Execute()
            pack.UnInitialize()
            pack = Nothing
        Catch ex As Exception
            Response.Write("Doesn't work: " + ex.ToString())
        End Try

It doesn't return any erros, however the dts package is not executed.
It could be a permision problem?

Thanks

Try the same with a windows forms if it runs perfectly then I could be a permission problem.



It is not how much we do,
but how much love we put in the doing.

-Mother Theresa