在SSIS中使用自定义的DLL文件
2024-10-12 09:01:37
步骤
1、开发dll(需要签名)
using System;
using System.Collections.Generic;
using System.Text;
using System.Xml;
using System.Xml.Schema;
namespace ETLXmlParser
{
public class ETLXmlParser
{
private static bool isValid = true;
public static bool Validate(string XmlFilepath, string XsdFilePath)
{
try{
XmlReader reader;
XmlReaderSettings settings = new XmlReaderSettings();
XmlSchemaSet schemaSet = new XmlSchemaSet();
schemaSet.Add(null, XsdFilePath);
settings.Schemas.Add(schemaSet);
settings.ValidationType = ValidationType.Schema;
settings.ValidationEventHandler += new ValidationEventHandler(settings_ValidationEventHandler);
settings.ValidationFlags = XmlSchemaValidationFlags.ReportValidationWarnings | XmlSchemaValidationFlags.ProcessInlineSchema | XmlSchemaValidationFlags.AllowXmlAttributes | XmlSchemaValidationFlags.ProcessIdentityConstraints | XmlSchemaValidationFlags.ProcessSchemaLocation;
reader = XmlReader.Create(XmlFilepath, settings);
while (reader.Read())
{
string xmlFile = reader.Value;
}
reader.Close();
return isValid;
}
catch(Exception ex)
{
return false;
}
}
private static void settings_ValidationEventHandler(object sender, ValidationEventArgs e)
{
isValid = false;
}
}
}
using System.Collections.Generic;
using System.Text;
using System.Xml;
using System.Xml.Schema;
namespace ETLXmlParser
{
public class ETLXmlParser
{
private static bool isValid = true;
public static bool Validate(string XmlFilepath, string XsdFilePath)
{
try{
XmlReader reader;
XmlReaderSettings settings = new XmlReaderSettings();
XmlSchemaSet schemaSet = new XmlSchemaSet();
schemaSet.Add(null, XsdFilePath);
settings.Schemas.Add(schemaSet);
settings.ValidationType = ValidationType.Schema;
settings.ValidationEventHandler += new ValidationEventHandler(settings_ValidationEventHandler);
settings.ValidationFlags = XmlSchemaValidationFlags.ReportValidationWarnings | XmlSchemaValidationFlags.ProcessInlineSchema | XmlSchemaValidationFlags.AllowXmlAttributes | XmlSchemaValidationFlags.ProcessIdentityConstraints | XmlSchemaValidationFlags.ProcessSchemaLocation;
reader = XmlReader.Create(XmlFilepath, settings);
while (reader.Read())
{
string xmlFile = reader.Value;
}
reader.Close();
return isValid;
}
catch(Exception ex)
{
return false;
}
}
private static void settings_ValidationEventHandler(object sender, ValidationEventArgs e)
{
isValid = false;
}
}
}
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
最新文章
- jquery-lazyload延迟加载图片
- Xamarin的不归路-安卓模拟器启动慢&;没有虚拟键盘
- 如何在centos上安装epel源
- jsonp解决CORS问题
- C# 操作Cookie类
- git 基本命令
- Difference between Linearizability and Serializability
- IE 6最小最大宽度与高度的写法
- Black Box
- 玩转Nodejs日志管理log4js(转)
- MyEclipse中spring MVC的配置
- 不断摸索发现用 andy 模拟器很不错,感觉跟真机差不多
- linux 安装memcached C/C++使用libmemcached库(续)
- .29-浅析webpack源码之Resolver.prototype.resolve
- Linux安装JSON-C
- 安装和使用Docker(Windows7)
- JQuery官方学习资料(译):类型
- 基准对象object中的基础类型----字典 (六)
- redis:string字符串类型的操作
- android recovery 升级UI显示之资源文件