Different results ?

Get help on databases - MySQL, Oracle, Access, etc.
Post Reply
Registered User
Posts: 172
Joined: 09 Apr 2010, 15:18

Different results ?

Post by DeeVeeDee »

I created a view in ms SQL2005

If i right click my database and select all tasks -> export.

DB source = The View that i have created.
DB destination = Flat file CSV.

Above is a saved SSIS pakage.

Runs perfectly fine but the results is not the same as
when i run a Crystal report from the view or when i manually create a SQL service & Integration package.

The amount of rows is the same, but the QTY Sold value has about a 1000 difference.

CR has the correct value.

How is this possible ?

The other solution the problem is to ignore this and use the SQL integration package that i made.
The only reason why i dont use it ,is cus i dont know how to include the headers when extracting to flat file ?
_̴ı̴̴̡̡̡ ̡͌l̡̡̡ ̡͌l̡*̡̡ ̴̡ı̴̴̡ ̡̡͡|̲̲̲͡͡͡ ̲▫̲͡ ̲̲̲͡͡π̲̲͡͡ ̲̲͡▫̲̲͡͡ ̲|̡̡̡ ̡ ̴̡ı̴̡̡ ̡͌l̡̡̡
Post Reply