首页 > 其他 > 详细

在SSIS中使用自定义的DLL文件

时间:2014-11-19 10:39:54      阅读:225      评论:0      收藏:0      [点我收藏+]
原文:在SSIS中使用自定义的DLL文件

步骤
1、开发dll(需要签名)

bubuko.com,布布扣using System;
bubuko.com,布布扣
using System.Collections.Generic;
bubuko.com,布布扣
using System.Text;
bubuko.com,布布扣
using System.Xml;
bubuko.com,布布扣
using System.Xml.Schema;
bubuko.com,布布扣
bubuko.com,布布扣
bubuko.com,布布扣
namespace ETLXmlParser
bubuko.com,布布扣
{
bubuko.com,布布扣    
public class ETLXmlParser
bubuko.com,布布扣    
{
bubuko.com,布布扣        
private static bool isValid = true;
bubuko.com,布布扣
bubuko.com,布布扣        
public static bool Validate(string XmlFilepath, string XsdFilePath)
bubuko.com,布布扣        
{
bubuko.com,布布扣            
try{
bubuko.com,布布扣            XmlReader reader;
bubuko.com,布布扣            XmlReaderSettings settings 
= new XmlReaderSettings();
bubuko.com,布布扣            XmlSchemaSet schemaSet 
= new XmlSchemaSet();
bubuko.com,布布扣            schemaSet.Add(
null, XsdFilePath);
bubuko.com,布布扣            settings.Schemas.Add(schemaSet);
bubuko.com,布布扣            settings.ValidationType 
= ValidationType.Schema;
bubuko.com,布布扣
bubuko.com,布布扣            settings.ValidationEventHandler 
+= new ValidationEventHandler(settings_ValidationEventHandler);
bubuko.com,布布扣            settings.ValidationFlags 
= XmlSchemaValidationFlags.ReportValidationWarnings | XmlSchemaValidationFlags.ProcessInlineSchema | XmlSchemaValidationFlags.AllowXmlAttributes | XmlSchemaValidationFlags.ProcessIdentityConstraints | XmlSchemaValidationFlags.ProcessSchemaLocation;
bubuko.com,布布扣            reader 
= XmlReader.Create(XmlFilepath, settings);
bubuko.com,布布扣            
while (reader.Read())
bubuko.com,布布扣            
{
bubuko.com,布布扣                
string xmlFile = reader.Value;
bubuko.com,布布扣            }

bubuko.com,布布扣            reader.Close();
bubuko.com,布布扣            
return isValid;
bubuko.com,布布扣            }

bubuko.com,布布扣            
catch(Exception ex)
bubuko.com,布布扣            
{
bubuko.com,布布扣                
return false;
bubuko.com,布布扣            }

bubuko.com,布布扣        }

bubuko.com,布布扣
bubuko.com,布布扣        
private static void settings_ValidationEventHandler(object sender, ValidationEventArgs e)
bubuko.com,布布扣        
{
bubuko.com,布布扣        
bubuko.com,布布扣            isValid 
= false;
bubuko.com,布布扣        }

bubuko.com,布布扣    }

bubuko.com,布布扣}

bubuko.com,布布扣
2 将编译好的dll拷贝到C:\Program Files\Microsoft SQL Server\90\DTS\PipelineComponents(SQL Server 安装目录)和C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727
3、将DLL拖进C:\WINDOWS\assembly文件夹,也可以用命令安装该dll(gacutil.exe /i myassembly.dll)
4 在SSIS中拖入一个Script Task,然后设计脚本,添加应用dll
bubuko.com,布布扣

在SSIS中使用自定义的DLL文件

原文:http://www.cnblogs.com/lonelyxmas/p/4107376.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!