Different results ?
Posted: 22 Jul 2010, 14:03
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 ?
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 ?