Posted on

Import tab delimited data files directly into SQL Server via SSMS

Recently, I wanted to bring data into a SQL Server table, and I wanted to do so w/o SSIS. I know that I had done this before, but, of course, I had forgotten the details. I found the best answer here:

The solution requires putting a “Schema.ini” file in the same directory as the file you are attempting to upload, and the file HAS TO BE NAMED “schema.ini” (case insensitive). The contents of the simple text file should be as follows:

Continue reading “Import tab delimited data files directly into SQL Server via SSMS”

Posted on

SSRS Data Source Lister

Hello,

Sometimes, you’re in the middle of doing something, and you need an answer.  You google it and find such a great solution, you want to keep it handy for … whenever!  Here is such a post.  As the title of my post indicates, you can list out the Data Sources that exist on an SSRS server… and you can do so with this code…which i got entirely from http://gallery.technet.microsoft.com/scriptcenter/List-connection-strings-of-1a9a9adc.  Thank you Olaf Helper!

 

Posted on

SSAS not logging?

So you’ve followed all the advice and set up logging so that you can know who is using your cubes.  Things are good.  One day you wake up and see that your logs no longer are logging.  You open your cube yourself and browse.  Then you re-check your logs…no entries.  You KNOW the cube is working.  You KNEW the log WAS logging.  Why not now?  Continue reading “SSAS not logging?”

Posted on

Sql Binaries location, SessionTimeout, Sql Version

OK…this is a ‘strange’ post… That is because the script i have for you today is a real ‘utility’ script… it does three things that occasionally come in REAL handy! It tells you the location of your SQL binaries. It tells you the length of the session time out for the server your instance is running on. It tells you the full SQL Version information. Enjoy! Continue reading “Sql Binaries location, SessionTimeout, Sql Version”