The flat file connection manager in SSIS shows that "A valid file name must be selected"

Question

                      (Flat File Location)
                    Samba Share | Windows share
(SSIS) _______________________________
                | |
XP 32bit | Works | Works
                | |
2003 Serv 32bit | Works | Works
                | |
Vista 64bit | ERROR | Works
                | |
Win 7 64bit | ERROR | Works
                | |
2008 Serv 64bit | ERROR | Works

---

I created an SSIS package in VS 2008 that parses a flat file from a shared folder and puts the records in db SQL Server.

I recently installed Windows 7 and VS 2008 on a new workstation. When I import a package from TFS and open it, I get an error

. : MySSISPackage: "\\ shared\flatfile.txt" .

, :

, - "" - .

(Windows XP), , . , .

, , ?

---

UPDATE: .dtsx SSIS , :

: \\shared\flatfile.txt, , .

...

: "MySSISPackage".

...

: . .

---

2:

a) , , - Samba Unix.

b) SSIS 64- (64- Windows 7, 64- Windows Server 2008), " ".

c) SSIS 32- (32- 32- Windows XP, 32- Windows Server 2003) .

d) Windows, 64- SSIS .

Answer 1

. , , I, . "" Run64BitRuntime = "False". Excel 32-, SSIS 64- .

Answer 2

. , -, . , , .

.: \\ server\share\foder\subfold1\subfold2\file.csv < == == "subfold2" , \\ \\

, \\\share\ .

Answer 3

BIDS ( SSIS), SSIS ( ) " ".

, http://www.sqldev.org/sql-server-integration-services/flat-file-connection-manager-problem-32774.shtml

Answer 4

, , , - . : \server\filepath\filename.txt c:\filepath\filename.txt .

Answer 5

, , , , DelayValidation = True false. SSIS, , , BIDS .

Answer 6

SQL Server ?

SQL Server ? , SQL , , .

Answer 7

CIFS.

Windows 7 Server 2008 , , SSIS CIFS . 1 , , .

1: → → → → → : LAN Manager : LM NTLM -use NTLM2,

2: IP v.6

3: TCP/IP Netbios.

Answer 8

SQL 2008 R2, SSIS, Windows 2008. . :

The file name property is not valid. The file name is a device or contains invalid characters.

, , SQL Server .