We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

connection manager in SSIS

Medium Priority
351 Views
Last Modified: 2013-11-18
I'm creating an SSIS package in Business Intelligence  Studio which  takes a csv file and loads it into a database table.
The csv file is dumped on a network share on a weekly basis.
I want to schedule a job that automatically runs an SSIS package that loads this file into the database.

The problem is that the name of the file changes on a weekly basis
eg
file_11042011.csv
file_18042011.csv

Is it possible to  create a Connection Manager that can accomodate these file name changes?
Comment
Watch Question

Solution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
CERTIFIED EXPERT
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Top Expert 2010
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Top Expert 2010
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
Hi PatelAlpesh  and  AmmarR, thanks for your responses...that gives me plenty to work with...Thanks again :-)
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.