0
推荐
1638
阅读
SSIS ---DelayValidation property(转载)
Package and individual tasks are validated during design phase itself,to delay the validations till execution phase ,there is an option under Properties - > DelayValidationWe can set DelayValidation property to True/False at package/individual tasks levelBy defaul...
0
推荐
1206
阅读
Send Mail Task 发送邮件(windows 认证)
一、配置IIS SMTP 服务器首先安装IIS 服务Win 8 系统 -->start-->control panel-->programs and features-->turn windows features on or off-->internetinformation services 安装完成后,应用程序里会有 打开IIS,找到smtp e-mail 配置smtp e-mailapply, smtp e-mail就配置Ok了。二、在S...
0
推荐
1478
阅读
SSIS 遍历表的每一条记录
最近公司有一个需求,有一个表,表里有个字段存的是URL,要检测出哪些URL是有效的在ETL中遇到两个问题:1.在DB里URL列是NVARCHAR(MAX),在Script Component里转换成string时出错,Debug看到的是Microsoft.SqlServer.Dts.Pipeline.BlobColumn而不是真正的URL内容,百度了一下Converting Microsoft.SqlServer.Dts.Pipeline....
2
推荐
2259
阅读
SSIS包部署和运行SSIS包
Sql Server2014一、右击SSIS(Project名称),然后点deploy点Next,server name 填一下,path填一下,点browse是跳出sql server integration services对话框,去Sql server management studio里创建路径找到Integration services catelog,右击-->create catelog右击SSISDB,-->Create Folder-->输入Folder na...