Test Credentials SQL server 2008

  • 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

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply