We have a TeamCity (TC) server which we use to automate many repetitive jobs, in the spirit of CI.

Such things include:

1) Moving changes from source control to QA databases

2) Building...

This works, as long as the folder hierarchy depth is always the same. If not, you'll have to get more complex & use TOKENCOUNT too.

token(token("c-Drive\\Files\\Data\\Claims\\Current Load\\31 Dec 2012.xls","\\",6),".",1)

rawatsonika4u (4/13/2015)

---

I’ve forgotten the password of SA account, therefore I am not able to login to my SQL Server 2008 R2. I have another account, but with no special privileges....

ankithimmatlalshah (4/13/2015)

---

Hello Phill,

Thank you for the response.

I've finally managed it with script component, wherein I replaced the column separator with vertical pipe and row separator as TAB character and managed...

ankithimmatlalshah (4/10/2015)

---

Hello Phil,

Seems like you are trying to tell the following solution.

http://visakhm.blogspot.in/2014/06/ssis-tips-handling-embedded-text.html

Actually I tried to achieve it but the replace expression is throwing an error. It does not allow me...

Try this:

if object_id('tempdb..#dates', 'U') is not null

drop table #dates;

create table #dates

(

RecordId int primary key clustered

,RecordDate datetime

);

insert #dates

...

Change your text qualifier to something else.

karthik82.vk (4/10/2015)

---

Hi Both,

I just updated the post. its a typo from my end.

I tried LEFT JOIN and FULL JOIN however i am getting only one row.

the category table has...

Where does CategoryId 8 come from?

sam 55243 (4/8/2015)

---

Hi,

I have simple query, I'm trying to convert a varchar value to datetime format but it throwing below error:

The conversion of a varchar data type to a datetime...

MotivateMan1394 (4/8/2015)

---

some updates on some fields thats important for us

we need to re arange these fields once or twice a day . (when any one dont any change on the...

Regarding the Unicode errors, please have a look here.

Wow.

You just need to learn about apostrophes and we'll be in...

Please do not cross-post, it fragments responses and wastes people's time. Replies here.

What...