Hi, I have a folder which contains files in .txt,.csv and .xls with different schemas like customers,orders etc..is it possible to create a SSIS Packagewhich can do it all dynamically creating destinationtables on the fly..
Many Thanks
Dear vamsim,
I was thinking in you request during the day... it's easy to implement but you should make sure that all the schema are the same... :-)
Send me sample files of each type...:-)
Regards,
Pedro
Hi Pedro, Hope you had a good weekend..Here are 2 sample files..both are text files without headers but withdifferent schema..Is it possible to modify our previous package to handle this type of situation..
Many Thanks..
0268.orderlines.txt8764.products.txt
HI!
The suggestion you made before to use import txt and csv not make sense if the chema are different, correct? You told that was the same...
now... what you need from these 2 files?
regards,
OK pedro,ignore it if it is not possible with different formats and schema..but in this case, its similar files with different schemas..is it possible to create a package which can create destinationtables based on these file names on the fly ?
Thanks..
Using standard components is not yet possible....
But you dont need the schema before import textfiles?
Ok Pedro, if it is not possible , then why dont you create the schema before the import ?
Thanks
Ok.. you can create the schema before the package... but the package must know before you execute the schema that it'll receive...
Understood?!
Maybe some day, Microsft include a component for that!
:-)
regards!
HI Pedro, what i mean to say is , cant we not create destination tables in the database first and then
run the package pointing to these tables to load the files ? its same like the package which you created initially
but with different schema this time..
Yes you can,
But the problem is your source component that should know before the package run the schema that will be as input of your project.
Check the package I made for you before... you have a pre-defined source component with schema defined...
HI Pedro, just came back from holiday..
Yes, i do understand that we need to define the sourceformat,,In this case, is it not possible to define twosource schemas for the attached files and then load them accordingly ?
Yes you can...I'm still on vacations... when I back I can make an example to you.
Just use a script task to ckeck the schema type and store it in a SSIS variable that will be used in expression that link this script task to the dataflow where you'll import data!
www.pedrocgd.blogspot.com