patrickmcginnis59 10839 (4/8/2016)

---

--snip

The downside is that you have to learn sqlcmd. I really like it because I can parameterize the heck out of it, and run jobs against any database...

Greg A Goss (4/8/2016)

---

Without knowing anything else about the application/process/environment, what if you created the stored proc in the order database (the one that changes names) and then reference...

Satiz (4/8/2016)

---

Phil Parkin (4/8/2016)

---

Satiz (4/8/2016)

---

I will be creating it in staging and will test it if its works fine then i will copy the same procedure and recreate it prod...

Satiz (4/8/2016)

---

I will be creating it in staging and will test it if its works fine then i will copy the same procedure and recreate it prod without making any...

Satiz (4/8/2016)

---

Thanks for your reply .I need to change this dynamically because database name differs in both staging and production environment so we will passing database name as a...

lorisj33 (4/8/2016)

---

Thanks Phil,

I'm testing it this way because I eventually want to wrap it in a for each file loop, reading each sql file and exe the code one by...

Presumably the Integration Services service is running on the server and you are able to connect to it from an ordinary SSMS session?

xqzuo72 (4/8/2016)

---

Hello, Phil, Thank you very much for your help! I am a beginner of SQL. I use MS SQL server 2014.

I tried your code and substitute...

xqzuo72 (4/7/2016)

---

Hello, I need to find out the unique values in each column from the tables in a linked server. I have about 30 columns and 30 tables...

Have a look here.

There's something special about that number.

JTSash (4/8/2016)

---

Thank you, Phil. Not what I was hoping for, but at least I know. SSIS is not something that I'm familiar with (and little time to learn...

Insert order is not guaranteed when using BULK INSERT. I would recommend using SSIS for this, which can read and process your file in the order in which it is...

lorisj33 (4/7/2016)

---

Hello all,

I'm hoping someone can set me straight. I'm trying to use an Execute SQL Task, which seems successful, using an OLE DB connection, File Connection SQL Source...

terry_stjean (4/7/2016)

---

When deploying SSIS package to Integration Services Catalog (SSISDB), we need to have a folder created first, before we can create the Environments.

I know the Environments can be scripted.

Can...

John Rowan (4/7/2016)

---

Glad to help. I'd definitely get your sales hat on. It's hard when analysts and business folks try to dictate data structures and how we store...