Nice, thanks Andy.

Aha, I should have thought about that.

Well done on figuring it out.

Maybe you should set the breakpoint on the pre-execute of the data flow - it may be that your breakpoint is being hit before the variable's value has been set.

If...

Is there a way to quickly search some freetext in all sp/fn within the database? I often need to search for a sp but just couldn't find it, I have...

sellonster (3/14/2012)

---

Hi Anthony

Maybe I'm not explaining exactly what i really want to achieve. You see on my c# program, I have 2 connections pointing to two different DB servers. From...

Notwithstanding the fact that SSIS is the wrong tool - ditto comments already made ...

Have you investigated the 'Execute Process' SSIS task - this might run the .VBS scripts (never...

Right - that makes it a little harder. It also illustrates the risk of oversimplifying your questions 🙂

This requires two separate dataflows to two separate files.

After that, use the standard...

What do you want the file to look like?

Just modify your proc to UNION the two result sets and you're good to go.

--Removed

Yuk. Don't like that proc at all. Looks like it was written by a procedural programmer unfamiliar with T-SQL concepts like 'sets' 🙂

Have you thought about writing your data to...

"Can't" is a strong word. Multiple Replaces can be nested, so, with care, this might work.

Here's a nested Replace example:

declare @x varchar(100), @y varchar(100)

set @x = 'abcdefg'

set @y = replace(replace(replace(@x,'a',...

His real name is Crispin 🙂

Merely repeating your earlier...

Are you sure that there are no other more-detailed error messages?

Do you know which step is failing? What is it trying to do?

Is there any chance that you could get the spreadsheet exported to .CSV format as step one of the process? Then you should find that the limitations are removed.