| Author |
 Topic  |
|
|
inbs
Aged Yak Warrior
821 Posts |
 Posted - 04/03/2012 : 05:20:30
|
hi
i have access file that conncet to sharepoint database.
it hold serveral tables
i want load to sql DB a table(example TableA) from access.
i do it it in ssis successfuly.
the problem is ,when i save the package in msdb and run it in job, it fail with error:
(i think it related to the user name and password when i click on table(TableA) in access, but in ssis i do not insert any username,password and it run ok otherwise it fail).
Description: No column information was returned by the SQL command. End Error Error: 2012-04-03 12:02:36.01 Code: 0xC004706B Source: Load Data SSIS.Pipeline Description: "component "OLE DB Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA" |
|
|
yosiasz
Flowing Fount of Yak Knowledge
USA
1610 Posts |
Posted - 04/03/2012 : 14:47:59
|
what security context is it running under when deployed? and does it have permissions to access file
<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion |
Edited by - yosiasz on 04/03/2012 14:48:26 |
 |
|
|
inbs
Aged Yak Warrior
821 Posts |
Posted - 04/03/2012 : 16:25:27
|
| where i can see security context ? |
|
|
|
yosiasz
Flowing Fount of Yak Knowledge
USA
1610 Posts |
Posted - 04/03/2012 : 17:51:23
|
the ssis package is running as which user?
<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion |
|
|
|
inbs
Aged Yak Warrior
821 Posts |
Posted - 04/04/2012 : 03:36:21
|
ok
i create the ssis package with MyUser and run it with MyUser
(i get a window that i need to connect to sharepoint DB - so i insert the SharePoint User)
in SQL job i run it with aonther User -(user in service)
thanks |
|
|
|
yosiasz
Flowing Fount of Yak Knowledge
USA
1610 Posts |
Posted - 04/04/2012 : 11:24:18
|
actually if you search this issue it seems that it has to do with something related to casing , upper case , lower case. so source data and destination data have mismatch on casing. can you verify
<><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion |
|
|
|
inbs
Aged Yak Warrior
821 Posts |
Posted - 04/04/2012 : 16:59:09
|
| i don't think so, because in my DEV it run but in my PROD id dosent' run. and DEV it same like PROD |
|
|
| |
Topic |
|
acces in ssis
