I have taken OLEDB Source, in that i have written EXEC TESTSP in Sql command and simply loading into one Flat file. But for me its not giving any errors.
The package is executing successfully and loading data as well.
CREATE PROCEDURE TESTSP1
SET NOCOUNT OFF;
SELECT * FROM dbo.Books
Thanks for sharing your thoughts.
commented on Feb 21 2013 4:49AM