Load many *.sql files into SQL suggestions - What project - Newbee

Question

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....

Answer 1

Hi Finalsupport,

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

Jeff Wharton
MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCSD, MCITP, MCDBA
Blog: Mr. Wharty's Ramblings
Twitter: @Mr_Wharty
MC ID: Microsoft Transcript

Answer 2

Hi Finalsupport,

have you looked at 

Microsoft SQL Server Community Samples: Integration Services

http://sqlsrvintegrationsrv.codeplex.com/

________________________________________

When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer 

Vishal Narayan Saxena
Twitter: @vishalsaxena

---

vishal

Answer 3

Hi,

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 .

---

Carla Sabotta