01 2008 档案

Contingent execution based on stored procedure results I(zz)
摘要：http://sqljunkies.com/WebLog/knight_reign/archive/2005/03/18/9178.aspx Well, I've been a little pre-occupied lately. Between rebuilding machines, my kids getting sick, getting sick from my kids, and m... 阅读全文
posted @ 2008-01-24 00:13 stu_acer 阅读(387) 评论(0) 推荐(0)
Table driven foreach loops(zz)
摘要：http://sqljunkies.com/WebLog/knight_reign/archive/2005/03/25/9588.aspx In an earlier blog I mentioned that we'd have a fix for the ForEachADOEnumerator. Before the fix there were some pretty involved ... 阅读全文
posted @ 2008-01-23 23:56 stu_acer 阅读(314) 评论(0) 推荐(0)
Adding headers to flat files(zz)
摘要：原文地址：http://sqljunkies.com/WebLog/knight_reign/archive/2004/12/06/5404.aspx So, you want to record some information in a flat file about when it was created, what machine it was created on etc.? The f... 阅读全文
posted @ 2008-01-23 23:09 stu_acer 阅读(239) 评论(0) 推荐(0)
Passing a Table to A Stored Procedure(zz)
摘要：原文地址：http://www.sqlservercentral.com/articles/Stored+Procedures/2977/ Introduction Most of us would be very specific in designing the database code (Stored procedures, functions, views etc) in a re-... 阅读全文
posted @ 2008-01-23 23:07 stu_acer 阅读(377) 评论(0) 推荐(0)
System variables, logging and the Execute SQL Task...(zz)
摘要：原文地址http://sqljunkies.com/WebLog/knight_reign/archive/2005/02/27/8187.aspx Here's something useful you can do with system variables and the SQL Task. Logging in SSIS is more flexible and there are mor... 阅读全文
posted @ 2008-01-23 22:16 stu_acer 阅读(297) 评论(0) 推荐(0)
SSIS的文件系统任务实例(zz)
摘要：一篇采用SSIS的文件系统任务实现文件拷贝、改名的的文章。简单，但能说明问题。来源于：http://sqljunkies.com/WebLog/knight_reign/archive/2005/02/12/7750.aspx Expressions : Part II This is a blog I've been wanting to do for some time. It addres... 阅读全文
posted @ 2008-01-23 21:56 stu_acer 阅读(1065) 评论(0) 推荐(0)