25112
asked on
dts where ssis where
SSIS packages are stored in MSDB database.. what format are they stored in (xml etc)
where are the DTS (SQL 2000) stored?
where are the DTS (SQL 2000) stored?
Last Comment
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
>>SSIS packages can be stored in the database or in the file system. dtx packages could also be stored in the file system.
so both 2000 and 2005 can be stored purely in file system or purely in msdb, right?
so both 2000 and 2005 can be stored purely in file system or purely in msdb, right?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
thanks reza_rad
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
select * from msdb..sysssispackages
Invalid object name 'msdb..sysssispackages'.
select * from msdb..sysssispackagefolder
Invalid object name 'msdb..sysssispackagefolde
the above is on 2005.
select * from msdb..sysdtspackages is fine both on 2005 & 2000