colin.dunn (9/7/2016)

---

Good Afternoon All, This is my first post.

I created the below code and if works fine. However my DBA said "It does the job but is clunky" how could...

Bill (DBAOnTheGo) (9/6/2016)

---

We have a group that when they have SA, it creates all tables as dbo.table. This makes sense since SA makes them default to dbo. When we remove...

He may be OCD with names, yet he still managed to misspell Jeff's.

Thom A (9/5/2016)

---

Phil Parkin (9/5/2016)

---

I'm planning to use function to remove spaces, quotes and "JR" , is there any function already exists?.so I can reuse same else I will start...

Not specifically. I...

koti.raavi (9/5/2016)

---

I have two tables joining based on Member ID and Member Name. My question is do we have any function like lookup in ssis

Ex:

Table1

...

Not even then. Instead, export the packages from SSISDB, put them into VS projects and build/deploy from there.

Ok, I'm away from my PC right now, so can't check details.

Have you tried creating a brand new solution/project and adding a new package to it? Just to rule out...

You should leave the catalog db alone and simply redeploy the packages.

Which version of SSDT are you using?

As were our replies, whose questions you have not responded to.

coool_sweet (8/31/2016)

---

sorry type mistake, suppose i have 41 rows ,20 processed successfully and 21th got error.

now when next time my package run i want it to start fro 22 rows...

As...

coool_sweet (8/31/2016)

---

in my ssis package , i have 6000 rows coming and i am puttingin 1 file.

now my requirement is if more than 6000 comes, ex 8000 , 6000 will...

Is the hardware config (CPU/Cores/RAM/Disk Architecture) the same in both environments?

Have you done a side-by-side comparison of the database properties under the 'Options' node in SSMS?

Same question for the properties...