Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2010-08-18
5
Medium Priority
?
2,168 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1000 total points
ID: 33471852
0
 

Author Closing Comment

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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how the fundamental information of how to create a table.

609 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