2008年1月23日
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 阅读(303) 评论(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 阅读(232) 评论(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 阅读(366) 评论(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 阅读(291) 评论(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 阅读(1051) 评论(0) 推荐(0) 编辑