Contents tagged with SQL Server

  • SSIS Package - User Variables

    A SSIS (SQL Server Integration Services) package is very useful if you want to export data from your database. Recently I wanted to pass some input parameters to my SSIS package and had to struggle to figure out how this can be done. This really isn't very well documented and you can't find detailed instructions on the Internet so I thought I'd blog about it. Get a load of how complicated it turned out to be!

  • Generate A Data Dictionary Using ASP.NET

    I hate having to open SQL Server or Microsoft Access just to look up a table or column name. Therefore I usually print out a data dictionary for future reference. Of course, I could just use Server Explorer in Visual Studio but I am not in the habit of using that (possibly because Server Explorer is not descriptive of what it actually does).

  • Eiffel For ASP.NET - SQL Server Example

    First, let me introduce myself. I am a web developer and I've been using ASP.NET since 2001. I've only started to learn ASP.NET 2.0 and only started using Visual Studio 2005 this year. I am currently converting an ASP web application to ASP.NET 2.0. I have extensive technology notes which I maintain in a custom help collection integrated in the Microsoft Document Explorer. I've never worked with any other developers so nobody has ever benefited from my experience or seen my notes. I hope to share some of this material here.