Are you using a for each loop and adding the filename as a variable which you can then use to input into the log table? You could then use that...

Is the store number known at all or is it only available by looking at the filename? if only from the filename are all filenames in the format [StoreNumber]file.csv?

Catherine

A really good description of how to do this can be found at:

http://msdn2.microsoft.com/en-us/library/ms141214.aspx (this one is a little wordy - but gives you a detailed explination)

http://www.sqlnerd.com/ssis_dynamic_dates.htm (much better with screenshots...

What type of replication are you using? With Merge Replication you can setup a publisher to become a distributor.

Catherine

You may also find that if the login you are using to run this is a SQL login - it may need to be added to the sysadmin role.

Catherine

On the general Tab of the Schema Properties (within the actual database) there is a Schema Owner field and a Search button. Search to who you want your Schema to...

It really depends on how many changes are made during the day to your system and what type of connection you have to the second server that the replicated data...

I should also mention that the SQL user is a network user that has permission to access the network share. This worked prior SP2 upgrade.

Thanks,

Catherine

I actually found this site really helpful:

http://www.auditdatabase.com/Index.htm

They have an online too that you can input your table definition into and it spits out scripts to create triggers...

You need to further aggregate this result set. wrap the select statement you have so far in the followng

Select Sum(monthly) as monthly, Sum(Annual) as Annual, Day

From ({your  current SQL statement...

If you work out how to do this in SSIS please let me know as I need to do a similar thing - but connecting to Exchange Contacts. I was...

No Worries! Glad to have been able to help!

You could also do this using a group by statement:

SELECT PartnerLeadTypeID, PartnerID, LeadTypeID, isActive, AllowedStates, RestrictedStates, CreditHistory, LoanAmount, PropertyValue, LoanToValue, PropertyType,

RestrictedCityState, SoftCap, HardCap, HasLender, HasAgent, FoundHome, Bankruptcy, ProdPostURL,

count(*) as...

I had to do a similar thing but creating individual files for each order, using the order number as the filename. I will explain how I did this so it...

You can use variables in the For Each Loop to keep track of which file you are currently accessing. This will allow you to then access those variables within your loop tasks.

See...