Viewing 15 posts - 3,181 through 3,195 (of 13,855 total)
Hello, I'm not sure if I'm even phrasing this correctly, so please excuse lame or novice comments 🙂
Infor: GL Account numbers have a location identifier. For example position 11-13...
October 29, 2019 at 10:35 pm
Seems like a lot of work.
Presumably you have considered:
...
October 29, 2019 at 1:30 pm
Hello. I want to get address a folder like "D:\MOVIE\March 2019" in SQL SERVER DATA TOOLS and zip that folder and then copy it to the desktop after zipping?...
October 29, 2019 at 1:25 pm
i have a variable value that coming from batch file as N and Y
in the package i kept hfcol as string . there is another variable in the package...
October 28, 2019 at 8:49 pm
Simple join on the ID columns, use sum and case for the amounts. Give it a try and post your code if you are still having trouble.
I don't think...
October 28, 2019 at 8:33 pm
I've been working on this package which is a copy of an existing one (tables are different, flat file locations & names are different, but otherwise the packages are...
October 26, 2019 at 11:05 pm
The (admittedly obscure!) intention of my post was not to criticize your response, but to highlight the fact that in making things dynamic, SSIS slides out of the...
October 24, 2019 at 10:13 pm
That is true that it doesn't relate to SSIS directly. My intent with the post was to determine what the end result was and if SSIS could handle it...
October 24, 2019 at 9:50 pm
sorry for presenting it poorly, according to the technical requirement document we cannot use separate inserts and updates and need to use Merge for better performance.
If performance is the...
October 24, 2019 at 9:27 pm
This sounds like it could be handled by linked servers and some dynamic SQL and some fun stored procedures to gather all of the schema level data and compare...
October 24, 2019 at 9:05 pm
This is an overly cumbersome query. Please explain why everything has to be done in the same code batch.
"This is a business requirement" is not an explanation.
October 24, 2019 at 9:02 pm
You could do the inserts and updates separately and then just interrogate @@ROWCOUNT ...
October 24, 2019 at 8:38 pm
SSIS detects nothing.
If a stored proc changes, SSIS will attempt to use the modified version.
If the inputs and outputs to the proc are unchanged, but the internal logic has been...
October 24, 2019 at 8:23 pm
A new schema? You mean this?
CREATE SCHEMA abc AUTHORIZATION dbo;
That would have no effect whatsoever on existing SSIS packages.
October 24, 2019 at 8:09 pm
Thank you. So for instance, if I have an SSIS package that is looking at Table1 which has 5 columns in it. Then, when the package runs via scheduling...
October 24, 2019 at 8:04 pm
Viewing 15 posts - 3,181 through 3,195 (of 13,855 total)