Solved

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

Posted on 2010-08-18
5
2,008 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
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…
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.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

929 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now