ronan.healy (6/27/2014)

---

i have the following code in my conditional split

((TRIM(INV_SECTYPE_COD) == "70")) && ((TRIM(INV_SECTYPE_COD) == "71")) && ((TRIM(INV_SECTYPE_COD) == "72")) && ((TRIM(INV_SECTYPE_COD) == "73")) && ((TRIM(INV_SECTYPE_COD) == "74")) && ((TRIM(INV_SECTYPE_COD)...

antonio.estima 4150 (6/26/2014)

---

No, I can copy via windows explorer file from server A to server B in the DMZ. But when I run the SSIS package via SQL Agent, when...

Grrr!:angry:

Great, well done.

If you're using a SQL Agent job, you should have nothing to worry about. If the job is still running after two minutes, it will not be invoked again until...

antonio.estima 4150 (6/25/2014)

---

I understood what you said, but look, the target server is outside the network. The same is in the DMZ outside the domain to access it is through...

You can capture the current iteration's file path in a user variable.

Have a look at the Variable Mappings section here[/url] and let us know if you need more info.

antonio.estima 4150 (6/25/2014)

---

Hello Guys,

I have an activity that was created using SSIS 2008 R2, which consists of copying a file from a server within the network to a server...

imani_technology (6/24/2014)

---

Quick Update:

I decided that using a simple backup/restore might not be the best idea for staging. Why? Because:

1) We are backing up from one server on one...

You have some bizarre looking char dates there.

Are you looking to do INSERTS, or INSERTS and UPDATES or INSERTs, UPDATEs and DELETEs for your incremental load?

Do you have such columns...

Stuart Davies (6/18/2014)

---

I am a single point of failure and have been all the time in my current job (5 years) and support in house applications. Apparently we "don't have...

If you script the stored proc as CREATE from SSMS, you will see something like this at the start:

set ansi_nulls on

go

set quoted_identifier on

go

If you make sure that your set options...

Then the backup/restore idea will be fine.

Beatrix Kiddo (6/17/2014)

---

My Senior DBA likes to be the only one that knows some stuff so (in my opinion) he actively excludes me from situations where I might be able...

Via a SQL...