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

sks_989 (4/5/2016)

---

Thanks everyone input i was able to do from creating function

CREATE FUNCTION SplitString

(

@Input NVARCHAR(MAX),

...

Jon.Morisi (4/5/2016)

---

So a Visual Studio 2015 license / full install is required to do SSIS package development in SQL 2014+

...correct?

The link for Microsoft SQL Server Data Tools - Business Intelligence...

Jon.Morisi (4/5/2016)

---

Hi,

Can someone please help me navigate the SSDT waters?

I just setup SQL Server 2014 and would like to do some SSIS package development. Hopefully I can avoid paying...

Luis Cazares (4/5/2016)

---

I constantly avoid that person's threads. It doesn't...

sks_989 (4/5/2016)

---

I am getting error while i run query. Client id is numeric 18,0 when i run with parameter with ALL it is working, It is in statement

DECLARE @clientid varchar(20)...

clbishop (4/5/2016)

---

Hello. Pardon me, I'm new to both this forum and SQL.

I need assistance with code that will allow me to change the return order of week names. Currently, the...

Gail and I are gamely persevering with this one. I think my pressure limit has been reached now, though.

swansonm (4/5/2016)

---

This would work if the termDate is the date of the term of that line/effective rate, but not since the termDate is actually the term date of the line...

The error message provides that information, if you read it closely enough.

Your error (as you posted originally) was this:

"Cannot truncate table 'Postal_StateProvince'...

Are there any 'singular spaces' anywhere else in the data?

If yes, you have a very solid basis on which to complain to the creators of the files – how would...