Build of a SSIS .dtsx Package in Microsoft Visual Studio

Question

Does a Build of a .dtsx SSIS Package in Microsoft Visual Studio accomplish anything?

Once we finish the development and testing of the .dtsx SSIS Package in Microsoft Visual Studio, all we usually do is move the .dtsx to the Library in which the SQL Server Agent Job will Execute the SSIS Package within the SQL Server Agent Job and its Job Step via the SQL Server Integration Services Package and the Package path.

Is there any harm in doing this and not doing a "Build" in Microsoft Visual Studio?

We just don't understand how the "Build" comes into play and may actually dynamically "Build" when we Start and Execute the Package in Microsoft Visual Studio.

Any feedback would be accepted.

Thanks!

Answer 1

Build only builds / validates all SSIS packages and we can deploy final .ispac to target server/folder.

It is not necessary as such.. In some projects, we have been just opening package, do modification, run, save package and copy these packages to target folder. No harm in these if you are sure package changes are fine.

In other projects, I have used Build and Deploy SSIS tasks using Azure DevOps.. as shown here

----------

Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

Answer 2

Hi @Bobby P ,

1.Is there any harm in doing this and not doing a "Build" in Microsoft Visual Studio?
We can create a ssis package in Microsoft Visual Studio.
Then we have many different ways to run this package.
Running a package in SQL Server Agent job is one of the ways to run ssis package.
So, it seems that there is no harm if you do not change the ssis package in VS.

2.We just don't understand how the "Build" comes into play...
Please refer to the following link and pictures:
Difference between Build Solution, Rebuild Solution, and Clean Solution in Visual Studio?

Best Regards,
Mona

----------

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.