Reputation
920
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
6 27 42
Newest
 Yearling
Impact
~267k people reached

  • 0 posts edited
  • 2 helpful flags
  • 63 votes cast
2d
comment Update field in SQL Server Table Dynamicaly
That actually worked! I just joined your code to the code I have to identify the member_numbers that had records that needed to be modified and that's it. Thanks!!!
2d
accepted Update field in SQL Server Table Dynamicaly
2d
revised Update field in SQL Server Table Dynamicaly
added 496 characters in body
2d
revised Update field in SQL Server Table Dynamicaly
edited tags
2d
asked Update field in SQL Server Table Dynamicaly
Mar
13
awarded  Yearling
Mar
1
awarded  Self-Learner
Feb
23
awarded  Popular Question
Feb
11
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.