S.P.E.C.I.A.L

Cross posted follow on question

http://www.sqlservercentral.com/Forums/Topic1732853-391-1.aspx

C:\Program Files\WinRAR\rar.exe a -r C:\bcp\customers.rar C:\bcp\Customers.csv

http://comptb.cects.com/using-the-winrar-command-line-tools-in-windows/

More than one way to skin a cat and much more slicker, guessing you just get stuck in the ways you have done it in the past.

Employees

Can you not call WinRAR from the command line with another xp_cmdshell call to the rar exe and pass in the file and archive into the string?

Hopefully you have something that is joins both tables together, customer ID, that is unique to a particular customer.

create table #customer

(id int, name varchar(10))

create table #logs

(custid int, checked datetime)

insert into...

Something like this

declare @RequestDate datetime = '2015-11-02', @DecisionTime time = '13:29:21.357'

select @RequestDate , @DecisionTime

select

CONVERT(DATETIME,

CONVERT(VARCHAR(10),@RequestDate ,103)

+' '

+CONVERT(VARCHAR(12),@DecisionTime )

)

Try -t^~

Guessing the ~ is a command line special character like | and it don't like it, the ^ treats the ~ as an escaped character.

Not much info to go on there.

Please post screenshots, error messages, output logs etc

Missing MSI files where, in the service pack, in the base install

Guessing the Service Pack didn't download correctly, have you tried re-downloading

Correct, if your server allows Windows authentication that's the better option.

Otherwise your talking about adding 2 parameters to the script to prompt for username and password then using them to...

Two options, if you want to use SQL authentication and pass in a username and password you would need build the connection string dynamically. Saves storing the username and...

Cane

Two datasources, two datasets then join with a lookup between both datasets in the tablix