Is Microsoft published example of SSIS package (or packages) for making
adwentureWorksDW database from AdwentureWorks db? Where can I find it?
Thanks

I think the sample titled "AWDataWarehouseRefresh Package Sample" has what
you're looking for.  For a description of the sample, see
http://msdn2.microsoft.com/en-us/library/ms160706.aspx. You can download the
latest version of the samples from here:
http://www.microsoft.com/downloads/details.aspx?familyid=E719ECF7-9F46-4312-AF89-6AD8702E4E6E&displaylang=en

Regards,
Gail
Show quoteHide quote

How can I 'copy' a SQL Express database to SQL Everywhere?
AWE and Target Server Memory
xp_cmdshell bcp output redirect '>' failing w/o UNC name
SQL 2000 Reporting Service Management ??
sql agent job
DBCC Error
CURRENT_USER issue
Cannot access file location
access denied to sqlcmd line
AWE and Target Server Memory