August 14, 2008 at 8:25 am
Hi
I m doing simple task in SSIS
Source xls file ---> Destination SQL Server.
Question
1. How change xls file path and name ?
2. Once import done , rename xls file and move it archive folder?
please explain in details
thanks
bang
August 14, 2008 at 8:40 am
I assume you are talking about xml file and not xsl?
Regardless, use a variable to hold the filename. Use expressions in the variable to dynamically change the value.
As for moving the file, use a file system task after the data flow and move the file to a new directory.
If you looking for soemthing in greater detail, the above would give you enough of a starting point. There are many many turtorials on the net.
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
August 14, 2008 at 9:28 am
Are the files always put in the same location? If so you can use a foreach loop container that loops over .xls files in a the location. Processes them in a dataflow, then use a filesystem task to move the file.
Check out this blog post for how to do the ForEach loop: http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 14, 2008 at 9:41 am
HA HA HA. I could not remember what .xls was for. Assume was a typo for xml. Now I feel rather stupid...:blush:
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply