SSIS (missing) Pre-Build and Post-Build

Posted by Raj More on Stack Overflow See other posts from Stack Overflow or by Raj More
Published on 2009-07-31T15:51:01Z Indexed on 2010/05/07 13:28 UTC
Read the original article Hit count: 220

Filed under:

ssis

|

postbuild-event

|

sql-server

|

sql

|

etl

For the warehouse work under progress, we have a single solution with multiple projects in it

OLTP Database Project
Warehouse Database Project
SSIS ETL project

After the SSIS project is built, I want to move the binaries (XML, really) from the Bin folder to "C:\AutomatedTasks\ETL.Warehouse\" and "C:\AutomatedTasks\ETL"

I cannot find the Post-Build events to do that for the SSIS project. Where are they? If they aren't available, how do I achieve this?

© Stack Overflow or respective owner

Related posts about ssis

SSIS packages incompatibilities between SSIS 2008 and SSIS 2008 R2

as seen on SQL Blog - Search for 'SQL Blog'
When you install SQL 2008 R2 workstation components you get a newer version of BIDS (BI Developer Studio, included in the workstation components) that replaces BIDS 2008 version (BIDS 2005 still live side-by-side). Everything would be good if you can use the newer version to edit any 2008 AND 2008R2… >>> More
Parsing flat files using SSIS : SSIS Nugget

as seen on SQL Blog - Search for 'SQL Blog'
Often when using SQL Server Integration Services (SSIS) you will find there is more than one way of accomplishing a task and that the most obvious method of doing so might not be the optimal one. In the video below I demonstrate this by way of an experiment using SSIS’s Flat File Source component;… >>> More
Introducing SSIS Reporting Pack for SQL Server code-named Denali

as seen on SQL Blog - Search for 'SQL Blog'
In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali: What's new in SSIS in Denali Introduction to SSIS Projects in Denali Parameters in SSIS In Denali SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali… >>> More
New SSIS tool on Codeplex – SSIS Log Analyzer

as seen on SQLIS - Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice… >>> More
New SSIS tool on Codeplex – SSIS Log Analyzer

as seen on SQLIS - Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice… >>> More

Related posts about postbuild-event

How to execute a program on PostBuild event in parallel?

as seen on Stack Overflow - Search for 'Stack Overflow'
I managed to set the compiler to execute another program when the project is built/ran with the following directive in project options: call program.exe param1 param2 The problem is that the compiler executes "program.exe" and waits for it to terminate and THEN the project executable is ran. What… >>> More
Visual Studio - Post-build event to merge .cs files

as seen on Stack Overflow - Search for 'Stack Overflow'
My target environment only accepts .cs files and complies them at run time. My project has gui.cs and 4 other class files. Its about 9000 lines of code. Is there a way to have all 5 files merged into 1 cs file as a post build event? >>> More
Search and replace in *.aspx,*.ascx files when publishing a Webapplication

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all I'm attempting to replace a pattern in all my .aspx and .ascx file when I Publish my Webapplication. When I am running the application locally, I don't care about the replace. But as soon as I need to Publish the solution I need a sequence of characters, let's say "ABC", replaced with "DEF"… >>> More
GWT Post build command in Eclipse

as seen on Stack Overflow - Search for 'Stack Overflow'
I am starting getting used to Eclipse, but I have much more experience with Visual Studio. In Visual Studio it is possible to run auto commands after the build has finished. Now I am creating a GWT project and several other projects at once in one solution (or workspace) in Eclipse. Some files which… >>> More
How to add a build time to a file archive as a post-build macro?

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to pack the project into a zip-file and have the build date time (or the current date time) as part of the zip-filename. $(TargetDir)\7za.exe -a release.zip *.* So it would be nice to incorporate the date into the release.zip, something like release-14-3-2010-22_56.zip Is it possible to… >>> More