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
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
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
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
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
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