Issue with OLE DB Source in Data Flow

• Mobashir Ahmed

  SSC Enthusiast

  Points: 179

  More actions

  August 29, 2006 at 4:33 pm

  #173795

  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

• Fattman

  Old Hand

  Points: 330

  More actions

  September 1, 2006 at 6:05 am

  #657996

  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.