Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_server_dba
Posting Yak Master
167 Posts |
 Posted - 2010-05-16 : 20:11:44
|
| Hello,I have no idea about how SSIS works. So i would appreciate if someone can explain me in detail. In SQL 2000, we create DTS packages and we see them under DTS as soon as we create them and we can use them instantly. But in SQL 2005, BIDS is completely re-structured and the packages are created in BIDS where we do not use SSMS(Sql Server Management studio). So my question here is, where do we see those packages in SSMS? How do we see those packeges through SSMS? How those packages are related to SSMS? |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-17 : 12:37:53
|
quote:
Originally posted by sql_server_dba
Hello,I have no idea about how SSIS works. So i would appreciate if someone can explain me in detail. In SQL 2000, we create DTS packages and we see them under DTS as soon as we create them and we can use them instantly. But in SQL 2005, BIDS is completely re-structured and the packages are created in BIDS where we do not use SSMS(Sql Server Management studio). So my question here is, where do we see those packages in SSMS? How do we see those packeges through SSMS? How those packages are related to SSMS?
it depends on where you store your package. you can store your packages in SQL server or in file system. If you've stored your packages in SQL Server you can find them by connecting to Integration Services engine of your Server through SSMS and then expand stored packages-> MSDB under server. If you chose file system then package will be residing on your local hard drive or on shared location based on where you saved it.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
No Idea how SSIS works