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?

sappidi06 (10/10/2016)

---

I have the expressions defined in

1)Collection> Enumerator Configuration: Folder: C:\Users\ssappidi\Desktop\Uploads and 2)Foreach Loop Editor>Expressions> Directory @[User::FolderName]

Also i have declared a FolderName Variable and gave the...

rsampson (10/10/2016)

---

Mine is relatively close to this one.

My process deletes files from archive after x days.

I hit the loop and get the same complaint, but I've previously

moved 1 file to...

sappidi06 (10/10/2016)

---

Hi,

I am trying to load an excel file and update it on the database inside the for each loop in SSIS. When i execute the For each loop container...

mcfarlandparkway (10/10/2016)

---

I have a quick question, Instead of hardcoding or pasting a query in Execute sql task (SSIS package) Is there a way not to hardcode it?

I mean source is...