Nice question Dwain, thanks.

blasto_max (1/8/2014)

---

I get exceptions in my C# script task. Does SSIS point to the exact line which caused it ? If not, then its going to be a real pain...

Can't you store the data somewhere every month so you can access it for your report.

Build some sort...

You read the file with SSIS, do the transformations with a derived column and write the data back to a file.

At design time, the object needs to exist. BIDS needs the metadata.

Once you designed the package, the object doesn't longer need to be there.

ps: validation should be set to FALSE.

No problem, glad...

corey lawson (1/8/2014)

---

Let's say the name of the linked server to the DB2 database is "IBM", and the DB2 database it's connected to is "TheData".

You can run this query...

Because it is a varchar(max), it is probably BLOB data. Try storing it in an object variable, and then convert it to a string in a script task.

(there are plenty...

vkmnair (1/8/2014)

---

Dear Koen,

Could you please help me to undestand why which required bith 64 & 32 bit version of oracle client.

I have already requested to my system admin to install...

sneumersky (1/8/2014)

---

I have a personal preference (if possible) for remoting into a dev server that has BIDS installed so that my machine does not get crippled.

Koen/Kraig,

Is this type of external...

SSRS, together with SSAS: 70-466.

There's no book, but you can use the training kit for the 2008 exam. It covers about 70% of the 70-466 exam (not much has changed...

Ooooh, a question about data mining, one of SSAS most powerful but least used features.

Nice question, had to do some research.

ramana3327 (1/7/2014)

---

Hi,

I have a question.

I have a ssis package in the DW environment. How can I run this package in the production environment by creating the job and run...

You'll need to read up on dimensional modelling.

The Data Warehouse Toolkit by Kimball has a specific chapter on insurance.

Star Schema The Complete Reference is also a very good book.

Because god-forbid that a process would run smoothly for once in a while

:unsure: