Excel file connection in package -- sql server dts

PD
11/27/2005 3:54:34 PM

I am using an Excel connection in my DTS package. After running the
package in DTS Designer, I tried to open the Excel file using the Excel
application. I get a message saying "Excel can't access <filename>".
Any ideas on what caused the error would be appreciated.

Allan Mitchell
11/28/2005 12:10:47 AM

Could the file be locked?

On the workflow properties of the Data Pump task there is a setting
entitled "Close Connection On Completion"

Allan

[quoted text, click to view]

PD
12/3/2005 12:17:27 AM

This did the trick thanks! I wonder why closing all connections when
execution ends isn't automatic package behavior though.

Allan Mitchell
12/3/2005 1:55:11 AM

Hello PD,

Perhaps cost associated with reopening the connection

Allan

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server dts

sql server dts : Excel file connection in package