Can you paste in the text of the query and a screenshot of the parameter mapping please.

BypassPrepare is already set to true. I could probably\will probably have to use all parameters or none. The problem is it doesn't seem to like mixing parameters with hard coded...

Are you saying I should still wrap the pipe delimited output handling within a proc. I am unsure about the ADO component use.

FYI, My contract, is what I'm guessing is what you call a working statement is inside the If 1=2 statement at the top of my proc.

The contract is based on this post. I have used the wacky code in all my procs that use temp tables or dynamic sql so the source can get the...

Thank You, I've added them to my Kindle app. Now I just have to track down a 2012 server.

Phil Parkin (9/1/2013)

---

Phillip.Putzback (9/1/2013)

---

I have two sequence containers. When I set Bln_runWithOverrideDates to True I want to run my SEQC_Historical container. That part works, the expression is "@[User::bln_RunWithOverrideDates]" when it...

Khades (8/15/2013)

---

Oh ok. I do usually use SQL Server Configurations. I've seen it done 2 different ways.

One way is to make sure the configuration file is in the same path...

Khades (8/15/2013)

---

What we usually do is have 1 config file(same name) in both locations. Let's call that file cfg_Example. The cfg_Example in the test location will have test values, and...

Thanks for the tips. I am going to go with a Master and child since the way our team is divided they might give me a proc to extract one...

Once I put the ISNULL expression on every column and replaced nulls with the spaces with the SPACE() function everything has worked fine.

I have bookmarked this thread though for future...

That is some pretty impressive code. I had no idea I could do that kind of code inside a Stored Procedure. i did finally get the package to work. Come...