Hi Alex,
This is Mark again. I'm gald to work with you again on the issue.
Based on the description, I understand that you would like to use the
Integration Services sample packages. Is it correct? if I misunderstand
anything, please tell me. That will help us resolve the issue quickly.
Based on the current situation, it seems that the sample package has not
been installed. So our first step is to install the sample package. In SQL
Server 2008, you can download and install the AdventureWorks sample
database, the Integration Services sample packages, and the Integration
Services programming samples from the Microsoft CodePlex site. There is an
article to share with
you:http://msdn.microsoft.com/en-us/library/bb522532.aspx
For your convenience, I list the detail steps here
1 Open a browser window, and either type
http://www.CodePlex.com, or click
SQL Server Samples to go directly to the Microsoft SQL Server Samples and
Community Projects portal page.
2 On the page, find Microsoft SQL Server Product Samples.
3 Click Database.
4 On the Release tab, find the version of the AdventureWorks database that
you want to use:
5 On the Microsoft SQL Server Product Samples page, click Integration
Services.
6 On the Release tab, download the SQL Server Samples Setup program, and
then run Setup on your computer.
note: You must install all the samples. There is not a separate Setup
program for Integration Services.
Besides, to use the sampe packages, there are some requirement. There is an
article to share with
you:http://msdn.microsoft.com/en-us/library/ms345274.aspx
The sample packages and data files that it uses must be installed on the
local hard disk drive.
You must have installed and have administrative permissions on the
AdventureWorks DW database.
If you intend only to run the sample package from the command line, you
must install Integration Services.
If you intend to open the package in SSIS Designer and run the sample
package, you must also install Business Intelligence Development Studio.
Also, I do some additional research for you. There is an article to give
you:http://msdn.microsoft.com/en-us/library/ms169917.aspx (Creating a
Simple ETL Package)
Hope the above helpful.
Have a nice day.
Best regards,
Mark Han
Microsoft Online Community Support
===========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg.DeleteThis@microsoft.com.
===========================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or
a Microsoft Support Engineer within 2 business day is acceptable. Please
note that each follow up response may take approximately
2 business days as the support professional working with you may need
further investigation to reach the most efficient resolution.
The offering is not appropriate for situations that require urgent,
real-time or phone-based interactions. Issues of this nature are
best handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================