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

...

vipin_jha123 (12/18/2014)

---

Hi ,

I have created simple BIML Script file which generating a SSIS Package.

It Contanis Single Data Flow Task ,OLEDB Source and OLEDB Destination.

Now my Concern is that my new...

Guitar_player (12/18/2014)

---

Yes I agree !! For Oracle I am getting the Full Connection String and for the SQL DBs i am getting only ServerName property of those connection Managers ..:-)

Thanks...

Guitar_player (12/18/2014)

---

Are Connection Strings rather different than Connection Managers ? I dont know that !!!

I am using the Project Connection Managers and i have parameterize them (Made them as...

Sounds like you are doing it right.

Are you using connection strings rather than Project Connection Managers for a reason?

Guitar_player (12/17/2014)

---

Hi , I should not use ?

I have tried the other method as Deployed my project in the SSIS catalog and then created a Environment variable...

marcia.j.wilson (12/17/2014)

---

I am trying to import an Excel file with a comment column in it. Most of the time the comments are large and SSIS makes the external column...