Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
azero
Starting Member
3 Posts |
 Posted - 2007-06-06 : 21:16:23
|
| Hello everyone, I'm having difficulties in Importing data using DTS with a SQL Query.The Sql query :SELECT *FROM Organisations where Organisations.OrganisationID = 1I receive this Error Message :Error Source : Microsoft OLE DB Provider for SQL ServerError Description : Deferred prepare could not be completed.SELECT permission denied on object 'Organisations', database 'souce_db', owner'dbo'.Context : Error calling GetColumnInfo. Your Provider does not supprt all the interface/methods required by DTS.Can anybody help me . Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-06-07 : 10:30:58
|
| The user doesn't have select permission on the table.Use the profiler to see which login you are connecting with and give the mapped user in the database permission on the table (or use a different login).==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS Import/Export Data Error