Viewing 15 posts - 1 through 15 (of 64 total)
As it turns out, the old linked server had 'Be made using this security context' set within Properties>Security and the new one did not. That has been addressed and now...
December 3, 2020 at 2:45 pm
December 27, 2019 at 12:30 pm
I really appreciate your advice and insight. I can see that XE can be a very useful tool that will highlight any issues over time. I'm going to keep it...
July 26, 2019 at 4:02 pm
I have started the XE. At what point would I stop it?
I'm seeing a few deprecation_final_support notifications in the package0.event_file, but nothing truly alarming.
Thanks for providing the code for this,...
July 26, 2019 at 3:23 pm
C:\Program Files\Microsoft Data Migration Assistant\DmaCmd.exe /AssessmentName="DMA_Output_testmdb" /AssessmentDatabases=
"Server=ServerName;Initial Catalog=testmdb;Integrated Security=true" /AssessmentEvaluateCompatibilityIssues /AssessmentOverwriteResult /AssessmentResultCSV=
"\\sharedrive\InfoSvcs\UserC\ServerName\testmdb.CSV" > "\\sharedrive\InfoSvcs\UserC\ServerName\testmdb.LOG"
July 26, 2019 at 1:34 pm
Thanks for all your responses. The vendor is requiring the compatibility level change to ensure that their Meaningful Use code works correctly. My understanding is that running the DMA will...
July 26, 2019 at 12:04 pm
I think I've got it! The problem was with the flat file connection manager after all.I changed it to Delimited and used a Column delimiter of CR and a...
January 23, 2019 at 11:30 am
I have created a staging table as suggested.
January 23, 2019 at 9:08 am
This is what I have now...My OLE DB Source selects multiple columns concatenated into 1 column, along with EmployeeID and RecordType (E or W respectively)The E records are...
January 22, 2019 at 10:24 am
No nested loop, one batch per file. Here is what the control flow looks like:
And each data flow is simply an sql query writing...
January 22, 2019 at 9:04 am
Thanks for your suggestion and clear demonstration. The issue I am having isn't so much getting different record layouts into a single flat file (I can do that with the headers, detail/E records...
January 22, 2019 at 6:34 am
September 12, 2018 at 7:49 am
I ended up simply using a File System task to delete the output file. I was concerned that the task would fail since normally the file would...
August 3, 2018 at 6:06 am
Thanks for responding Phil. I think the editor mixed things up quite a bit. It does run, and looks much better when I 'Edit Script'I will change the script...
August 1, 2018 at 9:34 am
Are you looking for something along the lines of excel's 'copy down'?
This script (SSIS) will copy values of several fields when one field is empty/blank. If could be...
August 4, 2017 at 10:46 am