Menu
What is the .database file used for in a SSIS package?
391
A database file is one of the several types of the system object type *FILE. A database file contains descriptions of how input data is to be presented to a program from internal storage and how output data is to be presented to internal storage from a program.
Right Click on My projects and click on export, once you click on export it will ask you for the path where you want to export the file, once you provide the name path and click on save, it will create an ''ispac'' file, now our ispac file is ready, go to the folder and right-click on the file and rename its extension, ...
The default folder is the Packages folder, located in %Program Files%\Microsoft SQL Server\100\DTS. The MSDB folder lists the Integration Services packages that have been saved to the SQL Server msdb database on the server.
Quoting MSDN's page on Integration Services Projects
Files in Integration Services Projects
When you add a new or an existing Integration Services project to a solution, Business Intelligence Development Studio creates project files that have the extensions .dtproj and .dtproj.user and .database.
- The *.dtproj file contains information about project configurations and items such as data sources and packages.
- The *.dtproj.user file contains information about your preferences for working with the project.
- The *.database file contains information that Business Intelligence Development Studio requires to open the Integration Services project.
78
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
