Post reply

excel source connection in SSIS

  • January 15, 2009 at 3:00 am

    #128040

    I create a source that points to an excel file. the data from excel is dumped into a table. while executing the package, it gives me the error of 'cannot acquire connection' with the excel source.

    any suggestions as to how can i handle the error

    Thanks

  • January 15, 2009 at 3:26 am

    #927149

    This usualy means that the file is not in the location that you specifed, check that it is.

  • January 15, 2009 at 3:47 am

    #927156

    File is present at that location. Have checked it again.

    Thanks,

  • January 15, 2009 at 3:55 am

    #927160

    Are you still having the same error?

    Are you able to preview the spread-sheet in the file connection manager?

  • January 15, 2009 at 4:05 am

    #927167

    Ya. The data can be viewed when we preview through the connection manager. The file location is also correct.

    There seems to be some other problem with it.

  • January 15, 2009 at 4:08 am

    #927169

    Seems like it may be a security issues then, Are you running this package from a SQL server agent job?

    If so does this agent have the appropriate permissions to access this file?

Viewing 6 posts - 1 through 5 (of 5 total)

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