ForEach ADO loop variable mapping

Question

Running into a problem on a ForEach over a full result set from a query on an OLE DB connection. The parameter numbers in the execution results seem to be all screwed up. I would appreciate some more eyes on this as I am not seeing the problem.

Here is the query on the result of which I'm iterating:

enter image description here

Variable mapping in the ForEach Loop:

enter image description here

The variables:

enter image description here

This is what I get:

enter image description here

Can you show what the datatypes of the columns are in the table? — TMNT2014
– TMNT2014, Commented Jul 22, 2014 at 20:22
The SiteIDNumber is INT (signed 32 bit) and SequenceNumber is BIGINT (signed 64 bit) — Metaphor
– Metaphor, Commented Jul 22, 2014 at 20:23
I'm not sure why but it seems that DataTypes are not recognised correctly. What happens if you change the query to include a explicit cast to INT or BIGINT? — JodyT
– JodyT, Commented Jul 22, 2014 at 20:27
Changing the SSIS variables to 32bit makes it work. Changing the query to include an explicit cast to bigint has no effect. — Metaphor
– Metaphor, Commented Jul 22, 2014 at 20:29
Apparently there are some issues with conversion between BigInt and Int64 in past releases of SSIS not sure if they were fixed in the 2012 version. I think your best bet would be to store the bigInt as string. — TMNT2014
– TMNT2014, Commented Jul 22, 2014 at 20:33

TMNT2014 · Accepted Answer · 2014-07-22 20:36:41Z

4

Apparently there are some issues with conversion between BigInt and Int64 in past releases of SSIS not sure if they were fixed in the 2012 version. I think your best bet would be to store the bigInt as string.

answered Jul 22, 2014 at 20:36

TMNT2014

2,1401 gold badge12 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

tablaplanet · Accepted Answer · 2016-01-14 15:46:46Z

0

Use "select convert(varchar(20), BIGINTVARIABLE) from SOURCETABALE" instead of normal select. This will allow a workaround for the ForEach loop to work with the BIGINT variable.

answered Jan 14, 2016 at 15:46

tablaplanet

1

Collectives™ on Stack Overflow

ForEach ADO loop variable mapping

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related