今天,主管让研究SSIS如何实现自动化。尤其是比较繁琐的文件导入数据,网上找了些资料,用VS2005,做了一个简单的资料导入功能。有了.dtsx文件
代码如下:
/**
* Copyright (c) eBizprise, Inc All Rights Reserved.
*/
package com.ebizprise.project.newhoemwork.common;
import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.io.DataInputStream;
/**
* java 调用SSIS
* SSISCaller
* @author Jack.Wang
* @version 1.0, Created on 2011-2-25 下午04:57:20
*/
public class SSISCaller {
public static void main(String[] args) {
try {
// create the execution process
Process executionProcess = Runtime.getRuntime().exec("dtexec /f \"f:/temp/dts/Package.dtsx\"");//这个地方要写你做好的dtsx文件的路径
// create the output reader
BufferedReader output = new BufferedReader(new InputStreamReader(new DataInputStream(
executionProcess
.getInputSt