Charmer (8/11/2015)

---

Thank you Phil, you gave me an idea

but Just curious...Is there a way to get it on the GO?

Like we get the below informations....Just curious...through vb/c# coding?

FileInfo fileinfo;

...

Sure, just read the XML inside the file and find the value of the DTS:CreatorName property.

Charmer (8/11/2015)

---

Hi Friends,

In SSIS, I am trying to get file attributes through script task. I am using FILEINFO method to collect those information. I could get all the details but...

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