Been there, done that, bought the T-Shirt 🙂

I do suspect though that it would be quicker to disable everything and slowly work forward until you find the problem. It's a...

It's not a bad way of logging. I have been using a similar version for a while and had no problems.

I would say though, include normal text file logging as...

What are you looking for? If you want to add soem pregress messages, you could use dts.events.firexxxxx

Those will write out the event to the progress and if you have any...

I really doubtit was a problem. Your destination was probably just slow or blocked. Possibly your source blocked (I cannot remember what the source was)

While this is a perfectly valid solution if you don't want to use the variable / delete option, I would rather pass the folder to the script task and use...

I smell a rat. I really do.

It's great that you been doing things for government and military and all that. Fantastic you felt the need to add it.

Now, the fact...

wow. Talk about many was to skin a cat. Some convoluted methods at that.

Just use a row count component, set the value to a variable, after your data flow,...

Just reread, you cannot do what you are trying. The value of the variable HAS TO BE A VALID SQL STATEMENT.

You variable expression will be "Select * From " +...

There is no limitation other than 4000 characters.

So long as the value of your variable is a valid SQL statement, it will work.

As for the variable using another variable, look...

Top of your code you must have Imports System.xml

Alos, Menu > Project > References > System.xml

That should do it.

Nothing wrong with what you are doing. How sure are you that it is valid xml. msgbox it? Write it to text file and see. If the DOM is...

It's by design. Only every third row is allowed...

Really though, the destination is applying back pressure. As the union all task is an async task, it can accept lots and...

Redirect the rows from the convert and see what the row is that is complaining. Probably find......it is not convertable 🙂

No no no no. SSIS is not designed to be modified at run time. That is a bad idea. While it can be done, you should not. As everyone above...

Nothing wrong with doing it your way (provided you can always identify the header and footer) but I would not use a script task in the middle. I would use...