Solved

How automate the build and deployment SSIS ETL packages. Using MSBuild

Posted on 2010-08-18
5
2,052 Views
Last Modified: 2012-05-10
Hi Expert ;

can you provide me an examlpe ( MsBuild Scripts) automating the build and deployment SSIS ETL packages.

Have to use Dtutil , Dtexec , and package is stored as file system

Thank's

Thank's
0
Comment
Question by:Fatehbourghoud
  • 3
  • 2
5 Comments
 
LVL 16

Expert Comment

by:vdr1620
ID: 33469707
Try this

dtutil /DestS [servername] /FILE [filename].dtsx /COPY SQL;[foldername]\[filename] /QUIET

/Copy will copy the files and /Quiet will overwrite the files if any exist
0
 
LVL 16

Expert Comment

by:vdr1620
ID: 33469729
0
 

Author Comment

by:Fatehbourghoud
ID: 33469860
How to write an MSBuild Script using this command dtutil /DestS [servername] /FILE [filename].dtsx /COPY SQL;[foldername]\[filename] /QUIET
0
 
LVL 16

Accepted Solution

by:
vdr1620 earned 500 total points
ID: 33471852
0
 

Author Closing Comment

by:Fatehbourghoud
ID: 33576793
Solution not complete as needed
0

Featured Post

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Query 2 34
TSQL XML Namespaces 7 24
reccommendations for a free msft sql query manager? 4 29
query linked sql table field from access 4 25
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question