Link to home
Start Free TrialLog in
Avatar of Fatehbourghoud
Fatehbourghoud

asked on

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
Avatar of vdr1620
vdr1620
Flag of United States of America image

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
Avatar of Fatehbourghoud
Fatehbourghoud

ASKER

How to write an MSBuild Script using this command dtutil /DestS [servername] /FILE [filename].dtsx /COPY SQL;[foldername]\[filename] /QUIET
ASKER CERTIFIED SOLUTION
Avatar of vdr1620
vdr1620
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Solution not complete as needed