Test Credentials SQL server 2008

• pt9s

  SSC Veteran

  Points: 296

  More actions

  October 19, 2010 at 11:14 am

  #149034

  I'm trying to build a scheduled job to execute an SSIS Package. The package is supposed to open a file and import it. Server makes the file in my database but it's empty. It seems like my local network doesn't accept the credential the job is suppose to be running as.

  I created a proxy and gave it a credential with my network login info, but it's not working.

  Any thoughts?

  I watched this video and followed every step.

  http://msdn.microsoft.com/en-us/library/dd440761(SQL.100).aspx

• SQLDCH

  SSChampion

  Points: 11640

  More actions

  October 19, 2010 at 11:48 am

  #1239245

  Check your error logs, they should give you some direction why the file isn't being populated.

  ----------------------------------------------------------------------------
  Sacramento SQL Server users group - http://sac.sqlpass.org
  Follow me on Twitter - @SQLDCH
  ----------------------------------------------------------------------------

  Yeah, well...The Dude abides.