fill down formulas without selecting the sheet

At the moment I have a bunch of formulas along the top row of a sheet and I
wish to copy them down a predfined number of rows. At the moment I activate
the sheet and then select the rows I want to copy down with the row
containing the formulas at the top. It would be much er if I could
accomplish this in the background as it were without having to select the
sheet. Is there a way of effectively filling down the formula without having
to activate the sheet?
Any help much appreciated, kind regards, MarkAre you sure you posted in the right NG ? That should go for the excel ng as
I hear from your problem ?!
--
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Mark Stephens" wrote:

> At the moment I have a bunch of formulas along the top row of a sheet and
I
> wish to copy them down a predfined number of rows. At the moment I activat
e
> the sheet and then select the rows I want to copy down with the row
> containing the formulas at the top. It would be much er if I could
> accomplish this in the background as it were without having to select the
> sheet. Is there a way of effectively filling down the formula without havi
ng
> to activate the sheet?
> Any help much appreciated, kind regards, Mark
>
>

FileSystemTask->Size limitation?

I am using FileSystemTask to copy around 4 gb file(ASCII). Is there any limitation on the file size.

SQL Server 2005 SP2, Windows 2003 server. Copying from one Windows 2K server to other Windows 2K server.

Thank you,

As far as I know, there is no limitation. Are you getting any error?

|||We are copying files much larger than this. What error are you getting? could it be that you have run out of space on the destination?|||

Currently I am not getting any error messages.

Same file copy operation is not working fine right now in DTS package. So we decided to move this part of the flow to SSIS.

I was making sure any known size limitation if at all in SSIS.

Thank you all for your answers.

filegroups in sql server...

hi all,
i have a problem with creating filegroups in sql server...i just want to copy the names of the columns from one table into my filegroups...

this is my problem : i m writting the following code in tsql:

SELECT * INTO Sales FROM Sales1 WHERE 0=1 ON [MyFG1]

Can anyone please help meeee?? i'd like it to work this way, to copy only first column names from Sales1 to Sales but in this filegroup.

if this is not the write way...then can anyone please tell me the right syntax and the way to copy just the names into a filegroup???

thanx in advance.
Regards.why not just use the ON FILEGROUP argument of the CREATE TABLE statement to create your table first and then do a INSERT INTO?|||i have some idea like this :

CREATE TABLE NewTable ( something here to copy just column names) ON [MyFG1]

usually when column names are sfpecfied this works normally, but as i said i have to copy them from some table not specify, so if anyone knows how to fill this part in barckets please tell me



thanx a lot|||run a dynamic sql that will call a function which will return a string of the table structure that u want to create

declare @.sql varchar(1000)
set @.sql='create table NewTable ' + dbo.ReturnStruAsString('OldTable') + ' ON [MyFG1] '
execute ( @.sql )

file/filegroup backup vs copy the mdf, ndf, ldf file directly

Dear all,
I have a question about the difference between file/filegroup backup and
copy the mdf, ndf, ldf file directly
1.) If i copy the mdf,ndf,ldf file and then replace the file(recreate the db
with the same name) to the sql server, will it works and ok, what is the
difference with backup file/filegroup backup?
2.) if i backup with sql script backup (select all object), is it the same
output with full backup?1.) The only way to safely copy the files directly is to detach the
database first. That means you must take it off line. A backup does not
require you to take the db offline.
2.) The generate script is simply the DDL to recreate the database and
does not contain the data. It is not to be used in place of a backup.
Andrew J. Kelly SQL MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:299DA939-7562-4546-B4A1-15F7CA2D8881@.microsoft.com...
> Dear all,
> I have a question about the difference between file/filegroup backup and
> copy the mdf, ndf, ldf file directly
> 1.) If i copy the mdf,ndf,ldf file and then replace the file(recreate the
> db
> with the same name) to the sql server, will it works and ok, what is the
> difference with backup file/filegroup backup?
> 2.) if i backup with sql script backup (select all object), is it the same
> output with full backup?
>|||Script backup does not have data?
"Andrew J. Kelly" wrote:

> 1.) The only way to safely copy the files directly is to detach the
> database first. That means you must take it off line. A backup does not
> require you to take the db offline.
> 2.) The generate script is simply the DDL to recreate the database and
> does not contain the data. It is not to be used in place of a backup.
> --
> Andrew J. Kelly SQL MVP
>
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:299DA939-7562-4546-B4A1-15F7CA2D8881@.microsoft.com...
>
>|||Now I am not sure what you are referring to. There isn't a way to directly
generate a backup script that I know of. Can you explain exactly how you
get to the script?
Andrew J. Kelly SQL MVP
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:786D0922-017D-41AE-A915-63F76799F77E@.microsoft.com...[vbcol=seagreen]
> Script backup does not have data?
> "Andrew J. Kelly" wrote:
>

File System Task - relative location ?

hi,

I am using "File System Task" to copy files from one pre-defined location to another.

Is there a way to provide a "relative path" for the corresponding connections? If yes, how to set it up for deployment?

If not, I guess the option will be to update the "connection string" property for the file connections using package configurations.

thanks,
NiteshAnother option is to store the "root" location in a folder (it can be populated from a configuration) and you can then use property expressions on your file connection manager connection strings to use that variable.

-Jamie

File System Task

hi friends

I PLACED A FILE SYSTEM OBJECT WICH IS USED TO (COPY FILE/MOVE FILE SO ON )

Once copy file working fine second time copy file gives an errors

we need to check the condition if that folder contrain the dest.txt file we dont require to copy a file

other wise we need to copy

so i need a controle for checking a folder contrain the dest.txt file or not

regards

koti

Hi Koti,

You need to check whether the file already there or not. You can use File.Exists("dest.txt")=False. if it returns false then you can proceed with your Copy process.

Atanu

|||

ok but in my desk top contain the check dir exisit or not i have to check

variable contrain this path ok

check_dir = C:\Documents and Settings\Koteswara.Chava\Desktop\check\one.txt

I was written the code here ok then Please

Dim DTSVariables As Variables

If System.IO.File.Exists((CStr(DTSVariables("check_dir").Value))) Then

MsgBox("YES FILE EXIST")

Else

MsgBox("NO FILE NOT EXIST")

End If

PRE COMPILED BINAY SCRIPT NOT EXIST ERROR I AM GETTING BROTHER

REGARDS

KOTI