mercoledì 28 settembre 2011 13:32
I am currently trying to create my first SSIS project in where I am trying to have the project look at a folder and load all the *.SQL files into a DB. Any suggestions what sample project would help me out with what I am doing or someone have a project that they are willing to share. I am running SQL 2008 R2.
Thanks for help....
Tutte le risposte
sabato 14 aprile 2012 10:47Moderatore
Did you find an answer to your question?
When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
MC ID: Microsoft Transcript
giovedì 19 aprile 2012 00:20
have you looked at
Microsoft SQL Server Community Samples: Integration Services
lunedì 23 aprile 2012 22:35
The Books Online tutorial "SSIS Tutorial: Creating a Simple ETL Package", specifically "Lesson 2: Adding Looping", demonstrates how to iterate through multiple files in a folder and load the data into a SQL Server database.
The instructions for "Lesson 2: Adding Looping" are located at http://msdn.microsoft.com/en-us/library/ms166566(SQL.105).aspx . This Books Online topic applies to SSIS 2008 & 2008 R2.
A completed sample package for Lesson 2 is included in the SQL Server samples that you download from this CodePLex project -- http://msftisprodsamples.codeplex.com/ . In the right-hand pane, click Download to download the samples on a 64-bit machine; click View all downloads to download the samples on other operating system platforms.
The SQL Server samples download also contains samples for Reporting Services, Analysis Services, and the Database Engine.
To view & run the sample package for Lesson 2 you'll need to install the AdventureWorksDW sample database. The installation for 2008 R2 Adventure Works databases, is at http://msftdbprodsamples.codeplex.com/releases/view/59211 . The installation for 2008 Adventure Works databases, is at http://msftdbprodsamples.codeplex.com/releases/view/37109 .
- Proposto come risposta Mr. WhartyMicrosoft Community Contributor, Moderator lunedì 23 aprile 2012 23:12
- Contrassegnato come risposta Mr. WhartyMicrosoft Community Contributor, Moderator giovedì 3 maggio 2012 01:56