ayazniazi (6/9/2014)

---

It is a Foreach ADO Enumerator

In the enumerator configuration I have set the object source variable to subtaskArgs which is an Object variable.

In variable mappings I have subtaskArgValue which...

clucasi (6/9/2014)

---

Hi,

I am trying check if a files exists and if so continue with the procedure and if not exit out of the Procedure.

the code I used below but it...

This should get you started

😎

DECLARE @SXML XML = N'<ClMetadataDataContract xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.cch.com/pfx.net/psi/">

<EntityType>1</EntityType>

<NameLine1>David Jones</NameLine1>

<NameLine2 />

<DefId />

<ClientID>jones</ClientID>

<ClientSubID />

<SortName />

<ClientType />

</ClMetadataDataContract>';

DECLARE @TXML TABLE

(

TXML_ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED NOT...

Thank you Ed for this very good peace, nicely done indeed!

😎

abuhaidar82 (6/9/2014)

---

Thanks for the reply, i will try to upgrade the application to VB2008, if i can find the source code :-D, because it's not my program..

anyway could vb2008 conver...

Ed's version modified to show missing ranges.

😎

USE tempdb;

GO

DECLARE @num AS TABLE (

ID INT IDENTITY(1, 1),

Price Money);

DECLARE @range AS TABLE (

ID INT IDENTITY(1, 1),

...

gstarsaini (6/9/2014)

---

Hi,

I have nearly 1 TB of CSV file data .I need to load this data into SQL database using SSIS.What is the best way to perform this(or how). Also...

ramana3327 (6/8/2014)

---

Hi,

I am working in a particular application. My work is to tune the sp that are using by that particular application. First, I want to list out all Sprocs...

kamamusic (6/8/2014)

---

Dear All,

I would ask for your help in order to be sure that my reasoning is correct. I am migrating a server structure from SQL 2008 to 2012 and...

tshad (6/7/2014)

---

Is there an easy way to send back to my C# program the pascal case of a field type? If you get the parameters or columns for a...

ykonline (6/7/2014)

---

Hi,

I have a requirement to import excel sheet which we receive daily, sometimes it may contain extra columns that needs to be imported to staging table as it is.

Please...

Would you be so kind to provide DDL (create table) scripts and some sample data? Then we don't have to do any guesswork:-D

😎

Somewhat belts and braces method

😎

USE tempdb;

GO

USE tempdb;

GO

DECLARE @num AS...

clayman (6/8/2014)

---

INSERT INTO @Range(LowerBound, UpperBound)

VALUES(1, 9),

(10, 24),

(25, 49),

...

ayazniazi (6/8/2014)

---

I have a for each container that is enumerating inside excel files. I have a file system task inside the container. The file system has to copy files from...