October 7, 2015 at 2:38 pm
Hi everyone,
i'm new in this page and have a question. how import *.db and *.px files in SSIS to SQL Tables?
i have to upload 52 file into sql database but i don't know how upload this file.
please help me
thanks
Juan Luna
October 7, 2015 at 4:29 pm
I am not sure what those file extensions represent, but you can configure a For Each Container to move through a directory and process each file with a given extension.
The caveat is that each file must have the same format so that the data flow inside you For Each Container can be written to read each file and move/transform the data into your destination tables. I can get more detailed if you provide more to go on.
October 8, 2015 at 9:21 am
thanks John Rowan by the answer
but these files are paradox files and i need to upload to data base. i can't open these file and don't know what information contain, this process need finish him this week.
Thank so much
Juan Luna
October 8, 2015 at 9:36 am
Ah, you will not get SSIS to read directly from the Paradox files. SSIS may be able to connect to a Paradox instance and read from it, but not directly from the files. You're going to have to spin up a Paradox install to host the files if you want any shot at reading them. These are database files so it's not as simple as just opening them up and viewing the data as text. Think about what it would look like if you attempted to open up a SQL Server data file? Even SSIS cannot read directly from the .mdf....the .mdf has to be hosted by a SQL Server DB engine. Same concept would apply for these Paradox files.
That's really on the beginning also. If you can get these files up on a Paradox platform, you'll then need to create the matching table DDL in your SQL Server system and figure out how to move the data over and map the data types. For 52 Paradox databases, this is not a week's worth of work.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply