SSISDB Catlog

Refer  The Source Video:

SQL SERVER SSIS Lesson24 Deploying and Setup Environments inSSISDB Catlog Bhaskar Reddy Baddam

 1.Create  Catalog



"Integration  Services Catalog"

 2.Environments 

       Variables:
"FilePath"   value  
c:\dev etc.
                        -Dev
                        -Test
                        -Prod

3.
-ClassParameter (right  click choose  "Configure")
           

References

First  screen  "ProjectParameter",  to this  pass Environment variable "FilePath".

    Choose Dev,Test,Prod  , it will just  say  source: .



 Parameters

       -Use environmental  variable  :FilePath  (  specify it )


------------------------------------------------------------------------------------------------------------

"Integration  Services Catalog" 

     -SSISDB
          -PkgParameter
                -Projects
                       -ClassParameter (right  click choose  "Configure")
               -Environments

                    ( In  this  window   "Variables"  - just  give any name say  "FilePath", value give the path  c:\dev etc.
                        -Dev
                        -Test
                        -Prod

In   the Project  in 2012  Project.param-  Create project  lever parameter i.e. pointing to Dev,Test,Prod.It shows like C:\devpath etc.  Just  the file path  where theproject
will be Deployed.

In  the package connection manager, right click , if you  choose "Expression"  ,that has ConnectionString, click on it
see  $Project.param ,showing the path for Dev,Test,Prod.

---
SSMS  -   

Previously to see the Integration Service  Page,click on the  drop down choose  
"Integration Services"  not  "Database Engine"  etc.Then  it used  to show
the Packages  under   "MSDB".

But  in  2012:  it  is   directly under  Database ,it's  called 

"Integration  Services Catalog"  -   all  packages   are stored here.

When you create one, it creates  "SSISDB". One  can not  change it.



"Integration  Services Catalog" 

     -SSISDB
          -PkgParameter
                -Projects
                       -ClassParameter (right  click choose  "Configure")
               -Environments

                    ( In  this  window   "Variables"  - just  give any name say  "FilePath", value give the path  c:\dev etc.
                        -Dev
                        -Test
                        -Prod

        







---
In   the package  there is no Environment.

1.But  here  you create.

2.Then  on  package  right  click 
ClassParameter (right  click choose  "Configure")

References

First  screen  "ProjectParameter",  to this  pass Environment variable "FilePath".

    Choose Dev,Test,Prod  , it will just  say  source: .



 Parameters

       -Use environmental  variable  :FilePath  (  specify it )