Forum Replies Created
Viewing 15 posts - 766 through 780 (of 13,460 total)
-
RE: windows authentication login
I know the default is to search for a local windows user related to the server name;
You probably need to change toe location to to browse to find the...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Script task not able to find file on the network drive
mandavli (12/16/2016)
it is UNC path that I am using in the package,with fail as I mean it's not able to find file, even if I have same proxy accounts...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Script task not able to find file on the network drive
mandavli (12/16/2016)
Thank you. Created the proxy and it worked on the native server (where the catalog exists)But when I create a job on a different sql server. it fails, I...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Script task not able to find file on the network drive
did you already configure a credential and proxy operator in SQL Agent?
Did you configure that step to use that proxy operator?
the account that runs the SSIS jobs \is often a...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: SSIS Process only the "Latest" file based on name
both examples were extremely helpful, folks, thank you!
I did it both ways as my proof of concept; I was already leaning towards Phil's example of a script task, but I've...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How to add dates not existing on a table
the key is to generate all possible combinations first..
Basically, you have to select from Your Calendar/Dates table,and cross join all possible employees, and then finally left join it to attendance.
WHERE...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Results to new table
what you are looking for is a Cartesian Product;
also known as a cross join
the syntax is pretty simple:
SELECT * FROM #Table1
CROSS JOIN #Table2
in the future, if you want the...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: 7 zip creating an additional folder named "+"
dndaughtery (12/13/2016)
Hey guys, I'm using an execute process task to unzip a password protected zip file. I'm able to unzip and create the file in the target folder but it...Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How to check if S.P. is included in server startup?
I think it's a column descriptor in master.sys.procedures;
I've confirmed that my proc, which sets specific trace flags, shows up in my results:
sp_set_traceflags --this is mine!
sp_ssis_startup
sp_MSrepl_startup
SELECT *
FROM master.sys.procedures
WHERE [procedures].[is_auto_executed]...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: ReportServerTempdb log file is full
i believe it's suffering from the classic error: recovery mode is FULL recovery, someone took at least one full backup, and no one has ever run a log backup, nor...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Create multiple Basic Availability Group SQL 2016 standard edition
pretty sure standard edition featureing multiple Basic Availability Group is supported, and if you have multiple databases, that kind of forces you into having to design one db per group.
...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: MCSA 2012 or 2016?
I got my SQL2012/2014 MCSA in May 2016, which was probably a month before SQL2016 RTM came out.
The official books for the three new SQL 2016 MCSA come...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: How do I SELECT DISTINCT on a field into a new table while including all columns?
row_number featuring partition by will do what you are asking;
here's an old example, but you can see you get all the other values but it's logically grouped by the...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Can I have a default table value based on another column???
jbalbo (12/8/2016)
Thanks for the quick response and sorry for the lack of explanation on my part!!I am using a Bulk insert via a txt file and...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
RE: Can I have a default table value based on another column???
yes, but you need a case statement to bulletproof the calculation for data shorter than your assumption.
CREATE TABLE EXAMPLE (
ExampleId int IDENTITY(1,1) NOT NULL PRIMARY KEY,
MyColumn varchar(30)
)
INSERT INTO EXAMPLE(MyColumn)
VALUES( ''),('1234567890')
ALTER...
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
Viewing 15 posts - 766 through 780 (of 13,460 total)