May be this way:

SELECT Sum(query.Counts) AS Total

FROM (

SELECT C1.ID, C1.Name, Count(*)as Counts

FROM ClassifiedsView_Ads AS CA

INNER JOIN Classifieds_Categories AS C1 ON CA.CategoryId = C1.ID

INNER JOIN Classifieds_Members AS M ON CA.MemberID...

Paul Turley, Joe Kasprzak, Scott Cameron (and others), Microsoft SQL Server 2005 Integration Services Step by step.

Change function definition to:

create function dbo.mycustomertest (@code varchar(10))

returns table

as

declare @sqlCmd nvarchar(4000)

select @sqlCmd = (case when @code= 'brm' then 'select * from

dbo.employee ()'

when @code='crm' then 'select * from dbo.myorder()'

else 'unknown'

end)

exec...

Please try to explain what you want to do. Are you want to write C# application which executes SSIS packages or anything else?.

So please correct me if I do not understand.

If your code looks like that:

then it rise error?

What is...

You must use Script Component with transformation type, two outputs with SynchronusInputID set to none (for example ValidEMail and NotValidEMail) and with one column for each output (ValidEmail for ValidEMail...

Try to use Data Conversion component from Data Flow Transformation toolbar.

I think you must read this thread:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=61765&SiteID=1

Try to change protection level to EncryptAllWithPassword and set password for the package. And next deploy it on production server.

I think the best way is to use SQL job. SQL 2005 has special step type: SQL Server Integration Services Package.

Password is not saved in the connection dialog but it is saved internally and SSIS can connect to it without any problem.

I think the best way is to use Script component (transform type) with asynchronous output.

I think if your package does not generate any error then all record are successfully transferred from source to destination (assuming there is not no additional logic between source...

It is not good practice to issue SELECT * FROM statement (btw it can take the long time for the...

Try to use...