So you want to trim from a certain point, and that point varies from one string to the next? Tough.

Can you describe the requirement more clearly please? Some examples would...

Left(Col1,[Number of chars to keep])

AarionSSQL (8/25/2014)

---

Hi All,

Could you tell me how to add database objects to BIDS Projects.

I am working on SSIS and have seen a project where the database object definitions such...

Mr.Sahand (8/25/2014)

---

Thanks Phil for the answer.

The rules are not too complicated to be done through T-SQL or Access query or VB scripting.

Although they are many in number. They are...

Mr.Sahand (8/25/2014)

---

I am new to SSIS.:-D

I have a number of MS access tables to transform to SQL. Some of these tables have datetime fields needed to go under some rather...

brad.mccollum (8/23/2014)

---

I have an SSIS package that basically does ETL on an Excel file then outputs everything into a new Excel file.

As an example, let's say my original Excel...

You can STUFF it!

DECLARE @Val1 varchar(5) = '12345'

declare @RetVal varchar(10)

set @RetVal = STUFF(@Val1,3,1,'A')

select @Val1

, @RetVal

rajeshjaiswalraj (8/23/2014)

---

I HAVE TO WRITE ONE STORE PROCEDURE THAT EVERY MIN IT HAS TO CHECK MY SQL INSTANCE IS UP AND RUNNING IF NOT IT HAS TO SEND MAIL. PLEASE...

Yes. And suddenly, yours is...

bhavik.bk (8/21/2014)

---

ok.. i checked this link http://technet.microsoft.com/en-us/library/ee634547%28v=sql.110%29.aspx , which gives me some ideas. But very less examples in relation to using values in coding. i.e.

you cant use it like you...

That is the design.

I'm not going to write the code for you - there are lots of C# loop and copy file examples on-line.

Please have an attempt and then come...

pcd_au (8/21/2014)

---

My experience is more with SQL2008R2 SSIS than SQL2012 SSIS, and I'm struggling to see the benefit of the Project deployment.

The solution I'm working on requires reading source data...

I'd use a Script Task:

1) Read file names from table into an array.

2) For each array element:

a) perform the file-existence check:

i) If true,...

I see no avatars for anyone.

Maybe this would be a slightly better WHERE clause (handles NULLs)?

WHERE NOT EXISTS ( SELECT B1.[BedDays]

...