S Hodkinson (12/15/2009)

---

This gets weirdier and weirdier. The first and second job succeeded but the last one failed. I checked the command line and it did have the...

BrainMan (12/14/2009)

---

My scenario is that I have developed a few SSIS 2008 packages not realizing that they would not run on my production SQL 2005 Server. So, my plan is...

S Hodkinson (12/14/2009)

---

The consultant used 'EncryptSensitiveWithPassword'.

The things I do not understand is that it was working fine for months and then just stopped. I can only think...

What package protection level do you use?

Can you show the us the complete command line you have specified?

Did you enter DTEXEC in front ? This is the application executing the package.

Panks-913490 (12/14/2009)

---

Hi,

I am trying to export huge data sets to .csv files.

Some of these datasets have 100k rows.

The problem is any .csv with more than 65k rows will not open...

BrainMan (12/13/2009)

---

In the many pounds of books I've been reading on SSIS lately, it seems most experts are recommending to install SSIS on a box separate from the SQL Service...

This is duplicate post. The question answered here.

This is not enough. Here is what you have to do. Go to your job and open the properties. Modify your package execution command line to include /REP V to...

You are not looking in the right place. Go to SSMS...

Can you send the complete error you are getting?

ducon (12/10/2009)

---

Hi there,

I have a question regarding the lookup transform. I know there is a disk cache available in SSIS 2008 but I'm looking into something in SSIS 2005.

I have...

vivekjamshedpur (12/9/2009)

---

In my project there is a simple select query whose 'where' condition will filter for particular records for a company which is having one ID.This where condition is actually...

beezell (12/9/2009)

---

At first blush, this was my thoughts too. Everything I've checked appears to be up to date. Any ideas on where I could check to make sure...

If you can...