Jeff Moden (12/29/2015)

---

Actually, that explains a lot.

So who's code is it that's in your first post...

I will remove their proc call from our code and just do the export in a...

I would love to post the code.. but it is my vendor's code... sorry.

I am using varchar(8000) so that shouldn't be limiting it to 128.

John Rowan (10/7/2015)

---

This error is telling you that you've configured the object transfer to contend with Identity values, but your target table does not actually have an IDENTITY column in...

Using the Transfer SQL Server Objects Task, I am having the same issue with our identity tables.. error:

Error: 0xC002F325 at Refresh MPM's Zemeter net, Transfer SQL Server Objects Task: Execution...

Thanks for your reply.. I am back from two weeks of vacation.. and getting back to this project.. due Monday. Looking at the transfer sql server objects task.. setting up...

michal.lisinski (9/23/2015)

---

Hi

Could you please tell me what the error is returned in the first issue?

Regarding the second issue, you can play with SET IDENTITY_INSERT [ database_name . [schema_name ] ....

How can you tell?

How do you find the timeout.. in SSIS? I looked around but could not locate.

GilaMonster (6/5/2015)

---

That will work fine.

The error was because you left in a column alias from when it...

Lynn Pettis (6/4/2015)

---

dwilliscp (6/4/2015)

---

Lynn... it looks like you can not use a case statement inside of the update statement... just trying to make sure.. I guess I can put the...

Lynn... it looks like you can not use a case statement inside of the update statement... just trying to make sure.. I guess I can put the update together in...

Ok, thanks for the help.

BTW I am doing this so I can clean up the nvarchar's, and avoid doing this in the Join's and the where, so the data will match what is needed....