if datepart(dw, getdate()) in (6, 7)
    use pubs;

Browse by Tags

• .NET
• good practices
• SQL Server 2008 R2
• SSIS
• tips and tricks

• Running SSIS packages from C#

  Most of the developers and DBAs know about two ways of deploying packages: You can deploy them to database server and run them using SQL Server Agent job or you can deploy the packages to file system and run them using dtexec.exe utility. Both approaches Read More... Posted Monday, April 09, 2012 10:52 PM by Piotr Rodak | 4 Comments Filed under: tips and tricks, SQL Server 2008 R2, good practices, SOA, SSIS, C#, .NET Attachment(s): ServiceETLDemo.zip