Execution SQL task Connection Type issue

• Pulivarthi Sasidhar

  SSCertifiable

  Points: 6706

  More actions

  January 31, 2011 at 12:55 am

  #246029

  Hi All,

  I have taken Connection Type as OLEDB and gave my local server for following code to assign value to Package variable. Its working fine.

  Declare @mon INT,@day INT

  SET @mon=DatePART(Month,GETDATE())

  SET @day=DatePART(Day,GETDATE())

  Select CAST(

  CAST(DatePART(yy,GETDATE()) AS VArchar(4))

  + CASE WHEN @mon<10 THEN '0'+CAST(@mon as VARCHAr(2)) ELSE CAST(@mon as VARCHAr(2)) END

  + CASE WHEN @day<10 THEN '0'+CAST(@day as VARCHAr(2)) ELSE CAST(@day as VARCHAr(2)) END

  AS INT) as dt

  But when i gave expression for connection string and executing the same i amgetting following error.

  [Execute SQL Task] Error: Failed to acquire connection "local\MSSQL2K8.testing". Connection may not be configured correctly or you may not have the right permissions on this connection.

  Even i configured with ADO.NET connection i got the following error..

  [Execute SQL Task] Error: An error occurred while assigning a value to variable "LopVariable": "Result binding by name "dt" is not supported for this connection type. ".

  Please give info to get succeded.

  The server name should be taken from the Config file.

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  January 31, 2011 at 5:07 am

  #1280334

  How did you set-up the configuration?

  Did you use an XML config file?

  Can you explain exactly what you have done to set-up the connection manager's configuration. This way it will be easier to troubleshoot.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP