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
Is it DTS (2000 ) or SSIS (2005). ?
No comments:
Post a Comment