In companies with a number of DNS domains I have seen this OFTEN, when they are setup they include 1 or 2 but there are say 5 total.

CEWII

I'm guessing you are adding the files then trying to add them to the Filegroup, I believe you need to specifiy the filegroup when you create the file. I...

That kind of question leads me to question the qualifications of the person interviewing me and an indication the interview is heading south.

I would have to ask which portion of...

The first two no, those are only meta-data about the package creation, just the connection string needs changed. I only have one in my package so I'm unsure what...

Provided that you have the same table name created in both schemas I would view this as a defect and log it in Connect or at least look there to...

Not sure if I am adding anything to the discussion but..

I fully agree "default order" is never guaranteed without an ORDER BY statement. In previous versions, at least 6.5...

I would contend it is neither a policy OR a SQL issue. I think it is tied entirely to the installer not wanting to deal with the connection to...

Not to be plugging Red-Gate BUT I have been using their SQL Monitor product and have been pretty happy with it.

CEWII

You are very welcome. I have a basic set of maint plans that are the template for all my servers, I adjust the servername import them and then start...

I'm guessing this is an NTFS thing, it sounds like the security ACL for the file is trashed, it might make sense to delete it and figure out what needs...

In SSMS you can't..

However, if you have the maint plan as a DTSX file, you can. You need to look for a line <DTS:Property DTS:Name="ConnectionString">

And following it will be:...

To perform the moves of the files.. Did I miss something (entirely possible 🙂 )..

CEWII

You are very welcome.

CEWII

Use the input/output wizard and chose the tables and at the end save the package that should give you 98% of the work and be a lot faster than SELECT...

I have to challenge this entire methodology. A select into is not the fastest way to do this, if you have a source and a destination connection manager that...