Determine Replication Folder or Data Folder via SQL?

I have an application that has to do the following
1. Disable Replication
2. Run Database Changes Script
3. Enable Replication again.
I have the scripts to enable and/or disable replication, but I was wondering
if there was anyway to retrieve the data, log, and replication folder
directories via sql so that I can use them in my replication sql script
without having to hard code these values.
L Anthony Johnson
Newbie
sp_browsesnapshotfolder @.publication = 'PublicationName' will tell you the
snapshot folder name (as a UNC).
sp_helpdb 'DBName' will tell you the name of the db.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"L Anthony Johnson" <ppsyco2@.nospamm4m3bellsouth.net> wrote in message
news:%23BsT8$McEHA.3016@.tk2msftngp13.phx.gbl...
> I have an application that has to do the following
> 1. Disable Replication
> 2. Run Database Changes Script
> 3. Enable Replication again.
> I have the scripts to enable and/or disable replication, but I was
wondering
> if there was anyway to retrieve the data, log, and replication folder
> directories via sql so that I can use them in my replication sql script
> without having to hard code these values.
> --
> L Anthony Johnson
> Newbie
>

Detect new files and populate date

Hi, I need to create a SSIS package for following usage:

I have a folder called c:\test. Every month, I copy a file with following format testMMYY.txt. (Month Year) from a client (A) for vendor B. I have a sql table which contains filemonth(, clientname and vendorname. How can I create a SSIS package to detect any new files, if any, and populate the month and year into file month, and populate clientname and vendorname.

Thanks,

You can use the FileWatcher task (available on SQLIS.com) to monitor for a file. If it is only a once a month thing, you could just run the package and use the File System task to check for existence of the file. You'll need to use a expression to set the ConnectionString property of your FlatFile connection manager to the correct value by concatenating the proper month and year into the file name.|||

Thanks for the reply.

Maybe my description is a little bit misleading, my issue is to identify latest file and transform the file name, e.g. I0407.txt into April 2007 and insert it into the filemonth field in the vendorfile table.

Any thoughts?

Thanks,

|||You can use a script task and the DateAndTime class's MonthName function to translate the file name. This post (http://forums.microsoft.com/msdn/showpost.aspx?postid=1467831&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1) has the script for sorting the list of files in a directory and outputting in a DataTable object. Just take the last row of the data table for the latest file.

detail view

When opening an RS folder in IE 6 I get a Detail View and must click "Hide
Details" is there a way to make it open in summary instead of detail?
Thanks!
GlenOnce you have clicked on Hide Details you should not see details the next
time you login. Is that not happening for you?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Glen Tosco" <glen@.delnat.com> wrote in message
news:eo1RFJXYFHA.3220@.TK2MSFTNGP14.phx.gbl...
> When opening an RS folder in IE 6 I get a Detail View and must click "Hide
> Details" is there a way to make it open in summary instead of detail?
>
> Thanks!
> Glen
>|||No, it always opens on detail.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23OhhUaXYFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Once you have clicked on Hide Details you should not see details the next
> time you login. Is that not happening for you?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Glen Tosco" <glen@.delnat.com> wrote in message
> news:eo1RFJXYFHA.3220@.TK2MSFTNGP14.phx.gbl...
>> When opening an RS folder in IE 6 I get a Detail View and must click
>> "Hide Details" is there a way to make it open in summary instead of
>> detail?
>>
>> Thanks!
>> Glen
>|||Is your site setup of anonymous access?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Glen Tosco" <glen@.delnat.com> wrote in message
news:%23CT$RngZFHA.3984@.TK2MSFTNGP10.phx.gbl...
> No, it always opens on detail.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23OhhUaXYFHA.3184@.TK2MSFTNGP15.phx.gbl...
>> Once you have clicked on Hide Details you should not see details the next
>> time you login. Is that not happening for you?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Glen Tosco" <glen@.delnat.com> wrote in message
>> news:eo1RFJXYFHA.3220@.TK2MSFTNGP14.phx.gbl...
>> When opening an RS folder in IE 6 I get a Detail View and must click
>> "Hide Details" is there a way to make it open in summary instead of
>> detail?
>>
>> Thanks!
>> Glen
>>
>|||No...
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uxB4U2hZFHA.2128@.TK2MSFTNGP14.phx.gbl...
> Is your site setup of anonymous access?
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Glen Tosco" <glen@.delnat.com> wrote in message
> news:%23CT$RngZFHA.3984@.TK2MSFTNGP10.phx.gbl...
>> No, it always opens on detail.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23OhhUaXYFHA.3184@.TK2MSFTNGP15.phx.gbl...
>> Once you have clicked on Hide Details you should not see details the
>> next time you login. Is that not happening for you?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Glen Tosco" <glen@.delnat.com> wrote in message
>> news:eo1RFJXYFHA.3220@.TK2MSFTNGP14.phx.gbl...
>> When opening an RS folder in IE 6 I get a Detail View and must click
>> "Hide Details" is there a way to make it open in summary instead of
>> detail?
>>
>> Thanks!
>> Glen
>>
>>
>|||I don't have any suggestions. This is very odd. I have never seen anyone
post with this problem before.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Glen Tosco" <glen@.delnat.com> wrote in message
news:uxob8tkZFHA.1152@.tk2msftngp13.phx.gbl...
> No...
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uxB4U2hZFHA.2128@.TK2MSFTNGP14.phx.gbl...
>> Is your site setup of anonymous access?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Glen Tosco" <glen@.delnat.com> wrote in message
>> news:%23CT$RngZFHA.3984@.TK2MSFTNGP10.phx.gbl...
>> No, it always opens on detail.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:%23OhhUaXYFHA.3184@.TK2MSFTNGP15.phx.gbl...
>> Once you have clicked on Hide Details you should not see details the
>> next time you login. Is that not happening for you?
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Glen Tosco" <glen@.delnat.com> wrote in message
>> news:eo1RFJXYFHA.3220@.TK2MSFTNGP14.phx.gbl...
>> When opening an RS folder in IE 6 I get a Detail View and must click
>> "Hide Details" is there a way to make it open in summary instead of
>> detail?
>>
>> Thanks!
>> Glen
>>
>>
>>
>|||Hi Glen,
Is it possible for you to generate a sample rdl file and send it to me? The
sample rdl file is recommanded using defalut database (such as Northwind or
Foodmart?) I understand the information may be sensitive to you, my direct
email address is v-mingqc@.online.microsoft.com (note that "online" is only
for SPAM, remove it before you click SEND), you may send the file to me
directly and I will keep secure.
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.