Viewing 5 posts - 1 through 5 (of 5 total)
If you set up a linked server to the external file, that should work.
July 16, 2009 at 8:29 am
#1025695
No. The only reason the "import/export wizard" "automatically" create the table is because in the underlying package it has "create table" tasks.
In the meantime, if you have lots of data,...
July 16, 2009 at 8:25 am
#1025691
Is the job owner yourself? Try change it to NT AUTHORITY\SYSTEM, and that should fix the problem.
July 16, 2009 at 8:12 am
#1025678
1-part name: dm_tran_locks
2-part: sys.dm_tran_locks
3-part: yourdb.sys.dm_tran_locks
4-part: yourinstance.yourdb.sys.dm_tran_locks
June 26, 2009 at 8:41 am
#1016072
It seems to me that you are were doing an inner join of the two views, causing data for some person who has data in this view but no data...
October 31, 2007 at 12:36 pm
#747214