Two options:

1) Remove the IDENTITY definition on the destination table and insert as usual.

2) Set identity insert on during the import and insert as usual.

johnnycash (1/30/2013)

---

Thank you all and yes, I agree that all this should be done at the presentation layer and not at the DB level, but this is one of those...

cafescott (1/29/2013)

---

I discovered this page:

http://sqlserverdownanddirty.blogspot.com/2011/07/ssis-execute-process-task-hangs-when.html

I added the SEE_MASK_NOZONECHECKS environment variable to the server that houses the SQL installation where my package resides. It now works as a job! ...

Use the Advanced Editor on your data sources to have a look at all the datatypes involved & see whether that gives you any clues.

It's difficult to provide more advice...

It's probably not relevant, but I thought I'd post just in case. Did you know that if you copy a batch file to another server and then run it, it...

You could try a MERGE JOIN from t1.name to t2.city, join type = FULL.

cafescott (1/29/2013)

---

Your initial...

cafescott (1/29/2013)

---

Phil Parkin (1/29/2013)

---

The job is probably running under the credentials of the SQL Agent user.

This user may not have permissions to the various files involved - I suggest that...

The job is probably running under the credentials of the SQL Agent user.

This user may not have permissions to the various files involved - I suggest that you investigate this...

I second Eugene (whose middle name may well be ssCrazy 🙂 ) - best practice is to use YYYY-MM-DD format when specifying dates in T-SQL:

WHERE orderdate >= '2010-10-31'

I echo others' comments about DDL ...

But also noticed that your SQL has a spurious comma between

't2.dbo.tblQuestions.Question'

and 'FROM'

quillis131 (1/23/2013)

---

samvanga (1/22/2013)

---

You may want to look at BIML (Business Intelligence Markup Language). It comes with BIDS Helper.

It's metadata driven and allows you to automate SSIS package generation.

I've implemented this...

I imagine so.

At worst, SSIS can create the file locally and then you can use a Script Task with whatever C# code is required to achieve this.

But never tried...

vax09 (1/24/2013)

---

I need to store results of two ssis package into one excel sheet.

columns are defined but the problem is when i run the second package it start from...

Why not get yourself a copy of SQL Server Express 2012 and restore the db to an instance there.

Here's a link. You should get one of the Management Studio versions...