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...

try and do a repair of shared features of your 2016 install

have you tried this ? http://www.microsoft-sql-ssis.com/2015/09/how-to-create-and-use-temp-tables-in.html

SSDT will install with a visual studio shell - no need to get a full version of visual studio just for this.

The following may help if the truncation error is on the load to the final table - http://www.sqlservercentral.com/Forums/Topic1300952-364-1.aspx

if the error is on the input file itself then changing the input...

as I am also a Oracle/DB2 person I have used these a lot in production - and the current projects I am working on 2014 will use them also.

...