Viewing 15 posts - 3,226 through 3,240 (of 3,738 total)
You might want to restate your question and provide additional details.
May 10, 2011 at 9:54 am
stormsentinelcammy,
Do you have a Network Admin that could help you check on the permissions?
Regards,
Welsh
May 10, 2011 at 9:37 am
Try the following URLs:
May 10, 2011 at 7:40 am
If you create an ODBC Connection on the box, you will see a version number of the DLL.
That will tell you what you have.
It almost sounds like you have a...
May 9, 2011 at 1:50 pm
I asked if you could log on using the SQL Server Agent Credentials and perform the same actions that you did using your admin account.
Do not logon as yourself, log...
May 9, 2011 at 1:39 pm
That is interesting.
Can you create an ODBC Connection to the Other Databases and click on Test Connection?
May 9, 2011 at 12:45 pm
You may want to consider scripting out the tables and providing some dummy data.
May 9, 2011 at 12:37 pm
Would it be possible to RDP into the Server and Log on using the Service Account.
Could you try it and rule out the permissions?
What account do you use when you...
May 9, 2011 at 11:53 am
Hi,
You may want to post the schema involved as well as some sample data to get a better response.
Regards,
Welsh
May 9, 2011 at 11:31 am
Can you drop the Indexes prior to the load and then recreate them?
That would speed up the process and help with the fragmentation.
May 9, 2011 at 11:02 am
As stated in the error message "You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details"
Try the steps listed in the...
May 9, 2011 at 10:39 am
Sounds like a permissions issue.
Can you log on using the SQL Server Agent Service Account and run the SSIS Package interactively?
Also try to navigate to the Path of the File...
May 9, 2011 at 10:28 am
The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered.
Yes as Dave stated it appears that you are missing the proper DLL for Access.
Try creating an ODBC COnnection for Access and...
May 9, 2011 at 10:14 am
Please do not double post in which several people tried to help you
Continue to ask questions since this is a continuation of your original thread located at:
http://www.sqlservercentral.com/Forums/Topic1104016-391-1.aspx#bm1104172
May 7, 2011 at 2:15 pm
Viewing 15 posts - 3,226 through 3,240 (of 3,738 total)