NewbyUser (9/7/2016)

---

Hi everybody,

i have a problem with a scalar valued function. There are two systems who will use the function to create new "OrderNumbers".

Sometimes the two system use the function...

Koen Verbeeck (9/7/2016)

---

Yes, but be aware that the Move method cannot...

Or if you are happy writing some C# and using a Script Task (my preference), it takes only three or four lines of code. I can provide an example if...

No problem. Keep posting your questions...

It's probably easier to leave the destination file name as is and add a subsequent task to do a copy/rename.

If you do a search on SSIS file system task rename...

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?