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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2012-04-03 : 05:20:30
|
| hii have access file that conncet to sharepoint database.it hold serveral tablesi 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
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-04-03 : 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 |
 |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2012-04-03 : 16:25:27
|
| where i can see security context ? |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-04-03 : 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
860 Posts |
Posted - 2012-04-04 : 03:36:21
|
| oki 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
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-04-04 : 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
860 Posts |
Posted - 2012-04-04 : 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 |
|
|
|
|
|
|
acces in ssis