Joseph Michael Pesch
VP Programming

SSIS Setting Variables in SQL Agent Job Scheduler (Job Properties)

by 30. October 2008 14:39

You can use the "Set Values" tab on the "Job Step" properties page to set SSIS variable values by placing the path to the variable in the "Property Path" column (e.g. Global variable syntax: "\Package.Variables[User::MyGlobalVariable].Properties[Value]" Object variable syntax: "\Package\MyObject.Variables[User::MyObjectVariable].Value") and the corresponding value in the "Value" column (e.g. "This is a static string variable value...").  NOTE: Do not include quotes in the "Property Path" and "Value" data when entering it into the editor.  Here is a screenshot example:



SSIS Error Converting String to Number (Possible Data Truncation)

by 23. October 2008 13:43



Oracle Equivelant of SQL sysobjects and syscolumns

by 22. October 2008 15:36

Tables: all_tables Columns: all_tab_columns



Oracle | SQL Server

Windows System Startup and Registry Research Tools

by 20. October 2008 19:06

msconfig (run from Start > Run)




Error Using Interop.SourceTypeLib.dll on Machine without VSS Installation

by 20. October 2008 14:27

Error: Retrieving the COM class factory for component with CLSID {783CD4E4- 9D54-11CF-B8EE-00608CC9A71F} failed due to the following error: 80040154.

Received when installing a .MSI (built in VS2008) onto a server that doesn't contain VSS application installation.  The VS2008 project was referencing Interop.SourceSafeTypeLib.dll (which was being copied into the insallation directory).  To resolve this issue I needed to also copy SSAPI.dll (from the local development machine VSS program directory) into the deployment folder on the target machine and register it (e.g. regsvr32 .../ssapi.dll where .../ is the actual path of the dll file).  Additionally, you will need a sub-folder (in the folder containing the ssapi.dll) and a copy of the ssui.dll in that folder (see diagram below).  The attached zip file contains the 3 dll's referenced below.


C:\Program Files\Microsoft Visual SourceSafe\ssapi.dll  [Target]\ssapi.dll (run regsvr32 on this one) 
C:\Program Files\Microsoft Visual SourceSafe\1033\ssui.dll [Target]\1033\ssui.dll (must be in 1033 sub-folder)
<Don't know where it originates from> [Target]\Interop.SourceSafeTypeLib.dll (488.50 kb)



ASP.Net File System Website Build/Run Error

by 17. October 2008 14:00

Error 16 Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

In my case this error was most likely due to a file/folder level permission issue.  I was running a file system website in my VS2008 and received this error when attempting to build/run the web site.  When I moved the web site folder from the original network location (my H: drive) to my local C: drive the error went away.





C# convert ArrayList into delimited string

by 14. October 2008 13:47

System.Collections.ArrayList myArrayList = new System.Collections.ArrayList();
for(int i = 0; i < 10; i++)
string myDelimeter = ",";
string myDelimitedList = string.Join(myDelimiter, (string[])myArrayList.ToArray(typeof(string)));
// output would be: "1,2,3,4,5,6,7,8,9"



HTML Format Issue - Gaps around images in table cells

by 7. October 2008 15:04

Having a line feed in the HTML source can cause an gap (what would appear to be a padding issue).

    <td> <!-- the line feed here can cause spacing issues -->
      <img src="..." style="width: 100px; height: 100px" />
    </td> <!-- the line feed here can cause spacing issues -->

    <td><img src="..." style="width: 100px; height: 100px" /></td>



LINQ to SQL Error: Cannot access a disposed object.

by 3. October 2008 14:48

LINQ to SQL Error:

Cannot access a disposed object.
Object name: 'DataContext accessed after Dispose.'.

One case that case cause this error is when related table/object doesn't have any rows and the parent object is used outside of the scope of the DataContext object that instantiated it.


public static tbl_LoanRequest GetLoanRequest(Guid LoanRequestID)
  using (BidMortgageDataContext bmdb = new BidMortgageDataContext())
    tbl_LoanRequest LoanRequestTable = bmdb.tbl_LoanRequests.SingleOrDefault(r => r.LoanRequestID == LoanRequestID);
    if (LoanRequestTable == null)
      LoanRequestTable = new tbl_LoanRequest();
    else if (LoanRequestTable.LoanRequestBids.Count() == 0)
      LoanRequestTable.LoanRequestBids = new System.Data.Linq.EntitySet<LoanRequestBid>();  // This line prevents the error.
    return LoanRequestTable;