Viewing 15 posts - 16 through 30 (of 153 total)
good call, let me see about setting it and re-write, will let you know.
September 29, 2020 at 3:08 pm
thank you that fixed it 🙂
September 24, 2020 at 2:15 pm
no, how do i set that in SSIS? specifically for a Execution SQL Task?
September 24, 2020 at 1:43 pm
nope, no line break what so ever... thanks, i am right going to create my own backup script. thanks
July 31, 2020 at 9:31 pm
cool thanks Steve, Also we are on VM, so not sure if putting it on separate Drives would matter, but should i try doing it on configuring to backup separate...
July 22, 2020 at 3:38 pm
lol I was going to host a counter strike server on our SQL server, but I decided to wait till my movies were downloaded 😛
but if you have any idea,...
July 22, 2020 at 1:21 pm
Gotya thank you Steve for that info, good security best practice, thanks again for taking the time to answer 🙂
June 10, 2020 at 9:16 pm
cool thanks Steve, i will try this out, just curious, have you tried creating a few on a database and fully qualified it with a replicated database and able to...
June 9, 2020 at 5:51 pm
hey SSC Guru, thanks for the info, yes trying to make SQL server D centralized as this will be the datawarehouse, and needs real-time data.
I did find some examples online...
June 8, 2020 at 6:05 pm
big thank you again sir 🙂
May 18, 2020 at 6:53 pm
shoot really sorry, i hit report by accident and meant to hit Reply...
May 18, 2020 at 5:56 pm
hello, so I never got the excel to work properly, however what I did instead was change from xlsx to csv, and it works consistently and fine. work around I...
May 15, 2020 at 7:10 pm
ok Phil first off, thank you thank you... for taking the time... i found the problem... and yes i am going to take myself out back and beat myself over...
May 11, 2020 at 2:45 pm
ya no problem:
Data Source=C:\test\Test_Import.xlsx;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties="EXCEL 12.0";
that is what I have.
May 11, 2020 at 2:38 pm
gotya, sadly still didn't work, still same error message, attached the screen shot 🙁
I rebooted my laptop to make sure the excel file that is on my C drive, and...
May 11, 2020 at 2:17 pm
Viewing 15 posts - 16 through 30 (of 153 total)