28 сентября 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....
14 апреля 2012 г. 10:47Модератор
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
19 апреля 2012 г. 0:20
have you looked at
Microsoft SQL Server Community Samples: Integration Services
23 апреля 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 .
- Предложено в качестве ответа Mr. WhartyMicrosoft Community Contributor, Moderator 23 апреля 2012 г. 23:12
- Помечено в качестве ответа Mr. WhartyMicrosoft Community Contributor, Moderator 3 мая 2012 г. 1:56