iamsql1 (2/4/2013)

---

Hi Phill

I am newbie to SSIS, i tried every effort to change the variable in olde db...

iamsql1 (2/4/2013)

---

HI

i have an idea. can i use a stored procedure and get it executed in EXECUTE SQL TASK

instead...

Not in this forum! 😉

Anyone else picturing a man with a big hammer? 🙂

Excel 2003 has a maximum number of rows of 65,535 - maybe that is the cause of your error.

Try exporting to CSV instead to see whether that is the reason.

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'