SSIS Login Problem/Error.

• rocky_498

  SSCertifiable

  Points: 6532

  More actions

  November 14, 2014 at 10:55 am

  #313030

  Hi,

  I need help. I created very simple SSIS Package (read data from csv file and insert into sql table. Now I want to use or execute this .dtsx package from web services in C# Code. Everytime user try to run having login issue problem. I tried two things

  1) Change OLE DB DESTINATION User/P.W to (USE WINDOW AUTHENTICATION)

  2) Change OLE DB DESTINATION user/P.w to (User Name and P.W) and save this user name and p.w to Config file.

  In both cases i m having problem.

  Two question here.

  1) I am moving my .dtsx package from one drive to other drive where user can easily access. Only one .dtsx package not a whole solution + .config file. It will be a problem or not?

  2) Do you think it will solve my problem if, I use two variables 1) @username 2)@Password for OLE DB DESTINATION and pass the value from C# CODE through web services?

  Please advise, its urgent.

  Thank You.