Well Said...True innovation knows no bound...But to add from my side...

Let's make this method fool-proof:

Using Try-Catch-Finally block you may add exception handling in the code module.

(rather than uisng generic exception...

Hi,

What you can do is hide the header/footer using their visbility property and toggle them as and when required:cool::cool::cool:

You may also use the Environment variables to store your variables

You may also use the Environment variables to store your variables

Hi,

Please follow the following link

http://support.microsoft.com/kb/209805

Hi Edwin,

Please chk the following link:

http://consultingblogs.emc.com/jamiethomson/archive/2005/11/15/SSIS_3A00_-What_2700_s-the-difference-between-DT_5F00_DATE-and-DT_5F00_DBTIMESTAMP.aspx

Hope this helps.

Well said....

Hi,

I would like to suggest two points when ever you use Excel as a source data stream:

1. Always append IMEX=1/0 to your connection string respectice to the kind of data...

SELECT MIN([Salary]) FROM [SSIS].[dbo].[Salary] where salary in (SELECT DISTINCT TOP 4 [Salary] FROM [SSIS].[dbo].[Salary] ORDER BY [Salary] DESC )

Hope this helps

Hi,

In the Script Task Component you will find a property by the name "ScriptLanguage"

This property can be set to either C# or VB

Hi Niranjana,

The above post should help you....incase you...

Azam,

I am sure you are aware the applicablility of these technologies...i.e. the area of application.

I am a BI Developer so the only suggestion I would give you is make your...

Vineet,

A word of caution though,

Considering the current scenario a professional approach would not be to use MD5 hashbyte...the reason being the overhead of converting every row of selected data to...

vineet1234 (6/22/2010)

Raunak Jhawar (6/21/2010)

Even better...I remeber there was...

Even better...I remeber there was an article posted...