jjafer (1/31/2009)

I want to trim the white spaces in a string that is used within Join function.

Join (TRIM(Parameters!vnd_name.Value),",") fails with the following error,

[rsCompilerErrorInExpression] The Value expression for the textbox ‘textbox2’...

You need to do the following steps

1. Add 1 Data Flow Task

2. Inside that Data Flow, Add 1 Excel Source & 1 OLE DB Destionation

3. Set Source & Destination Connections

4....

Does FromDate & ToDate span across more than 1 day?

Chris Morris (1/30/2009)

Ramesh (1/30/2009)

Chris Morris (1/30/2009)

Not only is it late afternoon,...

Thanks for the feedback, but make sure to post your queries in appropriate forums...

Do you mean converting the source or destination to NVarchar(max)? 'Cause I don't think so its possible to convert to NVarchar(max) in SSIS? Or may...

Chris Morris (1/30/2009)

Not only is it late afternoon, it's friday and...

Here is an excellent build list SQL Server Build List, includes ALL builds of ALL versions of SQL on a single page with links to respective KB article....

All Thanks to...

You should see the options "Import Data..." OR "Export Data..." under Tasks option of Database..

Thanks David, that was indeed excellent... ALL Builds, ALL Versions...

Have you heard about CASE statements? Here is how to make use of it....

SELECT

Region,

SUM(xValue) as 'Total' ,

SUM(xValue2) as 'AnotherTotal' ,

--COUNT(TestID) as 'Count' -- need to only 'COUNT'...

There are many ways to do it...

1. Import Export Wizard

2. SSIS

3. Command Utilities such as BCP, SQLCMD etc.

4. Linked Servers

Cross post, continue discussions HERE

Actually, the latest build is 10.00.1787.00

See this article SQL Server 2008 Build List[/url] on this site

Why did you post it in SQL 2005 forum, in first place? It just wastes posters time....

For the solution, I don't have much knowledge in ACCESS, but something like...