Ham

I don't even know why I'm here.. maybe just go to bed?

Its re-assuring to know that if they did have a question.. it would not go un-noticed :hehe:

Love the story.. I never knew database concepts could be so entertaining..

Have you written any books yet? I would love to read it!

edit - lol you beat me to it

This really helped with understanding. Thanks!

Is there some place you can find stored procedures or queries similar to this.. to help learn by analysis?

cosmetic

Definitely not a "master", but I will take a stab since you mention "generally"

Most of what I have worked..

Q1 - deployment utility

Q2 - File system

It is so addicting... I love it.

It takes me back to the days when I was playing dos games. It was a simple concept and consoles and still a lot...

I found some code to open excel and read contents. I am thinking of testing it out.

Hoping to use a script task to open excel, modify it by sorting by...

I read here that the ACE OLEDB 12.0 provider overcomes it.

Installed it, but no go. Stumped..

edit - tried to make less clutter with the url tag

What about adding the dummy line? I am not loading the file,to open it and add the line. It is getting loaded through application GUI on client side.

I am stuck at a similar dilemma with Excel source and Jet provider.

Cannot edit registry key.

I was thinking about this.. but I am not sure if it is possible.. Can...

2048 is before trimming

That is correct. There is no requirement to break it up other than to check if max(split_field_column_length)<128.

If max length is exceeded, I want to just read up to max length...