I got the code working properly.

The code worked for sometime ...

then it stopped working.

It gave me these extracts SSIS570.html where 570 is the ID passed as a parameter.

After testing it a couple of times it...

Already tried that...still getting an error...

Msg 139, Level 15, State 1, Procedure usp_Names, Line 0

Cannot assign a default value to a local variable.

Msg 137, Level 15, State 2, Procedure usp_Names,...

Did what you suggested...still throws an error...

Here is the code I tried executing...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @sqlquery VARCHAR(100) = 'select * from Table where ID=@ID';

Select...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @sqlquery VARCHAR(100) = 'select * from Table where ID=@ID';

SET @sqlquery = REPLACE(@SQLQuery,'@ID',@ID);

Select @TaskOutFile = 'C:\SSIS' +@ID + '.html'

EXEC sp_makewebtask...

It still throws an error...

ALTER PROCEDURE [dbo].[usp_Names]

(@ID int)

AS

DECLARE @TaskOutFile VARCHAR(255)

DECLARE @sqlquery VARCHAR(100) = 'select * from dbo.Table where ID=@ID';

SET @sqlquery = REPLACE(@SQLQuery,'@ID',@ID);

Select @TaskOutFile = 'C:\'...

It gives me this error ...

Msg 137, Level 11, State 1, Line 0

[Microsoft][SQL Native Client][SQL Server]Must declare the scalar variable "@ID".

Msg 16805, Level 11, State 1, Procedure sp_makewebtask, Line 131

SQL...

Can I do something like this ?

Get-ChildItem -path $Directory -recurse -include *.txt | ForEach-Object {Start-Process -FilePath $_.fullname -Verb Print -PassThru | %{sleep 5;$_} | kill }

Get-Process | Output-Printer "\\Print1\ABC01"

where ABC01...

.

Can anyone assist me on my above 2 questions regarding autoprinting from SSIS

So when the new root is created it contains 2 pointers to the split up old root(s).Is that right?So each time a new level is added the old root is...

Does the data move to a new leaf level whenever a new extent is created to insert new data which does not fit into the existing extent/page?

Lets say there are...

"If you want to make it user controlled via a report object then you will need to look at writing an external assembly and embedding it into the report."

Would it...

I got the above script working.But now I only have the servername and the version in the database.I would like to have the following details as per the below t-sql.

SELECT@@servername...

insert into Table

SELECT@@servername as Servername,name as DBName,[crdate] AS [LastStartupDate]

FROM[master].[dbo].[sysdatabases]

WHERE[name] = 'tempdb'

and [Test].[dbo].[Table].LastStartUpTime < [master].[dbo].[sysdatabases].crdate

It gives me this error now:

Msg 4104, Level 16, State 1, Line 1

The multi-part identifier "Test.dbo.Table.LastStartUpTime" could...