Check this rough draft....Hope it will be helpful

--CREATE TABLE dbo.PersonInfo

--(

--PersonID INT IDENTITY(1,1),

--Name VARCHAR(20),

--Gender CHAR(1)

--)

--INSERT INTO dbo.PersonInfo (Name, Gender)

--SELECT 'Frank', 'M'

--UNION ALL

--SELECT 'Peter', 'M'

--UNION ALL

--SELECT 'Monalisa', 'F'

--UNION ALL

--SELECT...

Just for curiosity..

if we don't know the maximum numbers of mac_address's associated for the Name.

Say here we have 4 mac_address associated with the Name "sn4051536", so went for RN=4...

http://social.msdn.microsoft.com/Forums/en/sqlanalysisservices/thread/84135cb3-e920-43a8-bcef-0a36c05d774d

Check out this..!!

check your Mail... PM..

shairalt (9/13/2010)

---

I'm still fumbling with SSIS so please bear with me.

I have four SSIS packages (using SQL ‘08) that need to be executed simultaneously. I thought I could use...

Sql_20 (8/30/2010)

---

Hi

I need a help in creating a package which will copy new file dropped in the folder using SSIS. Folder will have textfiles for eg: abc_26-08-2010_27-08-2010,

abc_27-08-2010_28-08-2010. Please help...

DECLARE @FileName VARCHAR(8000)

SET @FileName='SSC1, SSC2, SSC3'

CREATE TABLE #FileNames

(FileID INT IDENTITY(1,1),

FileNameList VARCHAR(30)

)

SET @FileName=LTRIM(RTRIM(@FileName))

--SELECT @FileName

BEGIN

...

SELECT s.name + '.' + o.name

FROM sys.objects o

JOIN sys.schemas s

ON s.schema_id = o.schema_id

WHERE o.type = 'U'

why we need "AND LEFT(o.name,...

PaVeRa22 (7/22/2010)

---

I ran(still running), 1 package with 15 instances per minute, 1 run for every 4 seconds, execution will last about 10 seconds

this is about.. moving files to different folder...

Thank you Basker.

I read something related to this ..

stating that...this can be done by in Script Task..

or there is any other way to refresh the Metadata of that package so that...

PaVeRa22 (7/9/2010)

---

First let us know below details.

1. how you are activating/running package means, are u using sql job or commandline command or autosys or esp or maestro etc

2. are ur...