<to*****@yahoo.com> wrote in message
news:11**********************@z14g2000cwz.googlegr oups.com...
hello!
i am trying to import a text file using dts into a table created by the
package. everything checks out until it is run. the table is created
but then i get an error:
"need to run the object to perform the operation. Provider generated
code execution exception EXCEPTION_ACCESS_VIOLATION"
any ideas?
this is a development box. maybe the server cant handle it?
thanks in advance!
Tom
You don't mention your version of MSSQL, but here are a couple of related KB
articles:
http://support.microsoft.com/kb/268413/EN-US/ http://support.microsoft.com/kb/271889/EN-US/
Another possibility is to try setting the task to execute on the main
package thread:
http://www.sqldts.com/default.aspx?232
If that doesn't help, you might want to post to
microsoft.public.sqlserver.dts, with more details of your environment and
exactly what task is failing.
Simon