Any Suggestions?????

Thanks in advance!

Alrighty lets forget about the Unzipping of the files for a moment...

Lets move to using SSIS to load data into a db...

Ok heres the problem...

I have a folder containing 24...

Again my apologies...but like I said before, I am new to this environment and not familiar with SSIS...But for the foreach loop container when creating a variable as you mentioned...I...

I am using 7-zip so does that mean e still means extract and o still means overwrite or is it different?

Thank you again!

That example is very helpful as well as the example you provided for the ssis package to load the data...Although I understand the concept of the package,...

steveb?

what do I need to download that is free to unzip all the folders?

Thanks steveb for helping me on these issues...I am going to start with one then go to the other...Easiest first...I want to unzip these folders...In this directory, there are 160...

Thank you guys both...I will google for each loop in ssis to see if I can use that...The file that is different has the name of nc04_use from each facility...

So I can unzip the folders in SSIS? I didnt know if that would work or not...

I am not familiar with For-Each loop to loop through the files???

Some of the...

I was wondering about that UNIQUE CONSTRAINT...How does that work? Do you put on a certain field?

OK thanks...I have done steps 1-7 and got the .dbf and .fpt files in a separate folder...And when I set up the connection, i chose table or view and then...

Can you please give me a step by step directions to setting up this in a SSIS package...Im new to SSIS so Im not quite sure what I am doing!...

I dont have FoxPro...We were thinking about that or File Maker Pro! But I dont have either so I was seeing if there was another way to open the file!

Thanks for your response, however when trying to create an SSIS package, I tried creating a new connection but I dont see New OBDC connection...I have a New OLE DB...

Nevermind I figured it out!!! Thanks anyways!