Exception from HRESULT: 0xC0207016 Error at Data Flow Task [OLE DB Source [1]]: There is a data source column with no name. Each data source column must have a name.

Question

Hello, when previewing the data table to send to excel, I get the error, this is my code:

DECLARE @YA AS DATETIME = GETDATE()
SELECT DATEPART(ISO_WEEK, @YA)

SELECT * FROM Datos.dbo.RegistroDeEntradas
WHERE DATEPART(ISO_WEEK, @YA) = NoSem
ORDER BY Fecha ASC

I'm trying to select just the data with the same number as the number of the week.

Photo: view view

Answer 1

Try removing this line:

 *SELECT DATEPART(ISO_WEEK, *@YA)

However, if you really need it, then add a name:

 *SELECT DATEPART(ISO_WEEK, *@YA) as IsoWeek