In this post,I will cover how to create a SSIS package to load a single flat file (text file) into a database.I have bunch of posts crawling in my mind right now,I will try to cover one by one.I will also try to have a video version of this post because it's a bit difficult to have each step in the screenshots.

So, let's begin...

Telling you guys upfront that this post will have less words and more screenshots...

Open your Sql Server Business Intelligence Development Studio.


Once you open this , Go to File -> New -> Project.You will see a window like this, Select the options as mentioned in below screenshot  :


Next window will be like this. Hey!! Can you see your package here ??


Drag the Data Flow Task (DFT) to the main screen ( like it is going to perform on main stage !!).


Double click on DFT. Now drag Flat File Source and OLE DB Destination.


Link them together by dragging green line from Flat File Source to OLE DB Destination.Now, double click on Flat File Source.Click on the New button to create a new connection.


Give the connection name and browse for your text file , also make sure to place tick marks as mentioned in the below screenshot.
* My text file is comma delimited.










Press OK .. OK and you are done with Flat File connection.Now, move to OLE DB Destination to configure the connection.Double click on OLE DB Connection box...


 Click on New.Select Server Name and Database from dropdown list...

 

 Click Ok and you will come to main screen.So here, Select 'Table or View' in the Data access mode..


In the 'Name of the table or View' click on New button, it will automatically create a table structure based on your file format.I just renamed the table name..


Click  OK and we are done with the configuration. Now, it's time to execute the package...


It's done !!


Let's check in the table...


Let's jump to the steps....

You must have .bak files to restore, just like I have these .bak files that I am going to restore :


Suppose if I am going to restore AdventureWorksDW2008R2 , first of all I have to select the existing AdventureWorks2008R2 database just like below mentioned screenshot:


Steps are quite simple, Right click on the existing database -> Tasks -> Restore -> Database.
Now, it will pop up a window...


As you click on ok button, you will get another window. Just click on Add button.


And look for the .bak file..

 
 Click ok button...


So, once you are done with the above steps, just press the ok button in the main window but you will get an error as mentioned below :


It's easy to resolve, Click on the Options in the left-top and select all the options as mentioned below:


Now, you can click and it's done !!



In this post , I will show you a way to download free pics from Flickr.I know a lot of you already know about Flickr but if you are not aware of it then this short description is for you...

So, What Is Flickr ?

--- Wikipedia

"Flickr (pronounced "flicker") is an image hosting and video hosting website, and web services suite that was created by Ludicorp in 2004 and acquired by Yahoo in 2005. In addition to being a popular website for users to share and embed personal photographs, and effectively an online community, the service is widely used by photo researchers and by bloggers to host images that they embed in blogs and social media."

                                                                                                                             
So, How To do this ?

Go here ...  Free Images



Now, the important one...



 Click on the Creative Common licensed content to get the images, legally free to use. If you are uploading these images somewhere just for sharing and fun purpose then mark the Find content to modify, adapt or build upon.Otherwise if you are using these images on your site and blog and earning some money based on that then mark Find content to use commercially.


As soon as you click on the dotted line, you will get a pop like this:



Click on Download/All sizes and you will have options like this to choose from:


 Select the size , hit the Download and you are done !!
© 2015 Techie's House. Designed by Bloggertheme9