Can you upload a sample package so we can reproduce the error?

Can you explain in more detail what it is you are trying to do?

Personally, I never use the deployment manifest. I also store my Package Configurations in SQL Server. This...

Create a record using an Execute SQL Task (SQL) before starting your Foreach Loop Container (FEA) with two columns = 0.

Update the record with an SQL at the beginning of...

Looks like you set all the necessary properties correct. Have you checked your package in BIDS? Can you upload your package so we can have a look at it?

Look under Type Casts in the Derived Column Transformation.

An alternative to check the Row Count in a script is to use a precedence constraint. For Evaluation operation use Expression and check for RowCount > 0.

The precedence constraint is...

I first had to lookup what lakh means - lucky there is Google 🙂 and Wikipedia :-))

So you have about 200.000 records, right?

Scalar funcions are notorious for causing performance problems...

You're welcome. I had fun solving the puzzle.

Do it like this

SELECT DATEPART(yy, date) AS [Year]

,DATEPART(ww, date) AS [Week]

...

Try this

SET DATEFIRST 1;

SELECT (DATEPART(wk, '20091225') + 50) % 52 + 1; -- returns 51

SELECT (DATEPART(wk, '20091226') + 50) % 52 + 1; -- returns 51

SELECT (DATEPART(wk, '20091227') + 50)...

Ooops, you're right. Looks like SQL Server says week 1 starts on Jan 1 like BOL say, but week 2 then starts on the day you specified with DATEFIRST.

This behaviour...

Hold your horses Gandalf! Who said anything about hard coding?

The value to subtract can easily be calculated dynamically and integrated into the query:

SELECT DATEPART(wk,DATEADD(dd, -(@@datefirst + 7 - DATEPART(dw,...

From BOL:

January 1 of any year defines the starting number for the week datepart, for example: DATEPART (wk, 'Jan 1, xxxx') = 1, where xxxx is any year.

One workaround is...

Not sure what you are trying to achieve here. I also suggest you check BOL to understand the syntax, but here's two additional comments:

1. why write convert(varchar,20100201) and not '20100201'?

2....

Or

SELECT put column names here -- don't use select *

FROM ORDERS

WHERE DATE IS NOT NULL

AND (CLIENT...

Guus,

Not sure this will work but it might be worth giving a try (just hoping you want run into the same limitations).

In SSIS there are several tasks that you can...