Maybe have the two destinations set up in connection manager.

You can then run a count in a SQL task that in turn populates a variable. You then have two...

Thanks for the reply Steve and yes we did go through the 'if only we had 2012' process!

These are not my scripts but I have tested and they might give you a start..

This script will give you the last status of a job, whether success or failure...

Not in T-SQL I am afraid but we have recently utilised WINSCP via the command line to SFTP to a client site inside an SSIS package and that was pretty...

Stop SQL service

Start SQL in single user mode via command prompt with -m, essentially this allows any member of the local admins group to connect as a member of the...

I would be tempted to load both spreadsheets into two sql tables then output matches to a new spreadsheet based on a join but that is because I am much...

Yup, just had a play...

DECLARE @TestClient varchar(11);

DECLARE @SQLString nvarchar(500);

DECLARE @ParmDefinition nvarchar(500);

SET @TestClient = 'somevalue';

SET @SQLString = N'EXEC [database].dbo.Test @Client'

SET @ParmDefinition = N'@Client varchar(10)';

EXECUTE sp_executesql @SQLString, @ParmDefinition, @Client = @TestClient;

Sorry Jeff, misunderstood!

Just to run a sproc you can of course edit it to look like:

SET @Param1 = 'somevalue';

SET @SQLString = N'EXEC [db].dbo.

' + @Param1

EXECUTE sp_executesql @SQLString

But...

slightly edited the query from msdn, hopefully will help you out:

DECLARE @IntVariable varchar(10);

DECLARE @SQLString nvarchar(500);

DECLARE @ParmDefinition nvarchar(500);

SET @IntVariable = 'somevalue';

SET @SQLString = N'SELECT *

FROM [database].dbo.

...

Am I right in thinking that the optimise for ad hoc workloads option is preferred for high usage of non-parameterised queries?

http://technet.microsoft.com/en-us/library/ms143506(v=sql.100).aspx

If you are looping through a folder using a for each container you could use a script task to check for the substring and set an appropriate condition for whether...

I have ran into this problem when using SSIS to insert delimited columns into a table. Didn#t need to free cache space.

The issue was an incorrect file structure, it...

Jeff Moden (3/21/2013)

I'll go ahead an disagree with that. I've built some killed...

SSIS is normally utilised when the copy/move is complex, if it involves data transformations, validations etc.