Viewing 15 posts - 1,771 through 1,785 (of 6,679 total)
Try to output to a flat file - comma-separate values and see if that works better.
June 13, 2020 at 3:59 pm
How are you exporting the data - what were the options you selected in the export wizard? It should not preface a field with a single-quote like that...
It looks like...
June 12, 2020 at 3:40 pm
That is why I stated either the /quiet or /passive arguments - which depend on the version you are installing. For the 2010 version you have to use the /quiet...
June 12, 2020 at 3:36 pm
This is not the appropriate way to create files from SQL Server. You can use BCP to output the data to a file - or SSIS - or export an...
June 11, 2020 at 7:27 pm
Just my opinion - but I would not utilize an AOAG with Standard Edition for anything other than DR. For an HA solution I would stick with a standard FCI...
June 11, 2020 at 6:16 pm
What is the purpose of outputting the results of the job to text?
June 11, 2020 at 6:02 pm
How are you running the SSIS package *manually*? What are the exact steps you take?
When you run the package from SSDT/VS - do you get this error?
How are the connections...
June 11, 2020 at 5:55 pm
It all depends on how you execute the package - if you try to run the package within SSDT in debug mode it runs as a 32-bit application. In fact,...
June 10, 2020 at 10:27 pm
Is the code that is executed in these packages trying to use a linked server? If so - then the only way to fix that is to setup and validate...
June 10, 2020 at 10:09 pm
Which one of the rows for BAG-CV do you want? The calculation you have here is going to produce a different result for each row - so how can you...
June 10, 2020 at 10:01 pm
Just tried it (accessdatabaseengine_X64.exe /passive for the 2016 version) and it seemed to work - at least, it didn't genertate any errors. I don't know how to check whether...
June 10, 2020 at 9:56 pm
Well yes, but that's not really the point. The package which the import wizard generates has no bitness and is executed by DTExec.exe, which has both 32- and 64-bit...
June 10, 2020 at 9:48 pm
- Replace 32-bit Office with 64-bit Office
- Install the 64-bit version of the 2016 ACE driver
- Install the 32-bit version of the 2010 ACE driver
<li style="list-style-type: none;">
June 10, 2020 at 8:02 pm
It sounds like a problem on the destination - I would suspect something is blocking the insert into that 2005 instance once you exceed a certain number of rows.
Are you...
June 9, 2020 at 6:34 pm
Not sure why you are messing with the JSON files - they provide the files in text or Excel format. From this page: https://www.fda.gov/drugs/drug-approvals-and-databases/national-drug-code-directory
Unless your report is limited to a...
June 9, 2020 at 5:09 pm
Viewing 15 posts - 1,771 through 1,785 (of 6,679 total)