December 13, 2013 at 8:13 am
Using SSIS 2008 R2, I've got a query in an OLE DB Source task that works fine in SSMS and about 2/3 of the time it works okay in SSIS, but about 1/3 of the time it doesn't bring back a record (it should bring back 1 record, and in SSMS it does bring back one record).
Any ideas on how to debug this?
Thanks,
Rob
December 18, 2013 at 9:05 am
Sounds very strange!
Is your source query just a 'standard' SQL command or is it derived from a variable and/or expression? Is the SSIS package running as a SQL Agent job or are you manually executing the package either in Design or Run mode? Is the data time-dependent in any way?
Have you tried running a Profiler trace to check that the target database is being accessed by the query?
Regards
Liam
December 27, 2013 at 5:08 am
Lempster (12/18/2013)
Sounds very strange!Is your source query just a 'standard' SQL command or is it derived from a variable and/or expression? Is the SSIS package running as a SQL Agent job or are you manually executing the package either in Design or Run mode? Is the data time-dependent in any way?
Have you tried running a Profiler trace to check that the target database is being accessed by the query?
I had to set this issue off to the side, but I'll have to solve this one soon.
It's a straight-forward SQL query, but I do build it into a SSIS variable. I could put a message box in a script task to display the query string -- that's a good thought.
I am manually running the package through BIDs.
Not time dependent.
The profiler suggestion is a good one as well.
Thanks for the suggestions, I'll post back what I find.
Rob
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply