Eirikur Eiriksson (10/6/2014)

---

Here is a quick solution, more for prototyping but it works

😎

USE tempdb;

GO

SET NOCOUNT ON;

GO

DECLARE @TXML XML = '<EventOne Date="09/22/2014" ID="12196996" InternalEventOneID="96436969" xmlns:reslib="urn:reslib">

<EventOneDate>09/22/2014</EventOneDate>

<TimestampCreate>09/22/2014 11:37:06:413</TimestampCreate>

<Comment>Comment One!!</Comment>

<EventZ EventID="834033" EventHistoryID="375381" InternalEventID="4843699"...

<EventOne Date="09/22/2014" ID="12196996" InternalEventOneID="96436969" xmlns:reslib="urn:reslib">

<EventOneDate>09/22/2014</EventOneDate>

<TimestampCreate>09/22/2014 11:37:06:413</TimestampCreate>

<Comment>Comment One!!</Comment> ...

Koen Verbeeck (6/25/2014)

---

The SSIS error messages are logged in the SSIS catalog. The reports in the SSIS catalog fetch their data from the SSISDB database.

In previous versions, the error messages...

Koen Verbeeck (6/25/2014)

---

peacesells (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

peacesells (6/24/2014)

---

I know in previous versions, msdb database would log/capture all sql server agent job details. Now with 2012 and SSISDB, if a job...

Koen Verbeeck (6/25/2014)

---

peacesells (6/24/2014)

---

I know in previous versions, msdb database would log/capture all sql server agent job details. Now with 2012 and SSISDB, if a job fails in SQL...

Thanks. I was aware pf those links and i use scripts to create/schedule jobs all the. My only concern was...

are you implementing cds in ssis ? ssis 2012 comes with CDC features.

http://msdn.microsoft.com/en-us/library/bb895315.aspx

This should provide you a pretty good CTE understanding.

https://www.simple-talk.com/sql/t-sql-programming/sql-server-cte-basics/

http://www.sqllion.com/2010/08/common-table-expressions-cte/

Yup. I was more concerned about what should be in the script task.

I have been browsing and jumping around and two things come to...

mister.magoo (12/17/2013)

---

That should catch the error happening, but it's not going to pass an error on to SSIS unless you specifically return an error code and handle that -...

mister.magoo (12/16/2013)

---

The reason you are not getting the program flow you want is because this statement happens after the error but before you check for an error:

INSERT INTO @T

...

The dynamic sql is pre-composed.

mister.magoo (11/8/2013)

---

peacesells (11/8/2013)

---

SGT_squeequal (11/8/2013)

---

Be easier to help if you provide some Ddl and how are you calling stored procedure or setting the variables. Initially i would look up dynamic sql...

SGT_squeequal (11/8/2013)

---

Be easier to help if you provide some Ddl and how are you calling stored procedure or setting the variables. Initially i would look up dynamic sql perhaps do...

PaulB-TheOneAndOnly (8/2/2013)

---

peacesells (8/2/2013)

---

DateTimevalue1= (given)

DatetimeValue2=?

I need to find out DatetimeValue2 from a source table in remote server using these values and pull data between DateTimevalue1 and DatetimeValue2.

Dateime2 will...