nitin.varshney (10/31/2013)

---

Hi I have some questions which i have not found the answer in your post Please suggest.

I have create the same package step by step for the text file...

Last week, I had this situation where my result showed 1 instead of 0 when the values had minus sign. I was confused and did not want it in...

Mark-101232 (10/15/2013)

---

SELECT A.*,CA.*

FROM @Temp A

OUTER APPLY(SELECT TOP 1 B.ReportType

FROM @Temp B

...

Thank you Sean...

I was just trying with tally table..and you made me to be sure of it...Thanks a lot..

Hi Lowell,

After googling, i have learnt to open a new clr stored procedure project to convert rtf format. But as i told,...

Lowell (8/6/2013)

---

i've done this two different ways via a CLR; one that uses System.Forms, and another that calls a web service that does the same thing, basically;

there are some regular...

Hi Lowell,

The Texas A& M is superb. This site has an option of Batch processing. It just made me curious, how many addresses can...

Whilst that's true in the strictest sense, all but the simplest of packages should use config file (or some other external method of package configuration). That way, when you...

Okay Martin...Let me try with config file for each child package...

Lowell (7/31/2013)

---

i've used the free portion of this web service, which does a best-lookup of an address and converts it into the official standardized address pieces...if it's an invalid address,...

Hi Lowell,

I can not use this web page as you say it would do only about 1000 addresses . i have more than 30000 addresses...

Grant Fritchey (7/31/2013)

---

With that, I suppose it would then be possible to successfully break things down. It still depends on accurate entry, but having a mechanism to validate the entry...

If this table copy requirement is part of a larger process workflow that must run in SSIS, then you could also add the INSERT INTO or SELECT INTO statements inside...

Eric M Russell (7/26/2013)

---

I wouldn't even attempt to use SSIS to make daily copies of tables with schemas that can change daily.

First, you can query INFORMATION_SCHEMA.COLUMNS to determine if there...

John Mitchell-245523 (7/12/2013)

---

Check this out. You can then use the variable to set the ConnectionString property of...