Grant Fritchey (8/25/2016)

---

The Metropolitan Museum...

Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do there for their age?

😎

Drew, have you tested your code with a full reorder of the set? I haven't had the chance but somehow I'm thinking it will return the original order as...

Sean Lange (8/22/2016)

---

I have always been accused of being a little over the top about making sure we have backups of everything in place in case we need to rollback...

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