ͨ¹ýMSSQL Server Agent Ö´ÐÐDTS °üµÄÎÊÌâ
ÖÆ×÷ÁËÒ»¸öDTS°ü£¬Äܹ»¿ª·¢»·¾³»òÕßÃüÁîÐÐÏÂÕýÈ·µÄÖ´ÐУ¬µ«ÔÚͨ¹ýAgent À´Ö´ÐеÄʱºò×ÜÊDZ¨´í£º
DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step DTSRun OnError: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step, Error = -2147467259 (80004005) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 Error Detail Records: Error: 5 (5); Provider Error: 5 (5) Error string: Error opening datafile: Access is denied. Error source: Microsoft Data Transformation Services Flat File Rowset Provider Help file: DTSFFile.hlp Help context: 0 DTSRun OnFinish: Copy Data from PRODFILE to [CompanyXYZDB].[dbo].[PRODFILE] Step DTSRun: Package execution complete. Process Exit Code 1. The step failed.
»òÕßÊÇÈçÏ´íÎó£º
´íÎóÔ´: Microsoft OLE DB Provider for Oracle °ïÖúÎļþ: °ïÖúÉÏÏÂÎÄ: 0 ´íÎóÏêϸ¼Ç¼: ´íÎó: -2147467259 (80004005); Ìṩ³ÌÐò´íÎó: 0 (0) ×Ö·û´®´íÎó: ûÓз¢ÏÖ Oracle ¿Í»§¶ËºÍÍøÂç×é¼þ¡£ÕâЩ×é¼þÓÉ Oracle ¹«Ë¾Ìṩ£¬ÊÇ Oracle 7.3.3°æ(»ò¸üÐÂ)¿Í»§¶ËÈí¼þ°²×°µÄÒ»²¿·Ö¡£ ÌṩÕß½«ÎÞ·¨Ê¹ÓÃÖ±µ½ÕâЩ×é¼þ±»°²×°ÎªÖ¹¡£ ´íÎóÔ´: Microsoft OLE DB Provider for Oracle °ïÖúÎļþ: °ïÖúÉÏÏÂÎÄ: 0 DTSRun OnError: DTSStep_DTSExecuteSQLTask_5, Error = -2147467259 (80004005) ×Ö·û´®´íÎó: ûÓз¢ÏÖ Oracle ¿Í»§¶ËºÍÍøÂç×é¼þ¡£ÕâЩ×é¼þÓÉ Oracle ¹«Ë¾Ìṩ£¬ÊÇ Oracle 7.3.3°æ(»ò¸üÐÂ)¿Í»§¶ËÈí¼þ°²×°µÄÒ»²¿·Ö¡£ ÌṩÕß½«ÎÞ·¨Ê¹ÓÃÖ±µ½ÕâЩ×é¼þ±»°²×°ÎªÖ¹¡£ &
Ïà¹ØÎĵµ£º
sql´æ´¢¹ý³Ì½Ì³Ì
[ËѼ¯ÕûÀí]sql´æ´¢¹ý³ÌÍêÈ«½Ì³Ì
Ŀ¼
1.sql´æ´¢¹ý³Ì¸ÅÊö
2.SQL´æ´¢¹ý³Ì´´½¨
3.sql´æ´¢¹ý³Ì¼°Ó¦ÓÃ
4.¸÷ÖÖ´æ´¢¹ý³ÌʹÓÃÖ¸ÄÏ
5.ASPÖд洢¹ý³Ìµ÷ÓõÄÁ½ÖÖ·½Ê½¼°±È½Ï
6.SQL´æ´¢¹ý³ÌÔÚ.NETÊý¾Ý¿âÖеÄÓ¦ÓÃ
7.ʹÓÃSQL´æ´¢¹ý³ÌÒªÌرð×¢ÒâµÄÎÊÌâ
1.sql´æ´¢¹ý³Ì¸ÅÊö
ÔÚ´óÐÍÊý¾Ý¿âϵͳÖУ¬´æ´ ......
ÏàÐźܶàASP+MSSQLµÄÍøÕ¾¶¼Óб»ÈË×¢Èë¹ýµÄ¾Àú£¬Êý¾Ý¿â±íÖжàÁËһЩ±í£¬ÀàËÆÒÔϵıíD99_tmp,D99_cmd£¬kill_kk¡£
D99_tmp£¨subdirectory,depth,fileÈý¸ö×ֶΣ¬ÀïÃæµÄÊý¾Ý¶¼ÊÇÍøÕ¾ÎļþºÍĿ¼£©
MSSQLÊý¾Ý¿â´æÔÚ¼¸¸öΣÏÕµÄÀ©Õ¹´æ´¢¹ý³Ì£¬Ä¬ÈÏPublic×é¿ÉÖ´ÐÐȨÏÞ£¬SQL×¢ÈëÕß¿ÉÀûÓô˶ÁÈ¡ÎļþĿ¼¼°Óû§×飬²¢¿Éͨ¹ýÏÈдÈëÊý¾ ......
Sql2005ÖÐʹÓÃow_number() partition½øÐзÖ×éʵÑ飬
SQL£º
select * from stu
select id,row_number() over (partition by snm order by id) from stu
½á¹û£º
id snm
----------------
111 111V
111 111W
222 222N
333 3123
444 3123
555 3123
666 3232
777 3232
--·Ö×éºóµÄ½á¹û
id &n ......