I have two reports , one is for internal users and another one is for external users, For internal Users i need to enable form authentication to view the report instead of creating the user accoun...

I am setting a variable in SSIS package and I'm using this expression: DATEPART("yyyy", GETDATE())*10000 + DATEPART("month", GETDATE())*100 + DATEPART("day",GETDATE()) The expression will gi...

I am new to SSIS and having trouble passing parameters to OLE DB Source. I want to query data for a given date range. I have two variables, variable1 of data type Date Time and the value of the var...

Can anyone say the Difference between ADO NET source and OLE DB Source in SSIS 2008 ?are they both same in any context ?