Never mind no.1, I've figured it out....'Build' basically creates files containing the package, allowing deployment to multiple instances.

YAYYYYYYYYYYYYYYYYYYY!!!! The small red cross is gone!! You don't know how big a pain in the neck that was for me yesterday!!!

You can have a few...

Error1; expectedC:\Users\BubblesA\AppData\Local\Temp\\SSIS\2cf9337495804a85b10c6d286ada294c\ScriptMain.cs1016

st_04c9a6a3068e41a3ab44a1a18872b650

Error2Resource file "Properties\Resources.resx" cannot be found.st_04c9a6a3068e41a3ab44a1a18872b650

Error3Non-invocable member 'Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel.Variables' cannot be used like a method.C:

\Users\BubblesA\AppData\Local\Temp\1\SSIS\2cf9337495804a85b10c6d286ada294c\ScriptMain.cs4717st_04c9a6a3068e41a3ab44a1a18872b650

Error4'Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel' does not contain a definition for...

Indeed, but can it store connection information, so as well as commonly repeating tasks, can the...

MysteryJimbo (2/13/2014)

---

I find it extremely strange that a migration should be estimated to take a week. With enough preparation you could have this done less than a day.

I have...

Come to think of it, after we have created our packages, is there any way to put the DB back into a state where we can restore any logs created...

SQLRNNR (2/12/2014)

---

That will work.

But why not apply those transaction log backups to the target as the backup occurs? You could logship those databases and keep them in sync and...

Hi Luis,

I think we've pretty much set our minds to getting this migration done, especially the DTS-SSIS conversion.

What about the rest? Do you agree with the step sequence/contents?

Luis Cazares (2/11/2014)

---

Eugene Elutin (2/11/2014)

---

2. I wouldn't rename your "pivot" column as it may be used under that name by many calling processes. In this case you will need to...

Cheers all you guys!!

Ed - could you let me know how it's open to injection - any idea how we can bulletproof that?

Worked great, thanks!!!

Cheers guys!!

Another question, I have a LOT of these to build, typically I'll only need 2-3 tasks and a couple of connections...

Is it possible/worthwhile using the Wizard to create?

Very helpful, thanks!!!

GilaMonster (6/24/2012)

---

Jake Shelton (6/24/2012)

---

But again, what I would like is a script I can run next weekend which is integrated into the defrag script, so that once defrag is complete,...

GilaMonster (6/24/2012)

---

Don't shrink the log regularly...

In bulk-logged recovery you're better off rebuilding the indexes than reorging, as rebuild is a minimally logged operation. Otherwise increase the frequency of your log...