This really got me confused, for a sec I almost thought that it was an error ans

Nice one, lemme do my homework with there as I have never worked with.

Nice one as I am yet to implement partition tables. Busy with my homework and should have better knowledge after some implementations on m test db

Nice one, Haven't actually worked or used partitioned tables myself and I want to start with the implementing as I have a table that could be done, but I am...

Tx i manged to get this.

Wanted soming like :

EXPRESSION

QTY > 0 && TYPE == "ORDER" ? "O" : "I"

Hi,

If anyone has done a logical and used on a Derived column data flow item please provide some code as mine is not working because of the syntax error.

Tx,

Duda

Hi,

If anyone has used the logical and on the Derived column data flow please provide woth an eg.

Ta,

Duda

Why would you want to run the query in designer if you can run it on Analyser.

Patience, patience...No but Patience.MSSQL SP3 is round da corner...Beta 4 2k8..

I am also struggling here.Here's a qry:

DECLARE @a DECIMAL(30,16), @b-2 DECIMAL(30,2)

SELECT @a = 1, @b-2 = 1

SELECT @a * @b-2

RESULTS from SERVER 1

Msg 8115, Level 16, State 1, Line...

I added the user as part of the local admin in the machine hosting SSIS and this worked but if you do not want to add the user as an...

I agree with what Jefffrey said. Once more try to create the new simple package that will call the changed procedure with extra columns and see if this will make...

You can do this by creating a SSIS package through the Data Import and Export Wizard.

Right click the db that you want to copy its objects and follow the path:...

"With SQL Server 2000 copying Database objects in a dts package and arranging for it to run automatically was a fairly simple procedure."

What kind of objects are you reffering to...

Thanks for an update everyone. This was an issue with Proclarity and there's a hotfix update that neeeds to be implemented for this fix.