Mine has now finished, i accidentally closed my browser. After i'd realized what I'd done i logged back into the portal to find it has infact completed. This, after i...

Right, so following the workaround in the article sent to me via the support ticket this led me to this resource: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-import. Following the instructions on there I have been...

Thanks Grant. I actually raised a ticket with MS about this. They've responded as follows:

More Information:
This problem occurs when many customers make an import or...

Hi,

I'm not sure I understand your question. Have a read of this: http://blog.sqlauthority.com/2012/08/24/sql-server-delete-truncate-and-reseed-identity/[/url] and see if that answers your concern. If not, reply with any more information/questions.

Thanks,

Simon

Hi,

This documentation relating to SQL Server 2014 seems to suggest you can specify a partition.

https://msdn.microsoft.com/en-us/library/dn589807(v=sql.120).aspx#rebuild

Thanks,

Simon

If I were you I'd start a new thread for that problem so that you get a better response.

I'm not sure you really understand what you are trying to achieve....

Hi,

Ok so here it is:

<Transformations>

<OleDbSource ConnectionName="EDW" Name="<#=row["SourceTableName"]#> ID's From Staged Data">

<DirectInput><#=row["DataFromStagedFact"]#></DirectInput>

</OleDbSource>

<Lookup Name="<#=row["SourceTableName"]#> Details From Source" OleDbConnectionName="AdventureWorks2012">

<DirectInput><#=row["DataFromSource"]#></DirectInput>

<InputPath OutputPathName="<#=row["SourceTableName"]#> ID's From Staged Data.Output"></InputPath>

<# string InputColumnMetaData = row["DataFromStagedFact"].ToString(); #>

<# string OutputColumnMetaData = row["DataFromSource"].ToString();...

Thanks for your reply! I have now sorted this but not using the URL you reference. The problem with the example you reference is that the columns are "hard coded"....

If it's a synchronous replica, there's always the latency between the nodes too.

Hi,

This is probably because you've got your SSIS project in the Project Deployment Model rather than the Package Deployment model. Package configurations are only available to Package Deployment Model projects....

Hi,

That's quite straightforward through the use of a case statement.

SELECT

CASE

WHEN Invoiced = 2 THEN 'Invoiced'

WHEN Invoiced = 3...

Error code 5 is an access denied message. It means that the account that your SQL Server service is running under doesn't have access to the location where you have...

Hi,

The last line of your query references @tblAmount but you haven't declared it and given it a type. That's why it's failing.

Thanks,

Simon

RTaylor2208 (8/16/2013)

---

In addtion to the above which is the most likely scenario. Are you using any filters in your indexes and are you copying all attributes as part of...

I agree with Grant. We rebuild all of our indexes once a month, we have problems with stats skew due to parent child relationships in many tables.

As Grant said if...