Convert to a date or date time

datetime2 ??? will look that up.

Thank you this greatly appreciated.

Yes each file has column headers.

I'm retrieving the name of the file.

Based on the filename it populates the correct table.

The mapping is based on the file with the...

If definitely the second case scenario.

When loading the data manually through the SSMS import wizard all the rows and columns line up.

So yes its definitely mapping incorrectly.

Is...

I will look into deeper.

Basically it seems as if the columns are being add to the same file over the years.

I mapped to the latest file (ex. File_03312012.txt...

Thank you for the information.

I will look into that.

Based on timed constraints I just created a different file connection for each file.

Nevermind I just got it to save.

Really strange how it kept changing back to string out of nowhere.

That definitely worked thank you.

I was able to pass it into the package.

I believe I tried that and received an error.

Must be doing something incorrectly.

Let me try again.

Thank you

Thank you I began that process.

Now I do not see how to pass the password to an encrypted archive so that it loops through each archive and decompresses it....

Wow very cool I'm going to check them out.

Thank you much appreciated.

Wow very cool I'm going to check them out.

Thank you much appreciated.

Is there a better way of loading data of a hundred million+ rows.

If it fails you have to start from the beginning and lose over a days worth of...

Forgot to lock out a certain group from the database when doing a dataload.

So your saying I cannot load data between a certain number of rows

Error 0xc0202009: Data Flow...

Okay I'm embarassed to have to report this but I have to given all the help and time everyone has put into this question. First and foremost thank you for...