开发者

Connecting to a File share with a flat file source in SSIS2005

I have created a SSIS package in BIDS005 that uses a flat file source as the input. The file I am wanting to use doesnt exist on my local machine, or on the server where the package will be executed. The file exists on a file share on another server, however when I try开发者_Python百科 to use the server path for example:

\\servername\fileshare$\filename.csv

I get an error message saying:

A valid filename must be selected

Any ideas why this is happening?


It could be a permissions problem. Do you have a valid connection to the file containing the userID & pwd to connect to the share drive?

Is it a problem in the development environment, or only when deployed?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜