SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Thomas Stricker

SQLServerCentral.com profile

   Items 1 to 2 of 2   
 

Using SQL Server as a Source with for an Excel Application

I am presenting an MS Excel VBA project which automates the display of SQL Server data tables.  Read more...
Rating: |  Discuss |   Briefcase | 1,200 reads

SSIS Package with a Derived Column

I created this article to demonstrate the use of derived columns inside a ForEachLoop Container for a client requirement for some auxiliary marketing reports. I found the Data Conversion tool useful to escape the problem of mismatched data types, which is an issue with versions of Microsoft SSIS.  Read more...
By Thomas Stricker 2018/02/06 | Source: SQLServerCentral.com | Category: derived columns
Rating: |  Discuss |   Briefcase | 734 reads
   Items 1 to 2 of 2