We can see the details for all projects that deployed in
the SSISDB catalog.
select * from [internal].[projects]
|
See the output
We can deploy more than one project in a folder.
Sunday, 16 April 2017
Subscribe to:
Posts (Atom)
Popular Posts
-
Delay Validation Property is available on Task level, Connection Manager, Container and on Package level. By default the value of this pro... -
There are multiple ways to run the SSIS package. Refer my previous post where I explain the multiple ways to schedule our SSIS package. I... -
Suppose you have excel and in that excel we have a column that contains mixed data type (like number, date, string etc.). While we are try... -
The RecordSet destination does not save data to an external data source. Instead, the RecordSet destination saves data in memory in a Reco... -
The Merge Join Transform in SSIS is a great way to load a Data warehouse quickly and an easy way to join two data sources together. There ...