ravi@sql (8/11/2015)

---

HI Folks,

Is it possible to replace while loop by CTE?

I will fetch records from table 1 based on tretmentid.

get the count of records

run the while loop

inside loop...

Is the package which you have modified definitely the same as the one which is being executed?

What the devil is this?

aaron.reese (8/6/2015)

---

Thanks Phil. first one to reply again!

The problem is that it is the generated dtsx that would get deployed and I need to be able to prove that...

Chad.Kemp (8/6/2015)

---

What is the best way in SSIS to handle records that fail due to improper formatting inflat file loads?

For example, I have a flat file connection with a particular...

I would consider source controlling the BIML scripts rather than the packages. Treat the packages as compiled code.

patrick_wolf (8/5/2015)

---

Hi all

We are currently migrating from SQL Server 2008 R2 to SQL Server 2014. Our environment consists of three independent SQL instances (Development, Integration, Production) and we are dealing...

I suggest you post this in a DB2 forum.

Minnu (8/4/2015)

---

Hi Team,

I have a table 'library' with two columns

user_name, access_time

every user is having more than 500 entries, i want to keep only top 50 records for every user and...

kingdonshel (8/4/2015)

---

Actually no I have not used the """" quotes as a text qualifier, the reason for this is that only the Comments column has the double quotes, the other...

Thanks for doing a proper analysis :blush:

Sorry, your CASE construct is generally OK.

CASE F234.TECH_TRAN_TYPE IN (

'CRB'

,'CRD'

,'CPB'

,'CPB'

)

Should be CASE WHEN ...

I suggest that you cut back the proc definition to one that works and then start...

Case x when 'y' then 'z' end

You need the 'then' and you need the 'end'.

Get the file name into a variable.

Use Token to break the file name into the components you need and assign these components to other variables.

Add an ExecuteSQL task to execute...

sej2008 (8/3/2015)

---

Hi everyone,

I am using ssis 2012 to import data from excel 2007 in to sql server using oledb destination and for transformation using Data conversion as some dates in...