KoldCoffee (12/31/2014)

---

I don't understand "saving the SSIS package produced by the import wizard"

the process of importing these files needs to be automated. Therefore, the object of the ssis package is...

Yes you can.

Have a look here and look for 'SQL Server Management Studio Express'

KoldCoffee (12/31/2014)

---

I wrote in my opening statement that I used Import Wizard and in resulting table there are no 'duplicates'

last evening I used bulk insert to import the .txt file...

Is this what you are looking for?

chrisn-585491 (12/31/2014)

---

As a Jack-of-All-Data-Trades, certification is huge time suck for me. As soon as I'm ready for an exam, it's retired and there's yet another two new versions of SQL...

An interesting introduction, thanks Sebastian. I shall look forward to the next items in the series.

Writing tests is clearly an initial overhead, which one expects to be worth the investment...

Nice and well-balanced article Steve.

You could try using the Import Wizard, saving the package it produces and then comparing that with the one you've created manually.

But if I had to guess, it sounds like...

sandhya.msbi (12/29/2014)

---

Hi All,

I have 2 tables source & destination and I have to truncate destination and laod from source. these 2 stpes should happen in one transaction. but I should...

Data leakage defined

It would be helpful to know how the output is going to be used.

You want one resultset, but with different columns from different tables? Can't be done.

Possible? Perhaps, though I don't think many...

Michael Meierruth (12/18/2014)

---

And there is yet another variant:

SELECT Y + X AS Position

FROM (VALUES ('01'), ('02'), ('03'), ('04'), ('05'), ('06'), ('07'), ('08'), ('09'), ('10')) AS X(X)

join

...