dianerstein 8713 (10/12/2016)

---

In a sql server 2012 database, the first insert statement works that is listed below works:

insert into [dbo].Cust (custid,[number],lockid)

values (134,118692,1098)

The following insert statement does not work...

DamianC (10/12/2016)

---

Using your suggestion sergiy, I've managed to get it working

One question

You have:

declare @MaxID bigint

select @MaxID + MAX(ID) From TargetTable (TABLOCKX)

This returns NULL

I've amended it to (changed + for =)

declare...

lindsayscott23 (10/12/2016)

---

Hi Grant,

Thanks for your help and advice here - really appreciated.

That's a great suggestion to use a backup to create the development environment; I wouldn't have thought of...

Chris makes a good point. It's unclear from your initial post what a single row in the fact table represents. A transaction? A product price snapshot?

Sergiy (10/11/2016)

---

You may add ROW_NUMBER to the recordset being inserted and add its values to MAX (ID ) of the table:

begin transaction

declare @MaxID bigint

select @MaxID + MAX(ID) From TargetTable (TABLOCKX)

INSERT...

After saving the CSV, open it using Notepad or some other text editor. Do not use Excel to open CSV files.

Try exporting from Excel to CSV and importing from the CSV.

komal145 (10/11/2016)

---

I think to be more specific, i am deploying the solution from visual studio. the other solution has no issues. only the solution which I am working has this.

Why...

komal145 (10/11/2016)

---

I have created a project parameters at my solution level and after i deploy the solution to the server ,at Integration Service catalog level i have to configure my...

wendy elizabeth (10/11/2016)

---

I provided the ddl on the original post. here is sample data:

SELECT [lockID] = 4336

,[schoolID] = 134

...

You have been here long enough to know that

a) You should use IFCodes around your SQL code

b) You need to include INSERT statements to populate your source tables with some...

GilaMonster (10/11/2016)

---

Brandie Tarvin (10/11/2016)

---

GilaMonster (10/10/2016)

---

North. The flight goes over Greenland...

pavan.msbi558 (10/10/2016)

---

Smart answer Phil

But I don't have 64 bit system ..and I read all installion guides and requirements .but any where not specify the is it for only 64 bit...

I know that you mentioned the details above. And I mentioned the reason for the error above.

Then you tried...

Are you receiving this error on a 64-bit system?