Donnerstag, 27. Dezember 2012

SSRS Seitenumbrüche in Reports entfernen

Damit ein Report auf einer Seite Dargestellt wird, muss folgende Einstellung gemacht werden:

Dienstag, 11. Dezember 2012

NSA310 unrar

1.http://192.168.0.14/zyxel/cgi-bin/remote_help-cgi?type=backdoor
2. Login via Telnet
      - 192.168.0.xx Port 23
      - User: root PW: wie bei der Weboberfläche
2. find / -name unrar
      - Der pfad zur unrar wird angezeigt
      - /pfad/zu/unrar x fileName.part01.rar p[password]
      - möchte man die Sitzung ohne PC ausführen, kann man ein & hinter dem Befehl eingeben.


Quellen:
http://gforge.stat.uni-muenchen.de/gf/project/cip/wiki/?pagename=Simulationen+am+Server

Mittwoch, 5. Dezember 2012

SSIS ScriptTask Select

Public Sub Main()
    Dim sql As String
    Dim connStr As String = "server=SERVER\INSTANCE;integrated security=true;MultipleActiveResultSets=True;database=SCHEMA"
    Dim status As String
   
    Using Connection As New SqlConnection(connStr)
        Connection.Open()

        Dim command As SqlCommand = Connection.CreateCommand()
        Try
            sql = "       SELECT * "
            sql = sql & " FROM TABLE_A "
            sql = sql & " WHERE ... "

            command.CommandText = sql
            status = command.ExecuteScalar()
            Connection.Close()
        Catch ex As Exception
            Dts.Events.FireInformation(130, "..... ", "err: " & ex.ToString, "", 0, True)
        End Try
    End Using

End Sub

SSIS vb-ScriptTask Select

Public Sub Main()

Dim sql As String
Dim connStr As String = "server=SERVER\INSTANCE;integrated security=true;MultipleActiveResultSets=True;database=SCHEMA"
Dim status As String

Using Connection As New SqlConnection(connStr)
Connection.Open()

Dim command As SqlCommand = Connection.CreateCommand()

Try
sql = " SELECT * "
sql = sql & " FROM TABLE_A "
sql = sql & " WHERE ... "

command.CommandText = sql

status = command.ExecuteScalar()
Connection.Close()
Catch ex As Exception
Dts.Events.FireInformation(130, "..... ", "err: " & ex.ToString, "", 0, True)
End Try
End Using

End Sub