Regarding Subfolder

Nov 14, 2007

I would like to copy daily backup files from different folders to new location. The folder structure looks like this:

C:ackup database1database1_db_20071114.bak
database2database2_db_20071114.bak
msdbmsdb_db_20071114.bak
....

But I do not want to copy the backup file from some system database folders, say MSDB, so I have to choose some user database folders. What should I do? How can I extract the subfolder name from variable?

Any suggestion would be appreciated.

View 1 Replies


ADVERTISEMENT

Regarding Subfolder In SSIS

Nov 14, 2007

I would like to copy daily backup files from different folders to new location. The folder structure looks like this:

C:ackup database1database1_db_20071114.bak
database2database2_db_20071114.bak
msdbmsdb_db_20071114.bak
....

But I do not want to copy the backup file from some system database folders, say MSDB, so I have to choose some user database folders. What should I do? How can I extract the subfolder name from variable?

Any suggestion would be appreciated.

View 3 Replies View Related

Maintenance Plan Subfolder

May 27, 2008

Does anyone having the same problem mentioned here,
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99589


Does anyone know what is the cause? This problem comes in one of the SP1 server. I have other SP1 servers where this problem doesn't come.

------------------------
I think, therefore I am - Rene Descartes

View 5 Replies View Related

Deploy Packages To An MSDB Subfolder

Nov 21, 2005

In SSIS you can create subfolders in the MSDB folder. However, when deploying a SSIS solution to the server, it seems you cannot specify a subfolder. When selecting MSDB as the target, all packages in the solution end up directly underneath the MSDB folder.

View 4 Replies View Related

How To: Deploy Packages To A Subfolder Under MSDB Using Deployment Wizard

Jan 21, 2006

Hi ,

I'm deploying the packages to SQL Server using the deployment utility. It goes through. However i wish to organize the packges into folders on the SSIS Server -> MSDB.

I'm able to create folder under the MSDB node. By default "Maintenance Plans" exists. But while deploying the package to the server i'm unable to specify the folder into which the package to be deployed.

Is this a known gap in the deployment wizard or am i missing something?

MTIA.

View 2 Replies View Related

Integration Services :: How To Traverse Files Under Subfolder Using Folder Option

Apr 29, 2015

My files are stored as Newborn.txt under each year's subfolder, How to implement this.

Eg: C:RaviN90Newborn.txt
  C:RaviN91Newborn.txt
C:RaviN92Newborn.txt
C:RaviN93Newborn.txt

How to read the files using the for each loop container"

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved