-
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…
-
SQL Alphabet Table: Get Next Character
While writing some dynamic SQL to cycle through a set of Active Directory LDAP queries (don’t ask, ugh) I needed to dynamically create a table with the values 0-9 and A-Z in it. After a few minutes,