Yes they are on different SAN storage.

Few databases are on EMC SAN storage and TempDB is on NETAPP SAN storage.

Hi Everyone

My issue is resolved.

We have changed oracle provider used in data flow task. Previously it was “Microsoft OLEDB provider Oracle” now we have changed it to “Oracle provider for...

I have changed default buffer size to 30 Mb, but still getting the same error.

It is failing on data flow task.

Dear All,

found solution for this issue on below link.

http://blogs.msdn.com/b/dataaccesstechnologies/archive/2012/01/20/every-bug-is-a-microsoft-bug-until-proven-otherwise.aspx

I found following link for the issue.

http://www.sqlchick.com/entries/2012/9/2/resolving-missing-records-in-ssis-from-oracle-source.html

but didn't get from where to set UseSessionFormat=True.

I Have SQL Server 64 Bit and Oracle client 32 bit on server

Yes the preview of the query is showing 0 as output.

but when I tried the same using Microsoft OLEDB provider for Oracle it giving me proper out-put

I have used OLEDB source in data flow and then written query with where clause to select data from oracle.

Dear Koen Verbeeck,

I am using SQL Server 2008 R2.

Thanks Lowell,

Awesome script. You really saved lots of work.

http://support.microsoft.com/kb/918992

Hi subhash,

Get logical file names as follows

restore filelistonly from disk='your backup path\filename.bak'

then restore database as follows,

restore database database_name from disk='your backup path\filename.bak'

with

move 'Logical_name for mdf file' to 'Path where...

Hi Koen,

My issue is resolved I just changed query as follows

SELECT * FROM OPENQUERY([MySQL], 'CALL proc_clientdata(''2014-06-16'',''2014-06-16'','''','''','''');')

yes I am able to get the output of select statement.

Hi Koen,

Yes , when I execute the same procedure in MySQL it runs successfully .

But when I try to run from SQL Server it is giving me error.

I have also...