Hi Everyone, I am trying to set the file location to a network path in my Flat File Connection, but the issue is that the location requires a username and password to access the file. Where can I save the credentials for a flat file connection?

You mean you need to make the share and then connect? If so see this MSDN post in which you issue a NET Use command: http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/aea4a334-bc13-4fd2-aa59-6d31dfcc45e2/Arthur My Blog

The shared folder already exists. I need to create a package that connections to a CSV in that share. How do I save the username and password of the shared folder in my ssis package? I do not have access to the SQL Server box...I can only develop and deploy packages.

The shared folder already exists. I need to create a package that connections to a CSV in that share. How do I save the username and password of the shared folder in my ssis package? I do not have access to the SQL Server box...I can only develop and deploy packages. Did you check the link posted by ArthurZ ? It answers your question.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

I apologize I didn't explain myself properly. This is not a Windows network drive. It's a URL link to a csv file. ie. https://test.com/reports/mydata.csv Maybe I need to use a Script Task and pull the CSV file then pass it to a data flow task. How can I pass a file from a Script Task to a Data Flow task?

I apologize I didn't explain myself properly. This is not a Windows network drive. It's a URL link to a csv file. ie. https://test.com/reports/mydata.csv Maybe I need to use a Script Task and pull the CSV file then pass it to a data flow task. How can I pass a file from a Script Task to a Data Flow task? You have to create a script to download from HTTP . Check this script for reference. After you download the file and save it to a local drive, you can use the regular Flat File Connection / Flat File Source to process the file.SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

There is no built-in support in the FlatFile Source adapter to pass credentials while connecting to a file located on the internet that needs authentication first. Typically, you would pay for a subscription to the website so that you could download their CSV content and they would inturn provide you with credentials to login to their wesite and access the resource. We had a similar requirement in one of my previous projects and we implemented it by writing a custom .Net crawler application that would create a HttpRequest object to make a call to the website, pass on the credentials in the request object, get authenticated and then download the file to a local share (again can be implemented either using the FileStream .Net object or by parsing the HttpReponse object received from the website). From then on, it was a simple Flat-file parsing which can easily be done using the Flat File source. Hope this helps! Cheers! Muqadder.