Showing posts with label provider. Show all posts
Showing posts with label provider. Show all posts

Sunday, March 11, 2012

DTS Package Error - Something simple?

I have a multi-step DTS package that I get the following error when I try to execute it:

Package Error
Error Source : microsoft ole db provider for sql server
Error Description : [DBNETLIB][ConnectionOpen (connect()).]SQL Server does not exist or access denied

Am I missing something obvious? I'm sure it is something simple but I can't seem to get it. Thank you in advance for you assistance.It means the package can't connect to a data source it wants to connect to. Open up the package in Design mode and look at the connection properties. Check that the server name, the authentication method, and the username and password are correct.

Friday, March 9, 2012

DTS Package - "Provider generated code execution exception: "EXCEPTION_ACCESS_VIOLATION"

When running a step within my DTS package I'm receiving the following
error - "Provider generated code execution exception:
"EXCEPTION_ACCESS_VIOLATION".
I think it may be something to do with my global variable, but I'm not
sure as I'm pretty certain I've set it all up correctly.
Below are screenprints showing my settings.
http://img153.imageshack.us/my.php?image=19tv1.jpg
http://img153.imageshack.us/my.php?image=25wz1.jpg
http://img153.imageshack.us/my.php?image=39pf.jpg
http://img164.imageshack.us/my.php?image=43nx.jpg
http://img164.imageshack.us/my.php?image=51ao.jpg
http://img164.imageshack.us/my.php?image=64lo.jpg
http://img164.imageshack.us/my.php?image=71yn.jpg
Any advice of fixing this would be greatly appreciated.Can anyone help? The below screenshots show my specific settings (note
I'm still getting the same error with these options)
http://www.files2net.com/files/46053431/1.JPG
http://www.files2net.com/files/266513949/2.JPG
http://www.files2net.com/files/266955779/3.JPG

DTS Package - "Provider generated code execution exception: "EXCEPTION_ACCES

When running a step within my DTS package I'm receiving the following error
- "Provider generated code execution exception: "EXCEPTION_ACCESS_VIOLATION"
.
I think it may be something to do with my global variable, but I'm not sure
as I'm pretty certain I've set it all up correctly.
Below are screenprints showing my settings.
http://img153.imageshack.us/my.php?image=19tv1.jpg
http://img153.imageshack.us/my.php?image=25wz1.jpg
http://img153.imageshack.us/my.php?image=39pf.jpg
http://img164.imageshack.us/my.php?image=43nx.jpg
http://img164.imageshack.us/my.php?image=51ao.jpg
http://img164.imageshack.us/my.php?image=64lo.jpg
http://img164.imageshack.us/my.php?image=71yn.jpg
Any advice of fixing this would be greatly appreciated.Can anyone help? The below screenshots show my specific settings (note I'm s
till getting the same error with these options)
http://www.files2net.com/files/46053431/1.JPG
http://www.files2net.com/files/266513949/2.JPG
http://www.files2net.com/files/266955779/3.JPG|||Managed to solve it by changing the settings to the following:
http://www.files2net.com/files/154842170/settings.jpg