ODBC Stage and Stored Procs
Posted: Wed Dec 10, 2003 9:52 am
Can someone please help me with this? I am being told by Ascential support that calling a Stored Proc (SQLServer 2000) through and ODBC stage and returning data to a sequential file is NOT SUPPORTED. Can this possibly be true?
Support told me that the only way Stored Procs are supported is if you are passing data from a file into a parameter and then calling the proc with no return data.
I find it impossible to believe that we are the only ones using Stored Proc to help simplify or flatten out data prior to the ETL process.
Any help would be great!
Thanks!
Aaron
Support told me that the only way Stored Procs are supported is if you are passing data from a file into a parameter and then calling the proc with no return data.
I find it impossible to believe that we are the only ones using Stored Proc to help simplify or flatten out data prior to the ETL process.
Any help would be great!
Thanks!
Aaron