Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 error on running proc_generate_excel_with_columns

Author  Topic 

rum23
Yak Posting Veteran

77 Posts

Posted - 2009-04-01 : 11:38:04

Hi, I am using the proc_generate_excel_with_columns stored procedure created by Madhavan but I get the error on executing it. Can you please help? Thanks much

EXEC proc_generate_excel_with_columns 'databasename', 'tablename','Cfilename'

Error
Msg 208, Level 16, State 1, Procedure proc_generate_excel_with_columns, Line 11
Invalid object name 'information_schema.columns'.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-02 : 05:04:55
quote:
Originally posted by rum23


Hi, I am using the proc_generate_excel_with_columns stored procedure created by Madhavan but I get the error on executing it. Can you please help? Thanks much

EXEC proc_generate_excel_with_columns 'databasename', 'tablename','Cfilename'

Error
Msg 208, Level 16, State 1, Procedure proc_generate_excel_with_columns, Line 11
Invalid object name 'information_schema.columns'.


Try capitalising it

INFORMATION_SCHEMA.COLUMNS

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -