From the course: SQL Server 2008 Essential Training
Unlock the full course today
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Importing packages into SQL Server Management Studio - SQL Server Tutorial
From the course: SQL Server 2008 Essential Training
Importing packages into SQL Server Management Studio
The end result of working with Business Intelligence Development Studio and SQL Server Integration Services is you end up with a SSIS Package. It ends in .dtsx. In fact, I'm going to come out of Integration Services because I have that folder open here, and this is the package file that I'm interested in. Yes, I can run it from inside Business Intelligence Development Studio, but if I wanted to have this occur and automated, I can actually take it into SQL Server Management Studio and make it part of the database. Now again, it's just a simple package. This is the one that's actually affecting a flat file but the operation is still the same. I'm going to open up SQL Server Management Studio. Except this time rather than connect directly to the database engine, I'm going to connect to Integration Services using the same administration information, and what we'll get here is running packages and stored packages, and if I wanted to take in that package into the database, make it part of…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.