Chrissy321 (1/2/2013)

---

Hello All,

I am trying to configure a new server so that I can call dtexec via xp_cmdshell

Here is how I am attempting to call dtexec.

DECLARE @PackageString varchar(600)

DECLARE @ReturnCode...

Sorry by INT Max value wrong it should read

declare @bigIntCard bigint

declare @Card int

Set @Card = -199870816

Set @bigIntCard = Cast(2147483647 as bigint)+((Cast(2147483648 as bigint))+@Card)+1

print @bigIntCard

You also need the +1,...

How did you get to this number 2305969845 as I dont get close even by just adding the abs(-199870816) to the top value for an Integer.

I believe the int gets to a max of 2147483648 before it flips over to negatives, and it then starts off at -2,147,483,648 and counts down towards 0, as 2^32...

I did thanks, hope you had a good christmas and new year as well.

anthony.green (1/2/2013)

---

Jason-299789 (1/2/2013)

---

so is @p_error an integer?

In which case you will need to change the

IF @p_Error IS NOT NULL

SET @sql = @sql + 'AND RS.ERROR_CODE =...

so is @p_error an integer?

In which case you will need to change the

IF @p_Error IS NOT NULL

SET @sql = @sql + 'AND RS.ERROR_CODE = ' +...

BarneyL (1/2/2013)

---

It might be worth picking up a copy of 'The Microsoft Data Warehouse Toolkit' from the Kimball group. It will give you a good start on the theory side...

Hi Bob,

The SCD component in SSIS can have significant performance issues, especially where large data volumes are concerned and there are a lot of changes going on as the Type...

PS : just had one thought of inspiration

http://social.msdn.microsoft.com/forums/en-US/sqlintegrationservices/thread/1a91b594-23b0-47f5-940b-4ee067f82fe2

Its using a different driver, but could still be a valid solution.

I'm going to have to bow out as I have limited knowledge of Teradata.

It sounds very much like an ODBC/Teradata driver error, have you tried the TeraData forums to see...

Id agree with that Jeff, a permenant calendar table (or similar) would be the best option.

I just thought it strange to put a clustered index on a temporary tally table,...

I've just tested this and it shuold work with an INT32 datatype.

How is your tast set up? is it set to use Single or Full row count?

The Variable is set...

Sorry I thought the variable you were using was in the SSIS package not an SQL variable.

I take it the SQL Task you have just does

SELECT COUNT(1) From myTable

After...

anthony.green (12/18/2012)

---

Strange on seeing the row_overflow as that should kick in when the row spans more than 8060 bytes, but the maximum row length is only 6148 bytes so strange...