Wednesday, March 24, 2010

End RDP Session Remotely

Another note. I'm sure it happened a lot of times for somebody who has worked on a Windows Server. You can't log in because the terminal service allows only 2 connections. Error message is: "Terminal Server has exceeded the maximum number of allowed connections." This happened to me when my Windows XP crashed while RDP'd to one of our servers. Problem is I can't log in again to that particular server. Here's what I did in command line to end my session remotely so I can log back in.

Try the following command from your local machine. If 'query' command isn't working, you can try logging in to another server or machine that has 'query' command enabled, then do the following...

Wednesday, January 27, 2010

SSIS Bug – The DataFlow task has no components

Have you ever experienced this nasty bug in SSIS.  You create a package in SSIS and after adding all your data flow tasks and making sure you got everything ok, now when you finally run your package, nothing happens.  Then looking at the progress window, you see this warning message: “[DTS.Pipeline] Warning: The DataFlow task has no components. Add components or remove the task.”  What happened?  Then you try to run it again, then nothing happens still.  Now when you close your project and re-open it.  Some of your control flow items no longer can be read or some are missing.  Huh!  Now blood pressure starts to rise.

What’s going on?  Apparently, something’s gone wrong with the XML serializer.  Remember all packages are saved in XML format.  So somehow when it’s done that, some of the components were not recorded properly.  When I tried to trace which components gone bad, I was able to determine that it was my Flat-file connection.  I got this error message when I tried to edit it:


As it turned out, the flat file itself has some weird characters in the first line.  Because I’m using the first line to get my column names, this causes the serializer error.  So my solution is to skip the first line and just use the generic Column 0, Column 1 headings.  The downside is I have got ambiguous columns but at least not that nasty error.

Again, just a note to myself.