This seems like it should be easy to do, but I can't figure it out.
In my Control Flow I have an Execute SQL task that populates an ADO Recordset variable. That works fine, the variable holds a list of server names.
Then I have that connected to a Foreach Loop Container, which loops through the server names, connects to each server, reads some info, and writes that to a table. That also works,
except for those servers that it can't connect to.
So here's what I'd like to do: before I connect to the server, write the value of the variable (which contains the server name) to a table in SQL, along with getdate() so I know when it started
trying to connect.
How do I just write the value of a variable to a table? If I just use an OLE DB Destination, there are no input columns.
My best thought was to use a Script Component and somehow get that value, and then somehow make it an output column, which I then connect to the OLE DB Destination as an input column??
If I do this in a C# Script Component:
it works just fine, so I know my variable is there an available.
View Complete Post