Archive | SQL Server Integration Services (SSIS)

SSIS: No column information was returned by the SQL command

Are you trying to use a stored procedure as the source of a SQL Server Integration Services (SSIS) data flow task?  If your stored procedure contains a temp table you may run into the message “No column information was returned by the SQL command” (complete error message below).  Although there are a number of solutions […]