rajemessage 14195 (11/12/2016)

---

following is the step:

initially some sequence is given to marble table, at that time glueid in marble table are kept null.

then one by one glue is attached to...

Dmitriy Burtsev (11/11/2016)

---

Let say you have to ETL several files to staging tables. You don't know how many tables. You don't know tables and files structure at design time.

Somebody...

SSIS packages are not compiled executables, they're just XML files.

I'm not sure for how many more years my marbles...

You've told us that you have to write a proc and I'm guessing that you want...

That's clever, Luis 🙂

OK, I think that...

For others' benefit, here's that image:

As the error message suggests, try changing this line

,'@DBName NVARCHAR(25), @BegDate DATE, @EndDate DATE',

to this

,N'@DBName NVARCHAR(25), @BegDate DATE, @EndDate DATE',

ShinyK (11/10/2016)

---

By default, the Lookup operates as an INNER JOIN - but we need a LEFT (OUTER) JOIN. Click the "Configure Error Output" button to open the "Configure Error Output"...

dndaughtery (11/10/2016)

---

Hey guys, I've been tasked with automating an excel sheet which has 2 tabs. One called "Raw Data" is where I'm loading the data and there's another tab that...

Masochism? 😀

NP. Sometimes a fresh pair of eyes is all that's needed.

Matt.Altman (11/9/2016)

---

Hello,

I have a stored proc I am trying to run but I am getting the error

"Conversion failed when converting date and/or time from character string"

The original table looks like...

Thanks for the well-written article. I haven't used BIML for a...