Anshul Parmar (4/24/2015)

---

Package 1 –

It is not a good practice to create a database and tables in SSIS packages.

I'll suggest if it is an initial load, create all databases and...

De-duplicate your source before merging, or find a better match key.

Sure. Always match on a unique key (must be unique in both source and target).

Do you mean a fixed-width file?

I've never heard of a fixed-length file before.

One way of achieving this is by creating your source query such that you get one row per job code history. So, get results that look like this:

(EmployeeNumber, FirstName, LastName,...

This is correct. It needs to exist at design time.

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.