Data Viewer shows only a partial list of the columns

Solution: right-click ==>Data Viewer==>select Data Viewer==>Configure==>Grid==>select the columns wanted.

SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED: The Excel Connection Manager is not supported in the 64-bit version of SSIS, as no OLE DB provider is available.

Executed a package in Win 7, got the above error.
Solution: Set the run64runtime to False for the debug option in the Property window of the solution

An error on sending mail in SSIS usign Script Task

Using the following visual C# codes to send a hotmail mail, got the error, then changed the port number from 25 to 587 it works!

 using System;
using System.Data;
using Microsoft.SqlServer.Dts.Runtime;
using System.Windows.Forms;
using System.Net;
using System.Net.Mail;
namespace ST_41027be1cfb14c29a9b05c97e79b0f8c.csproj
    [System.AddIn.AddIn("ScriptMain", Version = "1.0", Publisher = "", Description = "")]
    public partial class ScriptMain : Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase

        #region VSTA generated code
        enum ScriptResults
            Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success,
            Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
              public void Main()
            MailMessage msg = new MailMessage ("","", "This from C#","hey, buddy");
            SmtpClient client =new SmtpClient ("",587);
            client.EnableSsl =true;
            client.DeliveryMethod =SmtpDeliveryMethod.Network;
            client.Credentials =new NetworkCredential("","xxxxxxx1");
            Dts.TaskResult = (int)ScriptResults.Success;

see the differences with the VB codes for the same functionality

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Net
Imports System.Net.Mail
Partial Public Class ScriptMain
 Inherits Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTARTScriptObjectModelBase

 Enum ScriptResults
  Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success
  Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure
 End Enum

    Public Sub Main()
        Dim msg As New MailMessage("", "", "This from VB", "hey, buddy")
        Dim client As New SmtpClient("", 587)
        client.EnableSsl = True
        client.DeliveryMethod = SmtpDeliveryMethod.Network
        client.Credentials = New NetworkCredential("", "nanjing1")
        Dts.TaskResult = ScriptResults.Success
    End Sub
End Class

Login Failed for User xxx

I try to mimic a video demo to set a new connection manager in SSIS, using the sa account.


1. I enabled the sa account usin the code below:
               ALTER LOGIN [sa] ENABLE
2. OK in SSMS, but not working in SSIS
3. I created a new SQL login in SSMS, and changed from Windows to Mixed
4. Login as the new SQL login, still failed
5. Pipename, TCI-IP, shared all are enabled


Restarting the SQL Server service.

Installing SQL Server 2008 R2 Sample Databases - AdventureWorks 2008R2 SR1

After I download the AdventureWorks2008R2_SR1.exe file, and try to install it,
the "Install" button is disabled by default. I have to manually create the "Samples" subdirectory for the samples as:

X:\Program Files\Microsoft SQL Server\100\Tools\Samples, where X is the drive letter.