I didn't add the compression statement, that is generated by the BIML code.

I found out that I couldn't select all my BIML files. I have to select in a specific order.

Thanks,

Phil

I'll have to hunt down some other examples because I really don't get what the sequence object is used for in their examples.

Thanks.

Thanks for all the tips. Since the tables are so wide that I am importing into a stage table I am having to break down columns that I want keys...

The Dense_rank is perfect. It allowed me to run it against all my columns. I even replaced my Row_number with it.

SELECT t.TransactionId, dense_rank() over (order by T.TransactionID) as TXKey,

t.FacilityAccountID, dense_rank()...

I am new to tabular modeling and from what I have read is that queries shouldn't take longer than a few seconds. My transaction table is just short of a...

Windows Server 2012 R2 Standard

I have it fixed. I had to disable the firewall on my Windows Server 2012 R2 machine that had the 2014 tools installed. It seems that either my request going...

I check both machines and I do not have any aliases created in either of the SSCMs clients.

I believe the alias is webserver1 for the entire cluster.

But why do I need to specify a port when connecting through SSMS 2014 and not in SSMS 2012?

Do you...

That works, thanks.

The link to "Need an Answer? Actually, No ... You Need a Question"

Yes.

And then I gave...

I have an SSIS Package that runs from a job scheduled on SQL Server 2008 R2 and I need to move that job to SQL Server 2014.

In the package's...

I had a system refresh and now that download doesn't work. I get asked what tool to open it with. I tried the Visual Studio Selector, but no luck.

Do you use a naming convention for lookup tables so report writers have a way of noticing them before they go create their own? Their own schema or prefix...