sql server - SSIS Connection to source -


i have issue while executing ssis package.

i able connect source using ssms (the source sql server 11.0), , run sql select statement.

but when i'm using ssis package same user, i'm getting issue :

0x80004005 : login failed user 'xxx'

on source, user listed in database users db_datareader.

so, rights let ssis retrieve data.

thanks,


Comments

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

javascript - jQuery date picker - Disable dates after the selection from the first date picker -