开发者

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

开发者 https://www.devze.com 2023-01-10 04:15 出处:网络
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.

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

精彩评论

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

关注公众号