Thanks for your article.

the query for Contains ‘exact word’ will not work if the searched word is the last word on a line.

Chris,

thanks for a good observation about a cursor use...

I think even in the case you described, you can resolve an issue with a set based query.

I would be thankful if...

Briant,

thanks for the article.

I think the first snippet of the code should be like this:

WHILE @@FETCH_STATUS = 0

BEGIN ...

Thanks for your input. I am glad that you went through the entire process described in the article. When I faced the issue with a big string, I needed a...

Thank you very much for your comments. I would like to answer your question ASAP but I would need you to provide a step by step how to do what...

Thanks. I agree I communicated multiple things with an assumption that my reader is a beginner. How I could do it better?

Thanks for your input. What do you mean by saying Actual Information was lost? How do you like this saying: Make everything as simple as possible, but not simpler. Albert...

Thanks for sharing. Is there a way to automate this process? The bottom line is the automation. When you have many reports to deliver you want to schedule jobs to...

By definition an Excel column can have 250 characters. The trick is to put in an Excel column a string of any length. If you have a column with a...

Thanks Koen.

I read this article in the past and people do complain about the issue I did described in my article and I did show a solution. There is no...

Thanks Koen.

Could you please specify on SQL Server 2008 R2 what service pack can handle more than 10,000?

Could you please provide a link to book on line/documentation.

Have you tried it...

Koen,

thank you very much for your input.

The max number of rows the Wizard can scan is 10,000.

I need the script when an input file has more than 10,000 rows.

Please...

Brandon,

thank you very much for your input.

Yes, BCP is a good choice.

I did use it. But to use it with a scheduled job, it requires to use a scripting language,...

Thanks Tim

I see one case where this line

On the line Copying to [dbo].[EmployeeFeed] you should see the Status Success and Message - “10000 rows transferred” in the Action column

should...

thanks for the articles.

I need some help. Do you know how to fix informational messages like these:

The description for Event ID '1073819649' in Source 'SQLISPackage100' cannot be found. The...