Agree much less costly to just do a if exists (select top 1 from tablename)

I just noticed you are using the import/export wizard which I have never had luck with working right. I have always had to edit the package afterwards and go...

Is the source a table or a query?

I use a slightly different query. I like to get the rows from the sys.dm_db_partition_stats

SELECT

so.name as TableName

,ps.row_count as TotalRows

FROM sys.dm_db_partition_stats ps

LEFT JOIN sys.objects so

ON ps.object_id=so.object_id

WHERE

so.name='TableName'

and ps.index_id =...

Here you go

declare @test-2 varchar(20)

set @test-2 ='30/04/2015 23:59:59'

select CONVERT(datetime, @test-2,103)

In that case I would change the script task to be a script source component in the data flow task. That way the output from the webservice would already...

Are you only inserting a single row that is just values stored in package variables?

You can use a derived column task and use an expression like this where [date] is the column name

(DT_WSTR,4)YEAR((DT_DATE)[date]) + "/" + RIGHT("0" + (DT_WSTR,2)MONTH((DT_DATE)[date]),2) + "/" + RIGHT("0" +...

What is the data type of the column coming from the test file?

SSIS can do this. Performance will depend on how many columns your are comparing? Are you just trying to do a join on keys or is it a...

You might want to check out Aaron Betrand's article on dynamic PIVOT.

http://www.mssqltips.com/sqlservertip/2783/script-to-create-dynamic-pivot-queries-in-sql-server/

Depending on how you are trying to use the values the more appropriate variable may be a Table Variable and something like this.

DECLARE @w_man TABLE (

[Name] Varchar(50)

);

INSERT INTO @w_man ([Name])

SELECT...

Kevin,

I guess it's out of habit when working with fields and searching for actual text and wanting to eliminate white space from the beginning and end. No real purpose...

when you cut and pasted did you put it into an editor that can show ASCII characters? Just want to make sure there isn't something like a CR...