SSIS Error

• mtz676

  SSCrazy Eights

  Points: 9181

  More actions

  February 1, 2016 at 1:45 am

  #307512

  I have this piece of SQL code failing inside a data flow task.Attached is a screenshot.

  It has an audit as data flow transformation between the oledb source and oledb destination.

  Error message is :

  [OLE DB Source [1]] Error: A rowset based on the SQL command was not returned by the OLE DB provider.

  [SSIS.Pipeline] Error: component "OLE DB Source" (1) failed the pre-execute phase and returned error code 0xC02092B4.

  The code returns results in SSMS but is not running in SSIS.

  I capture the result and dump it into a SQL table.

  The audit has machinename and username in it.

  The destination SQL table has 4 columns.

  How do I fix it.

  Thanks

  DECLARE @num_logs int;

  EXEC xp_instance_regread N'HKEY_LOCAL_MACHINE',

  N'Software\Microsoft\MSSQLServer\MSSQLServer',

  N'NumErrorLogs',

  @num_logs OUTPUT;

  SELECT

  Servername=cast(@@servername as varchar(128)),ErrorlogsCount=ISNULL(@num_logs,6);

• mtz676

  SSCrazy Eights

  Points: 9181

  More actions

  February 1, 2016 at 1:48 am

  #1855628

  SET NOCOUNT ON

  fixed the issue.

  Thanks