sappidi06 (10/10/2016)

---

I have the expressions defined in

1)Collection> Enumerator Configuration: Folder: C:\Users\ssappidi\Desktop\Uploads and 2)Foreach Loop Editor>Expressions> Directory @[User::FolderName]

Also i have declared a FolderName Variable and gave the...

rsampson (10/10/2016)

---

Mine is relatively close to this one.

My process deletes files from archive after x days.

I hit the loop and get the same complaint, but I've previously

moved 1 file to...

sappidi06 (10/10/2016)

---

Hi,

I am trying to load an excel file and update it on the database inside the for each loop in SSIS. When i execute the For each loop container...

mcfarlandparkway (10/10/2016)

---

I have a quick question, Instead of hardcoding or pasting a query in Execute sql task (SSIS package) Is there a way not to hardcode it?

I mean source is...

Wolfmeister (10/10/2016)

---

I have a client request to upload an Excel spreadsheet to Google Drive on a monthly basis, which I would like to automate - is this possible from SSIS?...

ramireddyjava (10/10/2016)

---

Hi Sir,Madam,

We are trying to implement global variables in SSIS. for example from development to UAT to production, the database details will be changed so that we need to...

Looks rather similar to my suggestion!...

Try this version too:

SELECT custid

, companyname

FROM sales.MyCustomers c

WHERE NOT EXISTS ( SELECT 1

...

Run them both in the same batch and check the relative costs.

Here's an alternative, though I'm not sure it's any better:

IF OBJECT_ID('tempdb..#Person', 'U') IS NOT NULL

DROP TABLE #Person;

CREATE TABLE #Person

(

PersonID INT

...

Grant Fritchey (10/7/2016)

---

The example looks like either XML or JSON. Do you know where the data is coming from? It's fine that it's stored in a VARCHAR field, but if...

XML, not SQL.

XML is text, but in structured format, with start and end 'tags' around data items.

niall5098 (10/7/2016)

---

thanks for the reply.

the column contain a string of data. within that string I will see the following entries:

<new_pmetd_refno>4110</new_pmetd_refno> ...

niall5098 (10/7/2016)

---

HI There,

as the heading suggests I am trying to query a text based audit for specific values then compare them values. For example the column should contain and new_ref_no...

Jeffery Williams (10/6/2016)

---

I will give it a try thank you. AND I don't have to count I just need to know if the result is greater than 0. Basically...