Thanks All for your valuable input.

Hi All,

Thanks for helping . Attached are a few screenshots of my drives. These are SAS drives . Please provide your recommendation accordingly .

Thanks,

PSB

Hi,

My comments below :

You can add some more files in the Tempdb. See best practices for configuring tempdb on the net. ----> What other files can I place on...

Yes SQL was installed on the C drive . C/Temp/SQL Install (3.986 GB of 3.96 GB )

TempDB Size = 13367.00 MB

C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA is the path of data as...

Under F drive we have two folders :

BACKUP -- 77.1 GB

DATA --47.5 GB

Under G drive : Used space is 12.6 GB and Free space is 27.3 GB

We keep running...

Although the message is not clear, the error is because of these two fields.

When I comment out these fields in the source query, the package runs fine.

I have used a data conversion task and converted to DT_TEXT and then mapped it back to the destination. However the error still persists.

[SSIS.Pipeline] Error: SSIS Error Code DTS_E_PROCESSINPUTFAILED. ...

I am doing MAX( CASE WHEN ParentID = TaskID THEN TaskName WHEN ParentID <> TaskID THEN ''

END) OVER(PARTITION BY ParentID) + ' | '

to eliminate NULL values ....

Actually there is an issue with the data . We do not always have ParentID (71D5ECC4-93B4-E511-AD48-24FD5236B149) = TaskID , so this will lead to NULL values . If PArentID <>...

Is there any way we can get rid of MAX from MAX( CASE WHEN TaskParentUID = TaskUID THEN TaskName END) OVER(PARTITION BY TaskParentUID) + ' | '

I am getting...

Thanks. That worked.

We are doing a BCP because of the amount of rows to be fetched from Server 1 to Server 2 . The time shrinks to 2-3 minutes from 30 -45...

Thanks . 🙂

Can you help me where exactly I need the distinct ?

SELECT DISTINCT t1.ProjectUID,t1.BWF , t1.Deliverable ,

--Supressed data columns

STUFF(

(SELECT ', ' + (DISTINCT t2.[GeoMarket])

FROM #deploys t2

where t1.ProjectUID = t2.ProjectUID AND t1.BWF = t2.BWF AND t1.Deliverable = t2.Deliverable

FOR XML PATH...