Sunday, February 19, 2012

DTS with ASP.NET Question

Hi There,

I need some help with passing global variabe: I try this way but does not work??

my code:

1 Dim DTSPack As New DTS.Package
2
3 Try
4
5 DTSPack.LoadFromSQLServer(SrName, UName, PWD, DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, "", "", "", PkgName)
6 DTSPack.GlobalVariables.Item("ExcelPath").Value = InpFileExcel.PostedFile.FileName.ToString
7 DTSPack.Execute()
8
9 Catch ExecDTS As Exception
10 lbl1.Text = ExecDTS.Message
11 End Try

anyone can help??

Is it DTS (2000 ) or SSIS (2005). ?

No comments:

Post a Comment