August 29, 2006 at 4:33 pm
Hi All, When I run my package from SQL Server Agent with out any OLE DB Source in Data Flow it runs fine, but as soon as I add an OLE DB Source (I have some SQL that spits out some data which I have to manipulating in a script task in Data Flow) the same package errors out in SQL Server Agent, but runs fine in Visual Studio. I even execute the same SQL in Execute SQL Task in Control Flow and it runs with out any error in both SQL Server Agent and Visual Studio (I was thinking that it might be a connection issue in Data Flow). Do any body have any idea about this issue?. Buy the way I am using configuration file in my package.
I will appreciate any help. Thanks
September 1, 2006 at 6:05 am
Is this a similare issue to this question on the forum...
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=148&messageid=304480
...? Hard to say without any detail of the error, but if it is, that thread might help.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply