Tom.Thomson (3/8/2011)

---

Interesting question.

There is however a problem with use of imprecise English - this is of course sheer nit-picking, and I'm not complaining because I guessed that the...

I can imagine that an account called "Local System" doesn't have access to a remote folder.

There are two options:

* configure SQL Server Agent to run under a custom account that...

GSquared (3/8/2011)

---

Koen Verbeeck (3/8/2011)

---

In the somewhat special case of ETL, I'd sometimes like to turn of logging.

If a data load fails, the destination table can be truncated and the load...

Yes, it is the one called SQL Server Agent.

It is the account listed under built-in account that is important. That account should have permissions to access the remote folder.

The Integrations...

If you click on services, you can see all the SQL Server services that are running on the server on the right side of the screen.

There should be a service...

For the moment, Sonal, forget about datareaders and sqlbulkcopy. Those are .NET classes you can use in a script task.

We'll go for the linked server strategy, as it is the...

Normally the SQL Server Agent account runs...

Palash Mitra (3/8/2011)

---

Hi Koen,

Was missing just that! Thanks a ton!

Went to registry and updated TypeGuessRows to 0; only this time @HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\12.0\Access Connectivity Engine\Engines\Excel.

And the dataflow worked just fine. However, there...

Allright, I'll be your teacher.

You can pay me with PayPal if you want 😉

You can use a SQL query with a left outer join to determine if a row is a new one or not.

This is not a very fast and efficient method...

Is there a question?

Or are you just shamelessly promoting a website?

If it is the latter, your link doesn't work.

Setting TypeGuessRows will help if the JET provider is used, it doesn't really matter if it is the Excel source or a script task using OLE DB.

There is an equivalent...

Does the SQL Server Agent Account has the necessary permissions to access that remote folder?

sql_2005_fan (3/7/2011)

---

its stored in sql server. I was able to open the package in BIDS.

But if I modify the package on my local copy(visual studio) , how can I update...

I answered...