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.

Check your 'State - 1' bit - you are performing arithmetic rather than subtracting one from the length. You need to rejig your brackets and all should be well.

captcooldaddy (2/22/2012)

---

the above is a quick and dirty solution w/ pseudo code because you're not really providing the proper preface to give a detailed solution however it should suffice. Pretty...

Thanks Jeff, I appreciate the genuine tone of your message. And I sympathise with the sleep deprivation - sense of humour is often one of the first casualties. I'm also...