Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AAAV
Posting Yak Master
152 Posts |
 Posted - 2013-08-06 : 12:12:21
|
| I have a script task which has 100 predefined output columnsI have a source table whose column count changesI am trying to set the values to the output columns if the column is there. If the column is not there it will not be set (null)I have a script task to do this. Public Overrides Sub PreExecute() MyBase.PreExecute() Dim Conn As System.Data.SqlClient.SqlConnection Dim Cmd As System.Data.SqlClient.SqlCommand Conn = New System.Data.SqlClient.SqlConnection("Data Source=servername;Initial Catalog=databasename;Integrated Security=SSPI;") Cmd = New System.Data.SqlClient.SqlCommand("Select * from dbo.Temp_Totals", Conn) Conn.Open() Reader = Cmd.ExecuteReader() ''Reader.c() End SubPublic Overrides Sub CreateNewOutputRows() ' ' Add rows by calling AddRow method on member variable called "<Output Name>Buffer" ' E.g., MyOutputBuffer.AddRow() if your output was named "My Output" ' Dim output = ComponentMetaData.OutputCollection(0) 'MsgBox(Microsoft.VisualBasic.Information.TypeName(output)) Dim MaxField = Reader.FieldCount Dim columnName As String While (Reader.Read()) OutputValuesBuffer.AddRow() For i As Integer = 0 To MaxField - 1 columnName = "column" + i.ToString() Dim propInfo As System.Reflection.PropertyInfo propInfo = OutputValuesBuffer.GetType().GetProperty(columnName) propInfo.SetValue(OutputValuesBuffer, Reader(i), Nothing) 'OutputValuesBuffer.GetType().GetProperty(columnName).SetValue(OutputValuesBuffer, Reader(i), Nothing) ---> i just want to set the column value from the reader. Next End While End SubI am getting object reference not set to an instance of an object in the linepropInfo.SetValue(OutputValuesBuffer, Reader(i), Nothing)What am I doing wrong ?Thanks |
|
|
|
|
|
Dynamic Table to Excel 2005 Sql