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...

So why are you using Windows Environment Variables then?

vipin_jha123 (12/17/2014)

---

Hi ,

My Concern is , is single DFT will take the Table name in both Source as well as destination dynamically and is dynamic column mapping is possible in...

koti.raavi (12/17/2014)

---

Hi All,

Can any one help me out how to execute 5 procedures in one procedure ...

The article is absolutely fine, though I would not categorise a CROSS JOIN as advanced.

AFAIK, the words CROSS JOIN can be replaced by a single , and all will...

To be honest, I'd be speaking to whoever has asked for these changes and telling them that they cannot go to production because of the change freeze.

It is then down...

SSIS does not really support dynamic columns. Do you have dynamic target columns too?

Why are you doing it like this and not using a flat file source?

Use source control.

At any time you want, you can compare your database schema with what is in source control.

If you want to find out who made a change to a...

BIML generates packages, it does not load anything.

BIMLScript might be...