do you want to load all data into the same table? I am asking this because probably i do not understand your question very well. I am a bit...

I cannot use dt_Wstr because the length is expected to be more indefinite, which definitely can be 4000 characters. I think my only out with this will be to...

sorry, i realised i posted this under the wrong forum topic. I've now posted it under business intelligence. Dont know if I can delete this post some how...

Please ignore my previous post, I set the value of typeguessrows to 1000 and it works fine.

hi i am facing a similar issue, I have an excel connection manager. The excel file to which the connection manager is pointing has a column with 257 characters...

Kool123 (4/26/2012)

I have one for each loop task and inside that one sequence containor is there which is doing some task and moving files from one folder to other.

Within For...

This is what you are trying to do -

DECLARE @fac INT ;

set @fac = 1;

With tally (n) AS (SELECT top 100 ROW_NUMBER() OVER (ORDER BY...

I know I am doing someone else's homework but I havent worked much on CTE or recursive CTEs and it is like a learning exercise for me. When you...

could you please upload the sample excel sheet you are trying to upload?

I had a similar issue but with dt_wstr datatype, I tried converting the datatype to dt_str...

Hi, is there any specific reason why you wouldnt want to use loop for this?

that seems to be the simplest solution, also, I am assuming that the number of rows...

Thank you both for your replies, I have figured out that I can actually filter the data before I perform the join, so the join will now work on a...

Thank you both for your replies.

I ended up using the conditional split itself, because I realised that its not that bad after all 🙂

Yes, I also noticed that it will...

Thank you both for your answers, I would understand if it doesnot error out when it does not find anything under the specified directory. But I find it a...

I have never tried this before but the first thing that comes to my mind looking at the problem you are having is to define an on error event handler...

Have you tried using the foreach ado enumerator? That should solve your problem I think.