Home Forums SQL Server 2005 SQL Server 2005 Integration Services using sp_MSForEachDB in a data flow task RE: using sp_MSForEachDB in a data flow task
krabe
SSC Enthusiast
Points: 112
More actions
February 27, 2015 at 9:35 am
#1780663
Did you ever get this solved? I'm trying to write an SSIS package to gather DB/file stats from all of our instances and cannot seem to get the sp_MSForEachDB proceedure to work with SSIS. I get an error stating "Invalid object name '#qtemp'."