meiry242 (12/24/2016)

---

Thank you very much for you replay , i found info about this tool ,

but i haven't found any info about my situation where i need to fill data...

meiry242 (12/24/2016)

---

I have generated 200 mega data script from local SQL Server, which I generated via Tasks -> Generate Script in SQL Server Management Studio.

When I try to execute it...

If the statements to be executed come directly from a table whose contents cannot be manipulated, except by suitably authorised...

Welsh Corgi (12/23/2016)

---

Lowell (12/21/2016)

---

Dts.Events.FireError is what you want.

is your account used by a team of users, and not an individual?

Trivially adapted from part of an answer I posted for...

hamzajosh (12/22/2016)

---

Phil, Like Drew pointed out, your solution returns formulas that have even ONE ingredient in common, while I am looking for a exact match on ALL ingredients. I appreciate...

I'd also be interested to hear why my solution...

IF OBJECT_ID('tempdb..#tmp', 'U') IS NOT NULL

DROP TABLE #tmp;

CREATE TABLE #tmp

(

FormulaId CHAR(2)

, IngredientId CHAR(2)

);

INSERT #tmp

...

Sorry, I'm out of ideas.

Jim-S (12/22/2016)

---

Unfortunately it is causing us some issues, we are using Microsofts ALM (kanban model) to deploy our stuff to test and live servers. We attach our dtsx files/ code...

nadersam (12/22/2016)

---

Hi Guys,

I am trying to execute an array of comma delimited SQLs in a stored procedure.

I call it as below

declare @Parameter as nvarchar(max)

set @Parameter ='insert into Orderlog (trans_no)...

patelxx (12/21/2016)

---

Please can you help me in turning the following script into a Stored Procedure, I have just tried doing this but I keep getting errors like I have not...

And here's that link again, in clickable...

A detailed explanation of the problem you are having and details of the error you are receiving.

sarwar.ali490 (12/20/2016)

---

i wanted to stop the file from loading into DW if the status of file is "rejected" and set up error message and notification ,given the criteria above...

Sean Lange (12/20/2016)

---

Can you provide some sample data for us to use and what the desired output would be for that sample data? Just showing us the results of your...