As said you can do it with C#. - but execute it on the SQL Server server machine, not locally on the users machine.

see https://msdn.microsoft.com/en-us/library/ms403355.aspx for ways to execute a...

newer versions of VS are supposed to be backward compatible..

and at least with SSDT for VS 2015 on the Integration Services project properties there is a TargetServerVersion property that allows...

you can do it in c# or powershell - see a good example here https://blog.netnerds.net/2015/01/powershell-high-performance-techniques-for-importing-csv-to-sql-server/

main thing is not loading everything in one go to a data table - load a...

I'm sure others will give more feedback.

from my point of view having data and logs on the same drive are not necessarily bad - all depends on the workload.

If nothing...

imani_technology (8/30/2016)

---

By the way, I have three questions about the code

C:\DTEXEC -f test.dtsx > C:\folder\output.csv

1. PowerShell won't allow "&gt". Is that a typo?

2. How do I pass...

hi,

In terms of getting the output of the DTEXEC command onto a file how it is done depends on how you execute it

- if executed from a SQL Server...

theres no limit to the number of columns you can update in one go.

UPDATE a

SET a.color_cat = b.category

, a.location = b.location2

FROM objects_table a

JOIN shades_table b

ON a.[object_name] LIKE...

you already have your answer - you need to create a paging mechanism, and the API documentation should state how that is done.

And without us knowing what is the...

easiest way is to build the records on SQL and then just output to the flat file as a single column.

One approach I've taken on this is to have a...

you can automate it - but depending on your volumes and what you do with the partition of over 90 days you may have performance issues.

assume a weekly process.

current table...

Few questions.

As you are considering partitioning I assume you are on Enterprise version.

When you say a few million is that 10, 50, 100, 500, 1000?

Is the table modified by that...

arkiboys (8/17/2016)

---

Hello,

using a combination of ssis and C#, we are placing file data into sql server tables.

The files contain around 70 million of rows...

We can not use bulk insert as...

I think that message is not directly related to "always on encryption".

Microsoft SQL Server Native Client Version 11.00.2100

Running connectivity tests...

Attempting connection

Connection established

Verifying option settings

INFO: Data encryption was enforced by server...

try also searching for the hex version of vb.

select * from sys.sql_modules

where definition like '%7662%'

Most malware I've seen on sql server execute a hex version of the code which gets...

Is that deadlock related to the remote server or local server? being that you are updating the local server I would expect it to be related to local resources, not...