Data Source Untuk Excel 2007

To create an OLE DB connection manager from the Connection Managers area

1. In Business Intelligence Development Studio, open the package.

2. In the Connections Managers area, right-click anywhere in the area, and then select New OLE DB Connection.

3. In the Configure OLE DB Connection Manager dialog box, click New.

4. In the Connection Manager dialog box, for Provider, select Microsoft Office 12.0 Access Database Engine OLE DB.

   Note:
   To connect to a data source that uses Excel 2007, you cannot select Microsoft Jet 4.0 OLE DB Provider for the Data Source.

5. On the Connection tab of the Connection Manager dialog box, for Server or file name, type or paste the complete path and file name.

6. On the All tab of the Connection Manager dialog box, for Extended Properties, enter one of the following values based on the file format of the Excel 2007 file:

   • Enter Excel 12.0 Xml for the default file format that uses the .xslx file name extension.
     —or—
     
   • Enter Excel 12.0 for the non-default binary file format that uses the .xslb file name extension.
     

   Note:
   When you import from Excel 2007, you can specify either Excel 12.0 or Excel 12.0 Xml because the driver infers the correct format from the input file. However, when you export to Excel 2007, you have to specify the Excel file format that corresponds to the file name extension that you have given the output file.

Script untuk update row guna OLE DB Command

1. UPDATE Client SET AddressID = ? WHERE (ClientID = ?)
2. hit the Refresh button, and then you can map the parameters to variables on the Column Mapping tab

Error untuk remote desktop

1. On the client, navigate to the following registry subkey: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSLicensing.
   
2. Click MSLicensing.
   
3. On the Registry menu, click Export Registry File.
   
4. In the File name box, type mslicensingbackup, and then click Save.
   
5. If you need to restore this registry key in the future, double-click mslicensingbackup.reg.
   
6. On the Edit menu, click Delete, and then click Yes to confirm the deletion of the MSLicensing registry subkey.
   
7. Close Registry Editor, and then restart the computer.

SQL untuk mark duplicate row

Sangat bagus untuk Condition Split dlm SSIS (ETL)

Select *,
rank() over (Partition by Code, description order by TieBreakerColumn desc, SurrogateKey) MyRank
from SourceWithDuplicates

Count Intake 20091

1. Jun 1st 2009 : 48531
2. Jun 2nd 2009 : 48589
3. Jun 3rd 2009 : 48807
4. Jun 8th 2009 : 50074
5. jun 9th 2009 : 49402
   

To register MSXML 6.0.

1. From the Start menu, click Run.
2. Enter the following command:. regsvr32 %windir%\system32\msxml6.dll.

URLS untuk Application Windows yang peting

Walaupun guna Mac/Unix, tetap kena ada app. berikut untuk memudahkan when using pc kawan(Win)

1. Foxit Reader
2. Firefox
3. 7-Zip
4. µTorrent
5. TeraCopy
6. ImgBurn
7. VLC

Condition Untuk Expression Dalam Derive Column

Untuk String :
[columnname] == "padanan"? "Benar":"Salah"

Untuk Integer
[colunmname] < 350.00 ? ListPrice * .2 : ListPrice * .1