Interesting question, thanks.

Erland Sommarskog (7/15/2013)

---

Koen Verbeeck (2013-07-15)

---

OK, there is try_convert() too. As for improvements to SSIS...

You must be joking right? 🙂

SSIS is completely renewed,...

Erland Sommarskog (7/15/2013)

---

I came over here when the NNTP bridge for the MSDN forums stopped working, and I've only been here for a couple of weeks. Still I have some...

You could use a lookup component to find out if a record in the data feed is a new record or an updated record.

You can insert new records with an...

Interesting question for a Monday 😀

Sean Lange (7/12/2013)

---

Koen Verbeeck (7/12/2013)

---

Brandie Tarvin (7/12/2013)

---

Yes, there is. Passport allows us to cross borders with other countries....

jjr.123 (7/14/2013)

---

Hi Can you please share me a sample package that shows how to configure int32 variable to increment by 1 ,

other string variable to hold the packageName , and...

sneumersky (7/12/2013)

---

If I am not mistaken, using one execute package task (EPT) within a loop would execute the packages serially, right? Parallel EPT execution would require multiple EPTs that...

Mike Gray-474150 (7/12/2013)

---

When setting up a new SQL Server 2008 R2 is there any advantage to installing SSIS on a separate server to offload CPU and Memory from the SQL...

Maybe you installed the 32-bit client while SQL Server is 64-bit?

The tool generates all the data found in the table, so it's all or nothing.

Maybe you can create a duplicate table and insert into that table only the data that...

Are you sure it has the status "executing" instead of "running"? I have never seen the executing status before...

This should get you started:

http://forums.databasejournal.com/showthread.php?49804-getting-first-date-and-last-date-of-previous-month-in-oracle

I probably used some TSQL function which are not available in Oracle, so you might want to convert some functions to PLSQL.