Reputation
883
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 26 40
Impact
~237k people reached

  • 0 posts edited
  • 2 helpful flags
  • 62 votes cast
1d
awarded  Notable Question
Feb
1
comment Access denied when trying to run an agent job
@Doug_Ivison Being that this post is from 2012, to be 100% honest, I don't remember the outcome but I am pretty sure it worked because if it didn't then I would have most likely posted back asking for more help. Sorry.
Jan
22
asked SQL Server: Query Efficiency Having vs Subquery
Jan
18
comment SSIS: Check file for row delimiter and dynamicly update row delimiter in Flat File Connection Manager at run time
Update: I just switched my delimiter from {CR}{LF} to {LF} in the Flat File Connection Manager and now all my files load correctly.... the {LF} delimiter in the connection manager works for both {CR}{LF} and {LF} delimited files but the {CR}{LF} delimtier will only work with {CR}{LF} delimited files.
Jan
18
comment SSIS: Check file for row delimiter and dynamicly update row delimiter in Flat File Connection Manager at run time
I just thought of a simple fix for my specific situation. Since I know the delimiter will either be {CR}{LF} or {LF} I can just add a Failure redirect from the dataflow task that fails to another data flow task containing the alternate/correct delimiter.I could also redirect to a task that switches between the 2 different delimiters and then goes back up to the top of the loop so we wont need 2 different dataflow tasks
Jan
18
revised SSIS: Check file for row delimiter and dynamicly update row delimiter in Flat File Connection Manager at run time
edited title
Jan
18
asked SSIS: Check file for row delimiter and dynamicly update row delimiter in Flat File Connection Manager at run time
Jan
12
accepted Is this Normal SSIS Foreach Loop Container behavior
Jan
11
asked Is this Normal SSIS Foreach Loop Container behavior
Nov
16
comment Programmatically finding minimum set of fields necessary to create a unique composite key
That's awesome! Thanks! Definitely going to check it out.
Nov
16
accepted Programmatically finding minimum set of fields necessary to create a unique composite key
Nov
16
comment Programmatically finding minimum set of fields necessary to create a unique composite key
My data will go from my Import table into several other tables and the composite key will serve as a basis of supporting relationships to sibling and child tables. You do bring up several good points which lead me to believe it is probably not worth my time trying to create such a script. Thanks.
Nov
16
comment Programmatically finding minimum set of fields necessary to create a unique composite key
@RLF There should not be any identical rows in the files but I already have a process in place to remove (and store for later review) the duplicate rows leaving only one unique row. I did this since the flat files from different sources are not always reliable as you mentioned.
Nov
16
comment Programmatically finding minimum set of fields necessary to create a unique composite key
I don't want a 3,000 character long primary key... if the script says I only need to concatenate [MemberID], [TrasactionID] and [DOB] to obtain a primary key then that is the key I would like to use to uniquely identify every record in my table. Instead of writing a "having count(*) > 1 query" and adding fields to it 1 by 1 until I get a unique Key, I am trying to come up with a script that will tell me "Hey these 3 fields will give you a unique composite key" that you can use to uniquely identify every record in your table.
Nov
16
comment Programmatically finding minimum set of fields necessary to create a unique composite key
@Max Vernon If that happens then my import process would fail at which point I would need to modify my primary key (probably by concatenating an additional column to the key to make it unique once again). If I had a script that could find the unique key (using available fields) I could do a check before every important to see if our key is still unique or not. I might need to rethink my process as you mentioned but I would still like to find out if anyone has ever used or created such a script. I am starting to think that such a script might use too many resources to be practical though...
Nov
16
revised Programmatically finding minimum set of fields necessary to create a unique composite key
added 10 characters in body
Nov
16
asked Programmatically finding minimum set of fields necessary to create a unique composite key
Nov
11
awarded  Notable Question
Nov
11
awarded  Famous Question
Nov
5
comment SQL Server - DELETE from subquery/derived table
@Max Vernon Worked perfectly (and much better performance), thanks!