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 |
|
ozsql
Starting Member
14 Posts |
 Posted - 2009-09-22 : 05:22:27
|
| Hi Guys,I am trying to run package in SSIS and I am getting data validation error. Error: SSIS logging provider has failed to open the log. error code: 0x80070003.I have checked the event log path, as well as output file path and I can see the GLCenter_stageload.dtsx in bin folder. However, I have noticed one thing I am running driver_Zone package it’s trying to contact GLCenter. Can anyone specific which path do I need to check.Note: Package was developed by another developer and he is no more with our company. We use common event log folder and output folder. However, when I run the package I am getting above errorCan anyone shed some light please.Thanks,D |
|
|
Rajeev_calling
Starting Member
10 Posts |
Posted - 2009-09-22 : 07:36:06
|
| I am new to SQL server database , not having much idea how can i create a package or from where to start. Database at present is fully functional i.e it has tables,procedures...One of my task is to create a SSIS package(i have little idea about DTS pacakge in sql server 2000, but never created). My task is to read a flat file and then to call stored procedure based on that.Any help would be appreciated. Thanks! |
 |
|
|
ozsql
Starting Member
14 Posts |
Posted - 2009-09-22 : 09:02:33
|
| You need to develop views first joining multiple tables as per the requirements and then create package. Note: you need to select query pointing to source in connection manager so your run query based the one you created in view. They lot'z of other ways to create packages it depends on your requirement.If you are new to SSIS need to download video based tutorials available from AppDev, watch those videos and create packages. You can download it from rapidshare you need to download all the 13 parts : http://filespump.com/download_file.php?file=12238676&desc=appdev+c+sharp+8cds+coursebook+completed.part01.rar All the best |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-22 : 09:41:06
|
| ozsql,Are you running the package from Visual Studio? Or from the command line? SQL Agent?Is this error when run on your machine or on the server?Have you checked that the permissions are correct? |
|
|
|
ozsql
Starting Member
14 Posts |
Posted - 2009-09-22 : 23:56:00
|
| Yellow Bug,I am running package from Visual Studio on my machine and connected different database. Where do i need to check permissions. Log event path is pointing to my c drive.I means SQL server permission or SSIS.ERROR Messgae: TITLE: Package Validation Error------------------------------Package Validation Error------------------------------ADDITIONAL INFORMATION:Error at Test_ETL [Log provider "SSIS log provider for XML files"]: The SSIS logging provider has failed to open the log. Error code: 0x80070003.The system cannot find the path specified. (Microsoft.DataTransformationServices.VsIntegration)------------------------------BUTTONS:OK------------------------------Thanks,D |
|
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-23 : 03:41:08
|
| As it's from Visual Studio on local machine, it is unlikely to be a permission issue.Check which connection the log file is writing to:From the menu, select SSIS --> Logging.. -->Check the properties of the log file connection manager.Does this refer to a valid file path?If it is an expression, ensure that it does generate a proper file path. |
|
|
|
|
|
|
|
|
Data Validation Error