MidBar (11/11/2010)

---

Thanks Elliott,

Yes agree with your point.

I am trying to do data archiving. Moving OLD records from Live DB to Archived DB.

So live DB should have records only those records...

tmitchelar (11/11/2010)

---

Elliott Whitlow (11/11/2010)

---

tmitchelar (11/3/2010)

---

There is a solution property called Run64BitRuntime. You can set it to false to run in 32 bit mode. Note - I wrote 32...

Henrico Bekker (11/11/2010)

---

Elliott Whitlow (11/11/2010)

---

tmitchelar (11/8/2010)

---

Pakorn Pankasem (11/8/2010)

---

Hi wanlapa linlawan

When you help someone please understand what they need!!! or what is problme!!!

You are head of DB and Bi so you...

Then I stand corrected..

CEWII

The answer is yes, sort of.. You can build a UDF that references another table in the same database, and use that UDF in the formula, I believe you...

I'm going to make a simple really painful statement.. Your data will not all be recoverable.. Some may but not all. Tables that are not corrupted *may*...

tmitchelar (11/8/2010)

---

Pakorn Pankasem (11/8/2010)

---

Hi wanlapa linlawan

When you help someone please understand what they need!!! or what is problme!!!

You are head of DB and Bi so you should read more....

I interview...

I probably wouldn't do this in SSIS, I would modify the query that pulls the data and does the convert there, it would be WAY more efficient. Not sure...

Programatically building packages is not for the faint of heart, I wouldn't start with that solution..

How many tables are we talking about here and does their structure change...

You could do it with a script task or even an exec SQL task. Script task might be easier..

CEWII

I understood the context and have done this before. In my case the record would always be either an insert OR an update in the same run, never both,...

tmitchelar (11/3/2010)

---

There is a solution property called Run64BitRuntime. You can set it to false to run in 32 bit mode. Note - I wrote 32 bit, not 34...

My initial thought is you might be mistaking terms..

DTS Packages that are migrated are turned into SSIS packages and therefore would not be under the legacy DTS packages they would...

sudhakara (11/10/2010)

---

lucazav (10/10/2008)

---

I got the solution empirically... The package goes on with this string stored in the @cmd variable:

C:\Progra~2\Micros~2\90\DTS\Binn\DTExec.exe /DTS \MSDB\StratificaGiacenzaDaCSV /SERVER DV-ERP /SET \package.variables[strRollUpDate].Value"; 2008/10/01 23:00" /MAXCONCURRENT "...

They are encrypted by default, the default config saves them encrypted so that the user who entered them can decrypt them but nobody else.. I personally NEVER save passwords...