question

sangeethanag avatar image
sangeethanag asked

[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
ssissql-servererror-message
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
ThomasRushton avatar image
ThomasRushton answered
Check the account under which the SSIS job runs to see if that has access to the share / directory where the file is.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

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.
2 Likes 2 ·
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.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.