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...

CONCAT( edit.ruleid, qr.description , 'Edit Code' )

You know about the perils of the (NOLOCK) hint, right?

May I ask why you are converting Row_Number() to an INT everywhere?

MadAdmin (4/7/2016)

---

amitsingh308 (4/7/2016)

---

Create table Script is as under:

Create table OrdersDetails(OrderNo varchar(30),ItemNo Varchar(20),ItemName Varchar(50))

insert script is as under:

Insert into OrdersDetails (OrderNo,ItemNo,ItemName) Values('122314','1','sdfasfasd123')

Now I want to change sequence number for order...

SQL!$@w$0ME (4/7/2016)

---

Hello guys,

We are planning to enable CDC for one of our databases.

Can we restore a copy on a different server (WITH KEEP_CDC option) and run the initial/incremental load...

Unticking the 'Sensitive' check box does not reveal the password, in case you were wondering.

SQLTougherGuy (4/6/2016)

---

Hi Phil,

If you are using integrated security, what security issues concern you?

I guess my question should be... "What types of security issues will I have to concern myself with...

SQLTougherGuy (4/6/2016)

---

Hello all,

I am going to try and explain what I am looking to do here, so please bear with me :-).

I have several SSIS packages that run off of...

amitsingh308 (4/6/2016)

---

Hello Everyone,

I have a transactional table which contains following columns

OrderNo. ItemNo. ItemName

But there is an issue I need to rearrange the item number if order number...

Jeff Moden (4/6/2016)

---

Link? I'd just like...

IF OBJECT_ID('tempdb..#a','U') IS NOT NULL

DROP TABLE #a;

CREATE TABLE #a (col1 sysname);

INSERT #a

(

...

Check out the most recent 'I am proficient ...' comment. I nearly regurgitated my breakfast cereal.

I am assuming that your FTP is running over the Internet. Try running this[/url] test, from both servers. Should...

dallas13 (4/5/2016)

---

Hello,

So we have 1 server in east coast and other in TX rackspace.

We have around 2 GB zipped db backup sitting in TX.

I have FTP job running through SSIS...