August 19, 2008 at 8:08 am
hi
I will get any excel file in a folder , I have to rename it and then after importing using data flow task , i have to again rename that file with date extesion. how to acheive this?
August 19, 2008 at 8:45 am
Use the aptly named FileSystem Task.
Create a variable that builds it's new name from an expression.
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 19, 2008 at 9:29 am
can you tell me in more details please?
August 19, 2008 at 9:40 am
Sure:
Variable Expressions: here are 31,500 details: http://www.google.co.uk/search?hl=en&rlz=1B3GGGL_enGB259GB259&q=ssis+variable+expressions&btnG=Search&meta=
3rd result is a good one.
As for renaming:http://www.google.co.uk/search?q=ssis+rename+file+%22file+system+task%22&sourceid=navclient-ff&ie=UTF-8&rlz=1B3GGGL_enGB259GB259&aq=t
In particular, http://rafael-salas.blogspot.com/2007/03/ssis-file-system-task-move-and-rename.html
A little leg work... A quick google.
If you still have trouble, post back.
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 19, 2008 at 9:57 am
hi
it is better if you would develop package and give it to me.
here are the steps
1.) you will get any excel file in a directory
2.) you have to import it in sql database.
3) after import done , you have to rename it with date added in the end
say if you will get file like abc.xls then you have to rename it abc_08192008.xls
you can send ssis package to my id bang dot prashant at gmail dot com
thanks
bang
August 19, 2008 at 10:01 am
bang.prashant (8/19/2008)
hiit is better if you would develop package and give it to me.
...
you can send ssis package to my id bang dot prashant at gmail dot com
thanks
bang
That is the best one I have heard yet.
Sorry maty - point you in the right direction. It's 5pm and I hear a cold beer calling my name.
SSIS calls for some work, not for asking people to do your work for you.
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 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply