Search results for query: *

Thank you, In the Data Flow Task: SET FMTONLY OFF Execute my_procedure_name At top of my procedure: SET NOCOUNT ON And it works!!!!!

Hi, Have been having server problems. You set me in the correct direction, but I found this article on the internet. http://blogs.conchango.com/jamiethomson/archive/2006/12/20/SSIS_3A00_-Using-stored-procedures-inside-an-OLE-DB-Source-component.aspx I tried this, did create the metadata for...

Help!!!!! All I want to do is connect to a database, exec a stored procedure that writes to a flat file. Seems so simple and was in DTS. Can someone tell me how to do this is SSIS. What I have tried: 1. Tried to do it in Wizard, but doesn't seem to allow execute my_procedure_name in...

Thank you. I think that the problem might be that even through we are using SQL SERVER 2005, our instance is still SQL SERVER 2000. I get error: 'The conversion of a char data type to a datetime data type resulted in an out-of-range datatime value' for the code you gave and all else that I...

But that does not make a DATE data type.

Hi, Does anyone know how to convert 'Oct-09-07' to a date data type? Thank you!

Hi, I am new to SQL SERVER 2005. I have created a Stored procedure using T-SQL. I cannot seem to get my print statements for debugging to print to the screen. I did a simple select in the procedure. It did not print to screen either. I am used to procedures printing output in a grid in...