Set a default value for both.

For large installs with common developers Shared Data Sources are a MUST in my book. Shared Datasets are tough to get a lot of re-use from beyond queries that populate...

You cannot "allow multiple values" and "allow null". What you can do however is create the option by adding an option to your list of values called "Nothing" or "Null"....

Direct replies here:

http://www.sqlservercentral.com/Forums/Topic1753462-1633-1.aspx

Direct replies here:

http://www.sqlservercentral.com/Forums/Topic1753462-1633-1.aspx

As far as I know there is no native command in FTP to check if a directory exists. What you will need to do is get a directory listing for...

AdventureWorksDW2012 Data File

@mister.magoo, never seen APPLY used with a row-ctor to unpivot like that. Very cool.

Just for the sake of providing an alternative, we can do the same using a traditional UNPIVOT:

SELECT...

Two functions leveraging the calendar table for your consideration:

This one answers the question in your last post. You will pass in the year, month, week number of the month and...

That's because Agent is not a database-resident system....

titsiros (1/18/2016)

---

I think i prefer the insert into select option since its basically a the same as MERGE but with better performance.

There are two reasons while i would like to...

What I meant was, why not join the two tables in the query you issue from one of your SSRS Datasets? For example, let's say you had two tables, one...

Orlando Colamatteo (1/17/2016)

---

murtzd (12/17/2015)

---

Hi all,

I'm experiencing a very frustrating issue. I am using the guide below to read a cell value in Excel into a SSIS variable;

http://www.techbrothersit.com/2013/11/ssis-read-excel-cell-value-in-ssis.html

It works very well...

murtzd (12/17/2015)

---

Hi all,

I'm experiencing a very frustrating issue. I am using the guide below to read a cell value in Excel into a SSIS variable;

http://www.techbrothersit.com/2013/11/ssis-read-excel-cell-value-in-ssis.html

It works very well for anything...

You cannot install Microsoft SQL Server software in a Mac OS but you can run Windows in a VM on a Mac OS and install your software inside the Windows...