I'm working with an SSIS 2005 package which runs a stored procedure as an "Execute SQL" task. The sproc runs several other sprocs, some of which use PRINT statements to report status (this is so ...

Learn how to improve your SQL skills and write more efficient and elegant queries with these tips and resources. Explore the basics, practice, databases, code, feedback, and learning.

PRINT 'SQL Server Data Path: '+ @data_dir The code above calls the extended stored procedure explicitly (referring to the master database) ...