Sean Lange (1/4/2013)

---

SQLRNNR (1/3/2013)

---

I have to disagree with the correct answer(s). The question asks for 4 correct answers yet 5 are presented. This causes a bit of a...

I must concur, I wasn't thinking exactly...

I solved it like Toreador, but at the same time I found the explanation about the literals interesting.

thanks for the question!

Hugo Kornelis (12/23/2012)

---

I have to offer my apologies for this question. I don't know what went wrong. I always check my question, answers and explanation several times before submitting, but...

Just FYI,

because of the pain of SQL Logins and passwords and what BIDS/SSDT does with them, I prefer to use Windows authentication. All of my connections rely on the...

The error you have above is because BIDS/Windows won't let you open up the packages and maintain the named SQL Logins and passwords that you have saved in the connections....

Hey Andy,

Just to be sure I read this right...

Win2k, SQL2k? In 2012?

Wow... makes me glad that management lets me upgrade to newer stuff than that!

murthyvs (12/16/2012)

---

Hi dwain.c - I tried changing VARCHAR(8000) to VARCHAR(MAX). Ran the query with new pattern [0-9A-Za-z]. My input string is a very long string.

sample:

3038469

3138470

The results were as expected BUT...

Is the account you're running BIDS under on the admin list for the SSAS instance?

Is the account with the error the account you're running BIDS under?

1. Generate a config file and put the username and password within it. From the SSIS menu in BIDS.

2. Why not add the SSIS package to the SQL Instance?...

I agree... the research as to the various set options was worth the...

I'll second that one... and I've run into this "funness" before too. Still...

2005 has been off of mainstream support for...

I agree, of course the discussion afterwards generally gives a better explanation and interesting conversation anyway 🙂

I've run into a couple issues with SSIS

We run a lot of SSIS jobs all day... several thousand.

SSISDB maintenace if you're using Project Deployment is poor by default.

It defaults...