Well the little square is hard return, in this case. The hard return consists of the CR\LF characters, which is the default row terminator. SQL was thinking you had...

If you have a little square on the last line. This usually means you have a hard return. To resolve simply delete the last line. It should...

It will. It doesnt need a blank line to end the file.

I am a little late but the problems that I have encountered are:

SSIS compatability problems,

Oracle drivers need to be 64 bit,

openrowset and openrowsource dont work on 64 bit because the...

Interesting. Thanks for the info on the while method. 🙂

Sounds like you have an extra line your text file. Delete the last row of the file. It should not contain any data just a hard return like in...

Right-click the report make sure you are showing footer. Drag a textbox into the footer. Set the footer value equal to an expression. Select the page number...

I have no idea why it would not close the connection after the package is done executing. Sounds like a bug to me.

Here is a great link. http://msdn2.microsoft.com/en-us/library/ms141704.aspx

Note that WSTR is unicode. If you do not need unicode characters you should use (DT_STR,10,1252). Code page 1252 is the standard.

NP and no hard feelings. Good luck with your project. 😉

I believe Log Resuce only works for 2000, unless Redgate has a new...

Replace the text with your column name and all should be well.

LEFT('RT 12.5R20 (P) OL', CHARINDEX('(','RT 12.5R20 (P) OL')-1)

kurraraghu,

People are helping you solve your problems on their own free time. I do not know if it is a language barrier, you are in a rush, or you...

This task...