http://www.sqlsoldier.com/wp/sqlserver/usingsystemrestrictschemafunctioninmdxtoquerydmvs
Key words = DMV , SQL 2008
Mssql, Microsoft sql server, SSAS, SSRS ,SSIS , Analysis Service, Reporting Service, Integration Service, XMLA ,MDX ,SQL
วันพฤหัสบดีที่ 24 พฤษภาคม พ.ศ. 2555
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.
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.
วันพุธที่ 23 พฤษภาคม พ.ศ. 2555
SSIS Designer does not remember visible area
Ref to : http://stackoverflow.com/questions/6095186/ssis-designer-does-not-remember-visible-area
Content
Content
get around this problem by doing the following:
- 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.
- Scroll the window to where you want it be when you open up the package.
- Select and move a task.
- 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
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. |
สมัครสมาชิก:
บทความ (Atom)