Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Job Fails running SSIS package?
Since submitting my earlier posting the issue I had has now been resolved. Turning on the server logging was a definite help as it identified that the issue was due to the variable in the package using a mapped drive path rather than UNC path. I found MS KB article nbr 918760 to be very...- cehall2
- Post #18
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SQL Job Fails running SSIS package?
I am also experiencing the same issue with a SQL server agent job failing when importing data from excel into a db. The weird thing is that there is another job loading data from excel into a different db which runs successfully. Both jobs have been setup in the same way both with protection...- cehall2
- Post #17
- Forum: Microsoft SQL Server: Integration Services (SSIS)
