Viewing 15 posts - 5,491 through 5,505 (of 13,874 total)
June 27, 2017 at 9:07 am
There is no magic wand. Either you need to get agreement that one of the databases is the chosen one and lose all the updates in the other, or you...
June 27, 2017 at 9:03 am
If I cut & paste some bits from the article, and add a few comments, maybe it will clarify things for you.
But my first comment is this: this concept...
June 27, 2017 at 7:15 am
there is no unique id for these records
the data looks like
OrderDate Department OrderProcessedCheckPersonel ...
June 27, 2017 at 7:08 am
This is for SSIS 2012.
I have a bunch of files in a directory that...
June 27, 2017 at 6:04 am
hi
fairly new to SSIS
I have to run an excel sheet every quarter (every...
June 27, 2017 at 6:01 am
OK, here is a way of doing this. There must be a shorter way, but can't think of one right now.
(DT_DATE) (left((DT_STR, 8, 1252) @[User::DateKey],4) +...
June 26, 2017 at 5:10 am
Please read this:
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9f9812c3-56cf-4a76-ad48-fad7b03ad9ac/how-to-pass-filename-as-a-dynamic-variable-to-flat-file-source-in-ssis-?forum=sqlintegrationservices
and confirm that you have set the flat file source dynamically.
June 24, 2017 at 2:36 pm
This thread has taken a strange turn – see the series of posts after Ed's post. I really don't see the issue.
June 23, 2017 at 10:45 am
June 23, 2017 at 6:46 am
June 22, 2017 at 6:01 pm
This is simple in SSIS, and had you posted the question in the Integration Services forum, you would have had an answer by now.
Use something like (untested)
[code...
June 22, 2017 at 5:10 pm
June 22, 2017 at 4:48 pm
From the given filepath need to extract "ABC" from "ABCabcprices-20170621122040.txt".
Conditions : Severname and foldername...
June 22, 2017 at 2:08 pm
Viewing 15 posts - 5,491 through 5,505 (of 13,874 total)