• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2182
  • Last Modified:

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

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
Fatehbourghoud
Asked:
Fatehbourghoud
  • 3
  • 2
1 Solution
 
vdr1620Commented:
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
 
vdr1620Commented:
0
 
FatehbourghoudAuthor Commented:
How to write an MSBuild Script using this command dtutil /DestS [servername] /FILE [filename].dtsx /COPY SQL;[foldername]\[filename] /QUIET
0
 
FatehbourghoudAuthor Commented:
Solution not complete as needed
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now