Viewing 15 posts - 9,871 through 9,885 (of 11,678 total)
Phil Parkin (3/8/2011)
Not in the package, but within the job set-up.
Waw, what a close finish! :w00t:
March 8, 2011 at 7:39 am
In a SQL Server Agent jobstep, you have a dropdown box right under Run As:. In that dropdown box you can select from the various proxies.
March 8, 2011 at 7:31 am
Tom.Thomson (3/8/2011)
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...
March 8, 2011 at 7:25 am
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...
March 8, 2011 at 7:16 am
GSquared (3/8/2011)
Koen Verbeeck (3/8/2011)
If a data load fails, the destination table can be truncated and the load...
March 8, 2011 at 6:47 am
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...
March 8, 2011 at 6:24 am
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...
March 8, 2011 at 5:41 am
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...
March 8, 2011 at 5:33 am
smac (3/8/2011)
That server has a Everyone account and users, wouldn't the SQL Agent fall under one of those two?I don't know permissions that well.
Normally the SQL Server Agent account runs...
March 8, 2011 at 5:11 am
Palash Mitra (3/8/2011)
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...
March 8, 2011 at 4:59 am
soufya91 (3/8/2011)
please don't suggest me to read tutorials i want some one to be my teacher
Allright, I'll be your teacher.
You can pay me with PayPal if you want 😉
March 8, 2011 at 3:29 am
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...
March 8, 2011 at 3:27 am
Is there a question?
Or are you just shamelessly promoting a website?
If it is the latter, your link doesn't work.
March 8, 2011 at 3:22 am
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...
March 8, 2011 at 3:19 am
Does the SQL Server Agent Account has the necessary permissions to access that remote folder?
March 8, 2011 at 2:56 am
Viewing 15 posts - 9,871 through 9,885 (of 11,678 total)