[MSSQL]SSIS Package Deployment

Article View: cn.bbs.comp.database

Article #843

Back to cn.bbs.comp.database Previous Next

#843

From: Galaxy��VOLUNTEERS��Database
Date: Thu, 20 Nov 2008 15:10

43 lines
3186 bytes

SSIS Package Deployment

Deploy Package�����𣩣���ǰ����PFWEBCN��Ŀʱ���õ�����Ϊ�˽��û��
��ϸ��������ݣ��˽��˸�����Ȼ����Բ���Ӧ����ˡ������½��˸�case��Ҫ��ϸ��
�ˣ���Ȼvkb���Ѿ��ҵ����������case������

Deployһ��packageһ�����Ĳ���
1. ��������ɲ���������package��configuration��������package��ʱ��Ͷ������
�á�����deploy��ʱ���Զ�include��
configuration����һЩ����+ֵ������Ļ�Ҫ�Ƿ�������ı���������������ֻ
��Ҫ�޸���configuration�Ϳ����ˡ�
configuration������xml��������SQL Server��ĳ���?Ҳ�����ǻ���������package��
����

2. ������SSIS project��������һ��package deployment utility��
deployment utility ����һ��������Ҫ�����package���ļ��С����Ҫ��Readmeʲ
ô�ģ��ŵ�Miscellaneous�ļ����
Ҫ����deployment utility�Ļ�����Ҫ����Ŀ�������CreateDeploymentUtility����Ϊ
True��

3. ��deployment�ļ��и��Ƶ�Ŀ�������
���ûɶ��˵��

4. ��Ŀ���������wizard����װ������ļ�ϵͳ��SQL Server��instance�
˫��һ��<project name>.SSISDeploymentManifest������wizard�߾��ܲ����ˡ�

�ͻ���Ҫ��VS2008 deploy��SQL Server 2005��ȥ���޸�package.dtsx��ֻҪ��������
�޸ģ�
modify <DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" 
DTS:ExecutableType="SSIS.Package.2">
to <DTS:Executable xmlns:DTS="www.microsoft.com/SqlServer/Dts" 
DTS:ExecutableType="MSDTS.Package.1">
delete <DTS:Property 
DTS:Name="LastModifiedProductVersion">10.0.1600.22</DTS:Property> or modify 
it to the version of SQL Server such as 9.00.3073.00

 
--
Welcome to Database Board
��ӭ������ݿ��
http://bbs.sjtu.edu.cn/bbsdoc?board=database

[m[1;31m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.27][m

Technical Details

Message-ID: <4d8S9Q$b0W@bbs.sjtu.edu.cn>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU

Show Full Headers

Complete Article Headers

X-Google-Thread: 101948,fd4eb102a1a592a2,start
X-Google-Attributes: gid101948,domainid0,public,usenet
X-Google-Language: Chinese,GB
Path: arc1-ca.pugleaf.net!g2news1.google.com!news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.neu.edu.cn!news.shec6.edu.cn!SJTU
From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database)
Newsgroups: cn.bbs.comp.database
Subject: [MSSQL]SSIS Package Deployment
Date: 20 Nov 2008 15:10:29 GMT
Organization: ��ˮ˼Դ
Message-ID: <4d8S9Q$b0W@bbs.sjtu.edu.cn>
Mime-Version: 1.0
Content-Type: text/plain; charset="gb2312"
Content-Transfer-Encoding: 8bit
X-Filename: database/M.1227193802.A
Lines: 42