tags:

views:

24

answers:

1
Q: 

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 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?

A: 

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?

Beth  2010-08-05 15:58:09
The problem only exists when its deployed, even though the SQLEXEC account that it runs under has access to the share
Matt  2010-08-05 16:01:06
it seems to have an issue with finding the file when using the \\servername\fileshare$\filename.csv syntax. Yet if I run the package with a drive mapped to the fileshare using the U:\filename.csv syntax the package executes fine
Matt  2010-08-05 16:03:45
OK, can you test it logged in as the SQLExec account and access the file with the \\servername syntax? There may be something shut off about that type of access that has nothing to do with ssis
Beth  2010-08-05 16:09:40
logged in a SQLExec I can open the file using \\servername syntax from the run command... really strange!
Matt  2010-08-05 16:18:10
then it may be a limitation of SSIS. Is there a problem using a drive letter mapped on the server?
Beth  2010-08-05 16:28:48

related questions

Backup SQL Schema Only?
Sql to query a dbs scheme
Timer-based event triggers
Sql query, count and group by
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting
How do I use T-SQL Group By
What all do I need to escape when sending a (My)SQL query?
Split String in SQL
Datatable vs Dataset
ASP.NET MVC "CRUD" Database Sample
Convert HashBytes to VarChar
Best Book for a new Database Developer
What is the best way to avoid SQL injection attacks?
What language do you use for Postgresql triggers and stored procedures?
What is the best way to handle multiple permission types?
How do I index a database field
Swap unique indexed column values in database.
cx_Oracle - what is the best way to iterate over a result set?
cx_Oracle - How do I access Oracle from Python?
Is there a version control system for database structure changes?
How to export data from SQL Server 2005 to MySQL
ASP.NET Site Maps
Decoding T-SQL CAST in C#/VB.net
Flat File Databases in PHP