Well, technically I mean SSDT 12.x.x.x, which is...

axissolutionspl (4/22/2015)

---

Actually, I followed the excellent blog by Marco Schreuder here: http://blog.in2bi.com/biml/creating-a-meta-data-driven-ssis-solution-with-biml-1-overview/

Yes there is a bit of learning, but if you just use his example as starting point is not...

Jay Hammer (4/21/2015)

---

I figured out the source of my issues......

Since I was building my SSIS package from an existing package (similar use case, ETL data and export data to a...

OK, I'll give you an outline. There will be many ways of achieving this, some of which will have fewer calls to the DB engine, but here is just one....

p.shabbir (4/21/2015)

---

Hi phil,

Thanks for the quick response. I know that one DFT per file will do but, what if we have more files(Say 50 or 100 files). It will be...

Sure, just...

Minnu (4/21/2015)

---

Hi Team,

using below script to export the select statement result to .xls

declare @sql varchar(8000)

select @sql = 'bcp "select * from Databases..Table" queryout c:\bcp\Tom.xls -c -t, -T -S' + @@servername

exec...

vignesh.ms (4/21/2015)

---

Hi There,

I have SSIS project with me, I can run as it is. But, when I try to edit the script task;

shows an error : The name 'zipfile' does...

The temp table 'hack' changed in SSIS 2012. Use EXECUTE WITH RESULT SETS, see here.

ankithimmatlalshah (4/21/2015)

---

Hello Phil,

Thank you for the quick response.

For first point, I will re-confirm with customer that can we create the SQL script task that will first create the all tables...

There are a lot of questions here and several of them required detailed answers in their own right.

But for me, one thing really stands out. Best practice is not to...

pharmkittie (4/20/2015)

---

They have a forum I posted to but I don't think I can call until I buy the license. I was surprised to see that a search of...

OK, I'll ask the obvious question. Have you asked Cozyroc, given that it's their product?

-Edit, fixed typo.

The way I would do it is closely related to Steve's suggestion:

1) Get the database code scripted out using VS or Redgate SQL Compare.

2) Get it into a VCS.

3) Devise...

mxy (4/20/2015)

---

I am trying to replace object name in views , triggers, stored procs, UDF,TVF etc. created a automated script based on Search condition is 'xyz' replace with pqr in...