Figure: Me and Adam Cogan had a great but exhausting day, talking about current technologies in Sydney
When Adam went to the Pub, I ran to the university UTS to teach Business Intelligence - Cubes
Figure: Me and Adam Cogan had a great but exhausting day, talking about current technologies in Sydney
When Adam went to the Pub, I ran to the university UTS to teach Business Intelligence - Cubes
Labels: conferences
Q1 How to trigger SSIS/SSRS jobs manually/on-demand without using the SQL Agent. How can I let end users trigger dtsx packages. Are there API hooks that I could run from a VBScript form (ideally) or perhaps .NET
Q2 I would like to know how you loop through different directory and upload files from various directories using SSIS. It will be great if you can give some demo.
Labels: business intelligence, sql server, SSIS, SSRS
string errormsg; User user; bool success = AuthenticationService.GetUser(usercode, out user, out errormsg);Figure: Bad example - We should avoid "out" parameters, because it means we return 2 objects from a method.
Labels: .NET4, c#, readibility
Every table in our database should have a "LastModified" column to record the last modified time of each row.
Figure: Sample table with a LastModified column
Our rule "Do you have standard Tables and Columns?" says the column should be called "DateModified" which has the same purpose.
How do you populate that field?
Labels: sql server, tip