VoldemarG (2/23/2016)

---

I am doing a typical Query --> Flat File in my SSIS package.

However I cannot output the file in the right format ( the format that is shown on...

jcachado (2/23/2016)

---

Ok, sorry but the error is common on both platforms and the error should be the same and the way to solve it 🙁

Thank you in advance for your...

astrid 69000 (2/23/2016)

---

Hi,

I have a table who have a number of columns. One of the columns contains an xml.

How can I parse the xml into column using the origin table...

Michelle-138172 (2/22/2016)

---

Yes, that's how I found out I can only run one instance at a time. I thought one server was overwritten by another at the very beginning. But when...

scotdg (2/22/2016)

---

So I wasn't able to change the account until this morning. I changed the account to use my credentials as I did on the QA machine while testing. As...

Alan.B (2/22/2016)

---

Ed Wagner (2/22/2016)

---

Luis Cazares (2/19/2016)

---

Ed Wagner (2/19/2016)

---

GilaMonster (2/19/2016)

---

SQLRNNR (2/18/2016)

---

I am seeing people claim to be an MCM for some of these interviews. I know full well they aren't an...

But it seems that you are suggesting that a different version of the script is generated depending on the SQL Server version.

To troubleshoot this, you need to be speaking to...

marin-231997 (2/22/2016)

---

Hello Sean,

many thanks for the quick reply.

It is a 3rd party software (interface engine) that processes the CSV file and sets the value in the placeholders before running...

sqlfriends (2/19/2016)

---

we have a table from Oracle that has millions of records. We have a query to get from that table and into SQL server staging table. I...

pharmkittie (2/19/2016)

---

I've been struggling with the example in the link you provided. The author leaves out steps (and refers to things in figure 3 that show something different than...

g.britton (2/19/2016)

---

Phil Parkin (2/19/2016)

---

g.britton (2/19/2016)

---

Working in a DW environment, my biggest challenge is coordinating databases, SSIS packages and SQL Agent Jobs. Most integrated VCSes do an admirable job on...

Peter Schott (2/19/2016)

---

While I can see jobs being scripted, I'm wondering if anyone has come up with good ways to put SSIS code into version control? I know you can...

g.britton (2/19/2016)

---

Working in a DW environment, my biggest challenge is coordinating databases, SSIS packages and SQL Agent Jobs. Most integrated VCSes do an admirable job on the database side,...

butcherking13 (2/19/2016)

---

Hello,

I don't know anything other than very basic SSIS, but have a question / looking for advice on cleansing data particularly email addresses.

I run SQL SERVER 2014 BI edition...

So the only real use of the term "CROSS JOIN" vs the older seperation of two tables by a comma is simply to reassure the reader that the cross join...