x

[Connection manager "SourceFlatFileConnection"] Error: The file name property is not valid.

SSIS ERROR : SourceFlatFileConnection:

Not able to open the path when SSIS package runs.But manually when trying to open we are able to open the file path with no issues.

Error at line : Dts.Connections("SourceFlatFileConnection").ConnectionString = filepath.Trim()

Error : The file name is a device or the path is not valid. Request you to let me know any others suggestions on the same

Please suggest how to proceed on this further.

Thanks for help.

Sangeetha N

more ▼

asked Jan 13, 2015 at 10:00 AM in Default

avatar image

sangeethanag
1 1 1 3

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Check the account under which the SSIS job runs to see if that has access to the share / directory where the file is.

more ▼

answered Jan 13, 2015 at 10:38 AM

avatar image

ThomasRushton ♦♦
42k 20 50 53

Thanks a lot for quick response

actually am new to SSIS.

Where exactly we can come to know on which account the SSIS is running ?

when i have checked for the SYSTEM : @[Username] by default its using sysytem login. It was taking my credentials only.

Jan 13, 2015 at 11:03 AM sangeethanag

How are you executing the package? Manually from a workstation? Or via a SQL Agent job? If the former, it will use your credentials to execute the package and your credentials would need access to that file location. If the latter, the account that is running the SQL Agent service would need access to the file share as well.

Jan 13, 2015 at 01:05 PM JohnM
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1219
x445
x89

asked: Jan 13, 2015 at 10:00 AM

Seen: 1740 times

Last Updated: Jan 14, 2015 at 11:04 PM

Copyright 2017 Redgate Software. Privacy Policy