Hi All,

Thanks for Info...

Yes, two different Machines..

For logins i have below link

http://support.microsoft.com/kb/246133

I am almost done with Logins & Restore of DB's.

need to Generate script for all Jobs and...

Hi,

The following code has been Used in a script which will run continuosly During day.The SSISPackage is a job which already existing package on SQL server.

It will stopped by itselef...

Right click on the Database. Select Tasks-> Import data

The wizard will take U step by step.

Select excel as Datasource.

Hi,

U should give only one parameter.

Please look into the following Example....

Declare @SQLString1 NVArchar(Max),@SQLString21 NVArchar(Max)

SET @SQLString21='Select * from sysobjects where type=''V'''

Set @SQLString1='Select * from sysobjects'

EXECUTE sp_executesql @SQLString1

EXECUTE sp_executesql ...

Thanks for info...

How to find Length of Report....

Does it mean in design

Thanks for info...

But we know the shared path on the server only...not the drive path exactly...

I got the info that the problem was with the SQL Service account not having...

use and

ColumnName => '01/10/2010 and ColumnName <= '25/10/2010'

take care abt DateTime storing in table and comparison/condition also in same format 103/101/ yyyy-mm-dd

http://blogs.techrepublic.com.com/datacenter/?p=237

This link solved my problem

😀

Can you please post the error.....

Hi,

Use Script Task go to design script

U can write C# or VB Script for the same

Cheers!

Sasidhar Pulivarthi

Hi,

Thanks for help....

Is there any way to find the size of the file using SQL /T-sql command .

I am executing a procedure in step1 which O/P is inserting into \\......\....\filename.txt

I...

Hi,

I have created Packega in BIDS 2008

But the SQL server is of 2008 and having 2005 Integration services.

So how can i deploy this package and run in SQL job.

Thanks,

Chowdary

Hi Phil,

Its NT Bacth Job....

I am going to convert it into SQL job.

While the Script does not prompt i/p value for executing corresponding Procedure if its by SQL job

If i...

Hi,

Right Click on the Database->Tasks -> Import data

you can import data from excel to the Table_A with mapping options.

or U may go with SSIS

--

Sasidhar Pulivarthi

Hi,

-> Open table design in SSMS.

-> Select "Owner_Id" column and see the property at bottom side.

-> You can find "Identity specification". set it to "Yes".

Thanks for Info.....

It...