Good...

Easiest way is to use SSMS -> Export Data and Save as SSIS package, then schedule the execution of the package.

😎

But not from SSDT?

😎

Is this a one-off or do you want to do this regularly, i.e. as a scheduled job? There are quite few options, bcp, sqlcmd, SSIS etc., please let us know...

Can you elaborate a little bit further on this, i.e. source details, destination details, limitations etc.?

Are you familiar with bcp?

😎

Further on my previous post, even having the preview on in Windows File Explorer and that particular file selected will block the file, have you checked if the file is...

What are the settings in server->properties->database settings->Database default locations?

😎

taufikalfarisi2 (8/21/2016)

---

it was solved with

DECLARE

@TypeCode varchar(25),

@BomDateB varchar(25),

@BomDateA varchar(25),

@TbName varchar(25),

@sql nvarchar(max)

SET...

Use a Derived Column Transformation

😎

drew.allen (8/17/2016)

---

I realized this morning that my code needed a slight update. My updates sample data had the same ordering for the from_seq and the to_seq, but that is...

If you had answered the questions properly and given appropriate examples then you would already have had a working solution by now.

😎

To achieve this, just add another instance to...

Quick question, what is the Isolation Level set by the applications?

😎

Head-Desk :pinch:

😎

Can you please post the DDL (create table), some sample data as an insert statement and the expected results?

😎

What you have described so far isn't a complex task but it...

The way you describe it here does not fully match the initial requirements, can you please elaborate?

😎

Generating the output in the format described in your last post is easy, here...