Combine CSV files via dos command

Open command prompt.

Type copy c:\*.csv c:\combine.csv and press enter

This will combine all of the csv files that are in your root c:\ directory into one file called File.csv.

You can change the file names and paths as necessary.

SSIS Designer does not remember visible area

Ref to : http://stackoverflow.com/questions/6095186/ssis-designer-does-not-remember-visible-area

Content

 get around this problem by doing the following:

1. Set zoom to 100% (View -> Zoom -> 100%) Note: you may have to click in the designer pane to get Zoom to show on the view menu.
2. Scroll the window to where you want it be when you open up the package.
3. Select and move a task.
4. Save file

For step 3, I usually select the top task and press Ctrl-[left arrow], Ctrl-[right arrow]. I like tasks to stay where I put them! :)

Hope that helps.

WORK ครับ

Reporting service ,Operation is not valid due to the current state of the object

Reporting service ,Operation is not valid due to the current state of the object
Resolve :  http://www.sqlservercentral.com/Forums/Topic692785-147-1.aspx#bm1240909

By Sandy Westman Error ใน Reporting service : กรณี Long run parameter ทำให้เกิด  Error ให้เปิด config file แล้ว Add key  C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager.

Create an Analysis Services Project Based on an Existing Analysis Services Database

http://technet.microsoft.com/en-us/library/ms365361.aspx

To create an Analysis Services project using the Import Analysis Services 9.0 Database template

1. On the File menu, select New and then select Project, or press Ctrl+Shift+N, to display the New Project dialog box, or click New Project on the toolbar.
2. Select Business Intelligence Projects from the Project types pane in the New Project dialog box.
3. Select Import Analysis Services 9.0 Database from the Visual Studio installed templates category of the New Project dialog box.
4. Type the name of the project in the Name text box.
5. Type or select the folder in which to store the files for the project in the Location dropdown list, or click Browse to select a folder.
6. Either select Add to Solution to add the new project to the existing solution in the Solution dropdown list, or select Create new Solution to create a new solution.
7. If Create new Solution is selected in Solution, select Create directory for solution to create a new folder for the new solution, then type the name of the new solution in Solution Name.
8. Click OK.

Completing the Import Analysis Services 9.0 Database Wizard

1. On the Welcome to the Import Analysis Services 9.0 Database Wizard page, click Next.
2. On the Source Database page, specify the server and the database from which the wizard will extract the contents and create the Analysis Services project, and then click Next.
   
   You can either type the database name or query the server to view the existing databases on the server.
3. When the wizard finishes extracting the contents of the Analysis Services 9.0 database, click Finish on the Completing the Wizard page.
4. Open the Solution Explorer window to view the contents of the project.
   
   

SQL Service Net command

Reference to :  http://microsoft-ssis.blogspot.com/2010/12/start-and-stop-batchfile-services-via.html

Start and stop batchfile services via a batchfile

Case
Constantly running all Microsoft SQL Services on your development desktop/laptop could be a little too much.Especially when you're not developing, but starting and stopping via the control panel is tiresome...

Solution
You can stop/start a service via the command (or even better, put it in a batchfile):

Syntax
      NET START [service]
      NET STOP [service]
      NET PAUSE [service]
      NET CONTINUE [service] 
   
Key
   service : The service name as shown in Control Panel, Services

Apparently it does not matter whether you use the Service name or the Display name.  

Start batchfile SQL 2005:
@ECHO OFF
NET START "SQL Server (MSSQLSERVER)"
NET START "SQL Server Agent (MSSQLSERVER)"
NET START "SQL Server Integration Services"
NET START "SQL Server Analysis Services (MSSQLSERVER)"
NET START "SQL Server Reporting Services (MSSQLSERVER)"

Stop batchfile SQL 2005:
@ECHO OFF
NET STOP "SQL Server (MSSQLSERVER)"
NET STOP "SQL Server Agent (MSSQLSERVER)"
NET STOP "SQL Server Integration Services"
NET STOP "SQL Server Analysis Services (MSSQLSERVER)"
NET STOP "SQL Server Reporting Services (MSSQLSERVER)"



Start batchfile SQL 2008:
@ECHO OFF
NET START "MSSQLSERVER"
NET START "SQL Server Agent (MsSqlServer)"
NET START "SQL Server Integration Services 10.0"
NET START "MSSQLServerOLAPService"
NET START "ReportServer"

Stop batchfile SQL 2008:
@ECHO OFF
NET STOP "MSSQLSERVER"
NET STOP "SQL Server Agent (MsSqlServer)"
NET STOP "SQL Server Integration Services 10.0"
NET STOP "MSSQLServerOLAPService"
NET STOP "ReportServer"