August 17, 2015 at 8:17 am
The incoming source is saved in a folder with name and date like source-12-08-2015.
how can i schedule each day the incoming source with date and name ...
how to plan extract data from the source file as a daily task without user interaction like daily scheduling
Ex: the source file is C:\Users\JAI\Desktop\scheduling\12-08-2015-source.xls, each day date component is changing according to the date.
how to plan a SSIS Package to get nameof the incomming file..
Please Any one Help me on this topic......
August 17, 2015 at 8:40 am
Use an expression for the connection string of the connection manger used to the to the file to e imported.
In that expression, use a formula that sets the date values to be in the file name.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply