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...

I don't think that this is correct!

Tim Mitchell (8/2/2015)

---

Do you even need the table variable? Seems to me that you are creating the table variable strictly for the purpose of performing a relatively trivial update on...

If you read the original post, you'll see this:

...so the qualifier is there.

This is a...