Thursday, February 12, 2009

SSIS Links to Tips and Blogs

Very good tip on setting package variables from SQL Jobs:

SSIS Tip #1: Set SSIS package variables via SQL Agent jobs - Steve Holstad's "the bright lights"


This is an OK article.  I am still figuring out how to use a DateTime Variable as a parameter in an Execute SQL Task:

Working with Parameters and Return Codes in the Execute SQL Task

Will post a solution later...



Wednesday, February 4, 2009

Use Cases, Help!!

Here are some helpful links for Use Case Diagrams:

Creating Use Case Diagrams

Use case - Wikipedia, the free encyclopedia

I have a book: "UML Distilled"  by Martin Fowler.
  • Chapter 9 - Use Cases


Tuesday, February 3, 2009

How to Use Custom Assemblies in SQL Server 2005 Reporting Services

Once you have created a custom assembly you will need to copy the .Dll to the following Folders:

[Drive]:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies
[Drive]:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\bin

VS 2010 x64 machine:

[Drive]:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE\PrivateAssemblies

Reference:
How to use custom assemblies or embedded code in Reporting Services

Automatic Site Translation....

This is an interesting article from CodeProject:

CodeProject: Automatic Site Translation Using HTTPModules and Machine Translation (MT). Free source code and programming help

Is it possible for us to use a similar approach to our WinForms?